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.
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...)
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.
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?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
