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.)