Re: How to restore to empty database - Mailing list pgsql-general

From Andrus
Subject Re: How to restore to empty database
Date
Msg-id DB4F4B28299F425EB99244AC64359A4D@dell2
Whole thread Raw
In response to Re: How to restore to empty database  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to restore to empty database
List pgsql-general
Hi!

>These days 37 GB is relatively small, so you maybe getting into the realm 
>of premature optimization. Do the 24 databases represent an entire cluster 
>you are trying to transfer?

Basically yes.
Cluster contains also  small test database which actually does not need 
transferred but I can delete it manually after transfer.
Also postgres, template0 and template1 are not used directly by applications 
and probably does not need to be transferred.

>If so have you looked at pg_dumpall?:
>https://www.postgresql.org/docs/12/app-pg-dumpall.html
>It is a text based backup, but it will include all the databases and the 
>globals.

Source cluster is in old Debian 6 Squeeze running Postgres 9.1
Should I create pipe using pg_dumpall and restore everything from old using 
pipe instead of pg_dump/pg_restore ?

Andrus.




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to restore to empty database
Next
From: Sandip Pradhan
Date:
Subject: RE: Need support on tuning at the time of index creation