On Wed, Feb 18, 2026 at 04:13:11PM +0530, tushar wrote: > I observed that pg_restore attempts to set default_tablespace from a Tar > archive even if --no-tablespaces was used during pg_dump.
Correct. The documentation for pg_dump --no-tablespaces states the following:
This option is ignored when emitting an archive (non-text) output file. For the archive formats, you can specify the option when you call pg_restore.
Thanks for pointing that out. Since this appears to be the expected behavior, should we leave it as is rather than attempting to 'fix' or improve it?
if --not-tablespace already specified at the time of pg_dump ( not sure why it is ignored; it should throw an error if not supported)
then it makes sense that it wouldn't be necessary for pg_restore time, seems redundant.
