On 5/23/22 10:01 AM, Rob Sargent wrote:
On 5/23/22 11:00, Adrian Klaver wrote:
On 5/23/22 9:54 AM, Rob Sargent wrote:
On 5/23/22 10:50, Adrian Klaver wrote:
Roger that, but does the dump of a database name the tablespaces from
which the objects were retrieved? And if so, is that accessible?
https://www.postgresql.org/docs/14/app-pgrestore.html
"--no-tablespaces
Do not output commands to select tablespaces. With this option,
all objects will be created in whichever tablespace is the default
during restore.
"
Would indicate it does. I don't have cluster set up with tablespaces
to test, but I would try:
pg_restore -l <custom_format_file>
This will produce a Table of Contents for the file.
Ah, missed that. Thanks.
(Now I'll have to find the version used to dump the db...)
If you have it just use the Postgres 14 version of pg_restore it will be
able to read older files from older versions of pg_dump.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
