Re: Postgresql Backups - Mailing list pgsql-general

From Vick Khera
Subject Re: Postgresql Backups
Date
Msg-id 2968dfd60908080646r3d8538b0j6fea7f22861212f@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql Backups  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Postgresql Backups  (sub_woofer <tqzelijah@yahoo.co.uk>)
List pgsql-general
On Fri, Aug 7, 2009 at 3:54 PM, Scott Marlowe<scott.marlowe@gmail.com> wrote:

> You're probably better off switching to explicitly backing up
> databases in the custom format and using a single pg_dumpall --globals
> to backup the users accounts and such.  That's how I prefer to do it
> and it makes life much easier.

This is precisely how we do it.  Make for recovering certain data
easier, especially when you have a lot of databases on your server.

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Arrays and LIKE
Next
From: Sualeh Fatehi
Date:
Subject: Re: A compare and/or sync. database structure?