Hello,

How do people normally backup up postgresql databases? The obviously safe
solution is to shut down the database during backup, but is Postgresql
storage such that it's safe to backup a running DB? I.e., is the database
guaranteed to be in a consistent state after restoration? 

I'm talking a standard backup procedure now; say a tar -czvf. So that
assuming certain procedures during storage, it should be possible to
guarantee this (although it wouldn't be easy). The questions is,
does Postgresql do that? I'm sceptical :)

Thanks!

-- 
/ Peter Schuller, InfiDyne Technologies HB

PGP userID: 0x5584BD98 or 'Peter Schuller <[EMAIL PROTECTED]>'
Key retrival: Send an E-Mail to [EMAIL PROTECTED]
E-Mail: [EMAIL PROTECTED] Web: http://scode.infidyne.com


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to