Re: pg_dumpall with individual output files per database? - Mailing list pgsql-general

From Luca Ferrari
Subject Re: pg_dumpall with individual output files per database?
Date
Msg-id CAKoxK+5wGAyXMUEZ=kFrg8_s8FBqSn6uBXR_xstSSp-TE-EWqg@mail.gmail.com
Whole thread Raw
In response to Re: pg_dumpall with individual output files per database?  (Francisco Olarte <folarte@peoplecall.com>)
Responses Re: pg_dumpall with individual output files per database?
List pgsql-general
On Thu, Jul 15, 2021 at 7:27 PM Francisco Olarte <folarte@peoplecall.com> wrote:
> It would probably complicate it, and dumping a whole cluster using
> something like pg_dumpall -g for the globals plus a loop over the
> databases using something like pg_dump -Fc ( which I would always
> recommend over plain sql format ) is just a ( little complex ) one
> liner or a 10 line script, probably not worth the scarce developer /
> maintainer brain cycles.

I always find the 502.pgsql FreeBSD backup script illuminating in this
sense: <https://svnweb.freebsd.org/ports/head/databases/postgresql10-server/files/502.pgsql.in?view=markup#l44>.
I used it as a base for my "loop and backup" scripts.

Luca



pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: PostgreSQL 9.2 high replication lag
Next
From: Luca Ferrari
Date:
Subject: Re: dealing with dependencies