Re: Discrepancy in --no-tablespaces behavior between Tar and Plain-text formats - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Discrepancy in --no-tablespaces behavior between Tar and Plain-text formats
Date
Msg-id aZXXD4HhJjACM-3j@nathan
Whole thread Raw
In response to Discrepancy in --no-tablespaces behavior between Tar and Plain-text formats  (tushar <tushar.ahuja@enterprisedb.com>)
Responses Re: Discrepancy in --no-tablespaces behavior between Tar and Plain-text formats
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pgstat include expansion
Next
From: Peter Eisentraut
Date:
Subject: some validate_relation_kind() tidying