| 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: | Whole Thread | Raw Message | 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 |