> Is it possible to stop a single database, like it is with Oracle? Our
> oracle admin asked this for FS backups, if there are 3 dbs (in
> separate tablespaces) then there seems no reason why this couldn't be
> possible... is it possible?
No, this is not possible, because they are all serverd by the same
server process.
You can, however, do an online backup while the database is running.
This is essentially a filesystem backup, and you issue a certain
SQL statement before and after the backup.
> ps. If this isn't possible, what experiences do people have with
> running several postgres instances on a single machine?
It is called 'cluster', not 'instance'.
I have very good experiences.
Yours,
Laurenz Albe
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
