From: Florents Tselai <florents.tselai@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_13E6E0D5-63BD-40AF-90B7-EFB8AC773A3D"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3818.100.11.1.3\))
Subject: Docs pg_restore: Shouldn't there be a note about -n ?
Message-Id: <284C4D55-4F90-4AA0-84C8-1E6A28DDF271@gmail.com>
Date: Sat, 21 Sep 2024 20:33:53 +0300
To: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Archived-At: <https://www.postgresql.org/message-id/284C4D55-4F90-4AA0-84C8-1E6A28DDF271%40gmail.com>
Precedence: bulk


--Apple-Mail=_13E6E0D5-63BD-40AF-90B7-EFB8AC773A3D
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

I=E2=80=99m in the process of trying to restore some PG15/16 backups in =
PG17.

While playing with different -t and -n combinations I was browsing =
through the docs.

In pg_restore there are two notes about both -t / -n=20

> When -n / -t is specified, pg_dump makes no attempt to ...

In pg_dump though there=E2=80=99s the equivalent note only for the -t =
option.

Shouldn=E2=80=99t it be a note as well for -n ?=20

Otherwise I would expect -n to cascade the restore to objects in other =
schemas;
Which I don=E2=80=99t think it does.

Am I missing something?=20=

--Apple-Mail=_13E6E0D5-63BD-40AF-90B7-EFB8AC773A3D
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;">I=E2=80=99m in =
the process of trying to restore some PG15/16 backups in =
PG17.<div><br></div><div>While playing with different -t and -n =
combinations I was browsing through the =
docs.</div><div><br></div><div>In <b>pg_restore</b> there are two notes =
about both -t / -n&nbsp;<span id=3D"x-apple-selection:start"></span><span =
id=3D"x-apple-selection:end"></span></div><div><br></div><div>&gt; When =
-n / -t is specified, pg_dump makes no attempt to =
...</div><div><br></div><div>In pg_dump though there=E2=80=99s the =
equivalent note only for the -t =
option.</div><div><br></div><div>Shouldn=E2=80=99t it be a note as well =
for -n ?&nbsp;</div><div><br></div><div>Otherwise I would expect -n to =
cascade the restore to objects in other schemas;</div><div>Which I =
don=E2=80=99t think it does.</div><div><br></div><div>Am I missing =
something?&nbsp;</div></body></html>=

--Apple-Mail=_13E6E0D5-63BD-40AF-90B7-EFB8AC773A3D--