Re: [GENERAL] Encoding problem using pg_dumpall - Mailing list pgsql-admin

From Tom Lane
Subject Re: [GENERAL] Encoding problem using pg_dumpall
Date
Msg-id 14708.1233277601@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Encoding problem using pg_dumpall  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Responses Re: [GENERAL] Encoding problem using pg_dumpall  (Michael Monnerie <michael.monnerie@is.it-management.at>)
List pgsql-admin
Michael Monnerie <michael.monnerie@is.it-management.at> writes:
> Why couldn't pg_dumpall get the same behaviour as pg_dump? It could get
> that -Fc, and couldn't it be implementet as "call pg_dump for each db
> and once for the system"? Why is it that different at all?

The -Fc (and -Ft) formats are only designed to hold the contents of a
single database; and pg_restore only knows how to restore into a single
database.

If you feel like fixing that, step right up.

            regards, tom lane

pgsql-admin by date:

Previous
From: Lee Azzarello
Date:
Subject: Warm standby recovery failure
Next
From: Tom Lane
Date:
Subject: Re: Warm standby recovery failure