Backing up postgresql databases

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

Responses

Browse pgsql-admin by date

  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