On 5/23/22 11:07, Adrian Klaver wrote:
> 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.
>
>
This is great news. I do have pg14. I thought you had to dump with the
save version as restore.