Skip site navigation (1) Skip section navigation (2)

Re: Full backup - pg_dumpall sufficient?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Full backup - pg_dumpall sufficient?
Date: 2009-01-29 16:56:07
Message-ID: 4981DFA7.6020000@iol.ie (view raw or flat)
Thread:
Lists: 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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Responses

pgsql-general by date

Next:From: David FetterDate: 2009-01-29 16:57:26
Subject: Re: Pet Peeves?
Previous:From: Tom LaneDate: 2009-01-29 16:50:22
Subject: Re: Text search segmentation fault

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group