Re: Stuck trying to backup large database - best practice?

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.