Re: Postgresql Backups

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: sub_woofer <tqzelijah(at)yahoo(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql Backups
Date: 2009-08-07 20:07:03
Message-ID: 20090807200703.GA25599@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 07, 2009 at 01:54:47PM -0600, Scott Marlowe 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.

-g
--globals-only

Dump only global objects (roles and tablespaces), no databases.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2009-08-07 20:57:13 Changing referenced primary key column type
Previous Message Scott Marlowe 2009-08-07 19:54:47 Re: Postgresql Backups