| From: | Iipponen Timo <Timo(dot)Iipponen(at)hel(dot)fi> |
|---|---|
| To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12 |
| Date: | 2020-04-14 20:14:10 |
| Message-ID: | e8a43c2e790a46bcb3d605dd7d453cfc@HELS000767.helsinki1.hki.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-04-14 21:36:36 | Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12 |
| Previous Message | Alvaro Herrera | 2020-04-14 18:00:19 | Re: [bug] Table not have typarray when created by single user mode |