Forum OpenACS Q&A: Starting/Stopping individual PG database vs database cluster

1: Starting/Stopping individual PG database vs database cluster

Posted by Robert Hammond on 05/03/06 08:37 AM

Using Postgres, is it possible to start/stop an individual database instead of the entire database cluster?

For example:
In Oracle, if I have two databases(DB1 & DB2) running under a single instance of Oracle I can start or stop the separate database with the startup/shutdown script followed by the arguments "dbname" & "start/stop".

/pathname/ora DB1 start

All of the docs I'm reading for Postgres show me how to start/stop the "cluster" with the etc script:

/etc/init.d/postgres start

but I'm not seeing any mechanism that allows me control with a finer granularity.

Does this mean I need to learn some more SQL? (I'm guessing yes)

Can anyone help?

2: Re: Starting/Stopping individual PG database vs database cluster (response to 1)

Posted by Vinod Kurup on 05/03/06 07:47 PM

Using Postgres, is it possible to start/stop an individual database instead of the entire database cluster?

It's not possible to restart an individual database in PG, but I've never felt that I needed that functionality. You can dump, drop, re-create and reload a database without having to restart PG.