pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
3+ messages / 2 participants
[nested] [flat]

* GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
@ 2020-04-14 20:14  Iipponen Timo <Timo.Iipponen@hel.fi>
  0 siblings, 1 reply; 3+ messages in thread

From: Iipponen Timo @ 2020-04-14 20:14 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

A little notification.

GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12.

I created the file with pg_dump (v. 12.2) from the database of the version 9.4.5 and loaded it into the PostgreSQL 12.2 database after creating first manually the corresponding database and all users.
I noted that the new PostgreSQL 12.2 database does not display GRANT CONNECT statements for the database. (grants are shown for schemas, etc. anyway). I looked with PgAdmin 4.20 and psql (v. 12.2) with the commands "\l" and "\du".
GRANT CONNECT statements that I created manually afterwards appear.
However, the hidden connect privileges exists for the database because they work.
(My dump file had DROP DATABASE -commands even I didn't specify "--clean" in any commands.)

With regards

Timo Iipponen

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
@ 2020-04-14 21:36  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Iipponen Timo <Timo.Iipponen@hel.fi>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2020-04-14 21:36 UTC (permalink / raw)
  To: Iipponen Timo <Timo.Iipponen@hel.fi>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

Iipponen Timo <Timo.Iipponen@hel.fi> writes:
> A little notification.
> GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12.

pg_dump doesn't propagate database-level properties unless
you use the --create switch.  (This used to act differently.)

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
@ 2020-04-14 21:40  Iipponen Timo <Timo.Iipponen@hel.fi>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Iipponen Timo @ 2020-04-14 21:40 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

Thanks

Timo Iipponen

Hanki Outlook for Android<https://aka.ms/ghei36;

________________________________
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Wednesday, April 15, 2020 12:36:36 AM
To: Iipponen Timo <Timo.Iipponen@hel.fi>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12

Iipponen Timo <Timo.Iipponen@hel.fi> writes:
> A little notification.
> GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12.

pg_dump doesn't propagate database-level properties unless
you use the --create switch.  (This used to act differently.)

                        regards, tom lane

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2020-04-14 21:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-04-14 20:14 GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12 Iipponen Timo <Timo.Iipponen@hel.fi>
2020-04-14 21:36 ` Tom Lane <tgl@sss.pgh.pa.us>
2020-04-14 21:40   ` Iipponen Timo <Timo.Iipponen@hel.fi>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox