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

Поиск
Список
Период
Сортировка
От Iipponen Timo
Тема Re: GRANT CONNECT statements not shown after pg_dump - pg_restorefrom PostgreSQL 9 to PostgreSQL 12
Дата
Msg-id AM0PR05MB63212C39DD870E12B905A8FFA6DA0@AM0PR05MB6321.eurprd05.prod.outlook.com
обсуждение исходный текст
Ответ на Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
Thanks

Timo Iipponen

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

                        regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: GRANT CONNECT statements not shown after pg_dump - pg_restore from PostgreSQL 9 to PostgreSQL 12
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16363: Memory increases for each table accessed until connection is closed