Postgres Pro
Downloads
Home   >   mailing lists

Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
Date
Msg-id 2280.1586900196@sss.pgh.pa.us
Whole thread Raw
In response to GRANT CONNECT statements not shown after pg_dump - pg_restore fromPostgreSQL 9 to PostgreSQL 12  (Iipponen Timo <Timo.Iipponen@hel.fi>)
Responses Re: GRANT CONNECT statements not shown after pg_dump - pg_restorefrom PostgreSQL 9 to PostgreSQL 12
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Iipponen Timo
Date:
Subject: GRANT CONNECT statements not shown after pg_dump - pg_restore fromPostgreSQL 9 to PostgreSQL 12
Next
From: Iipponen Timo
Date:
Subject: Re: GRANT CONNECT statements not shown after pg_dump - pg_restorefrom PostgreSQL 9 to PostgreSQL 12