GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
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
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
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