Re: Postgresql Backups

From: Vick Khera <vivek(at)khera(dot)org>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql Backups
Date: 2009-08-08 13:46:18
Message-ID: 2968dfd60908080646r3d8538b0j6fea7f22861212f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 7, 2009 at 3:54 PM, Scott Marlowe<scott(dot)marlowe(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sualeh Fatehi 2009-08-08 14:37:12 Re: A compare and/or sync. database structure?
Previous Message Sam Mason 2009-08-08 13:10:18 Re: Arrays and LIKE