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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Iipponen Timo <Timo(dot)Iipponen(at)hel(dot)fi>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
Date: 2020-04-14 21:36:36
Message-ID: 2280.1586900196@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Iipponen Timo <Timo(dot)Iipponen(at)hel(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Iipponen Timo 2020-04-14 21:40:37 Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
Previous Message Iipponen Timo 2020-04-14 20:14:10 GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12