Postgres Pro
Downloads
Home   >   mailing lists

restoring a single database from a pg_dumpall dump file - Mailing list pgsql-general

From Matthias Apitz
Subject restoring a single database from a pg_dumpall dump file
Date
Msg-id YdQFiQrF/2GXgxTI@pureos
Whole thread Raw
Responses Re: restoring a single database from a pg_dumpall dump file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hello,

We're using pg_dumpall (from 14.1) to dump older clusters and
restore them into a new 14.1 cluster. The dump contains some databases
together with roles etc.

Is there some easy way to restore only one database out of this dump
file?

Thanks in advance

    matthias
-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

pgsql-general by date:

Previous
From: Avi Weinberg
Date:
Subject: postgres_fdw FAST "where id in (140,144,148)" SLOW: "where id in (select 140 as id union select 144 union select 148)"
Next
From: Michael Paquier
Date:
Subject: Re: md5 issues Postgres14 on OL7