Anton Melser wrote:
Hi, 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 - the transaction log (WAL) is shared. You'll need to include that in any filesystem backup.
ps. If this isn't possible, what experiences do people have with running several postgres instances on a single machine?
It's perfectly possible - most of the developers do so, and I do it so I can test new versions while supporting old ones. Of course, each will have their own shared memory allocations so that might impact your performance.
-- Richard Huxton Archonet Ltd
