Subject: Re: Discrepancy in --no-tablespaces behavior between Tar and Plain-text formats

From: Nathan Bossart <[email-masked]>
Date: Wed, 18 Feb 2026 09:13:19 -0600

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.

-- 
nathan