Re: Full backup - pg_dumpall sufficient? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Full backup - pg_dumpall sufficient?
Date
Msg-id 4981DFA7.6020000@iol.ie
Whole thread Raw
In response to Full backup - pg_dumpall sufficient?  (Gerhard Wiesinger <lists@wiesinger.com>)
Responses Re: Full backup - pg_dumpall sufficient?  (Gerhard Wiesinger <lists@wiesinger.com>)
List pgsql-general
On 29/01/2009 16:31, Gerhard Wiesinger wrote:

> I recently read some Mail on the mailinglist where some parts of
> PostgreSQL were not dumped with pg_dumpall and additionally some pg_dump
> was necessary (it was something like internals, catalog, etc.)

It's the other way around - pg_dump dumps just the specified database,
but not cluster-wide stuff like login roles; you need to do a pg_dumpall
to get those as well.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Text search segmentation fault
Next
From: David Fetter
Date:
Subject: Re: Pet Peeves?