Re: Stuck trying to backup large database - best practice? - Mailing list pgsql-general

From Bosco Rama
Subject Re: Stuck trying to backup large database - best practice?
Date
Msg-id 54B406AD.1030903@boscorama.com
Whole thread Raw
In response to Re: Stuck trying to backup large database - best practice?  (Antony Gelberg <antony.gelberg@gmail.com>)
List pgsql-general
On 01/12/15 08:40, Antony Gelberg wrote:
>> In addition are you talking about a single database or the Postgres database
>> cluster?
>
> We only have one database in the cluster, so it's the same thing.

Not exactly.  For example, with pg_dump you would also need to dump the
'global' context separately.  Or you could use pg_dumpall for both the
context and the database with all of that then piped into a gzip or
bzip (since pg_dumpall only outputs sql text).

HTH,
Bosco.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Stuck trying to backup large database - best practice?
Next
From: Joe Van Dyk
Date:
Subject: Re: How to analyze a slowdown in 9.3.5?