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

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: Antony Gelberg <antony(dot)gelberg(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Stuck trying to backup large database - best practice?
Date: 2015-01-12 17:38:53
Message-ID: 54B406AD.1030903@boscorama.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Van Dyk 2015-01-12 22:04:43 Re: How to analyze a slowdown in 9.3.5?
Previous Message Adrian Klaver 2015-01-12 17:08:03 Re: Stuck trying to backup large database - best practice?