| From: | Iipponen Timo <Timo(dot)Iipponen(at)hel(dot)fi> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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:40:37 |
| Message-ID: | AM0PR05MB63212C39DD870E12B905A8FFA6DA0@AM0PR05MB6321.eurprd05.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Thanks
Timo Iipponen
Hanki Outlook for Android<https://aka.ms/ghei36>
________________________________
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Wednesday, April 15, 2020 12:36:36 AM
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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2020-04-14 23:11:39 | BUG #16363: Memory increases for each table accessed until connection is closed |
| Previous 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 |