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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
