From: | "Peter Schuller" <peter(dot)schuller(at)infidyne(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Backing up postgresql databases |
Date: | 2001-03-18 03:39:23 |
Message-ID: | 20010317223923.X441@prometheus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 <peter(dot)schuller(at)infidyne(dot)com>'
Key retrival: Send an E-Mail to getpgpkey(at)scode(dot)infidyne(dot)com
E-Mail: peter(dot)schuller(at)infidyne(dot)com Web: http://scode.infidyne.com
From | Date | Subject | |
---|---|---|---|
Next Message | John W Cunningham | 2001-03-18 04:11:51 | RE: Backing up postgresql databases |
Previous Message | Bruce Momjian | 2001-03-17 15:58:30 | Re: [GENERAL] Re: New PostgreSQL session monitor |