Re: Restoring Database on Version 11 does not restore database comment

Thanks David! Missed that... On 20/11/2020 5:01 p.m., David G. Johnston wrote: On Fri, Nov 20, 2020 at 3:58 PM George Weaver > wrote: What am I missing? Release notes. https://www.postgresql.org/docs/11/release-11.html

Re: Restoring Database on Version 11 does not restore database comment

On Fri, Nov 20, 2020 at 04:01:26PM -0700, David G. Johnston wrote: > On Fri, Nov 20, 2020 at 3:58 PM George Weaver wrote: > > What am I missing? > > > > Release notes. > > https://www.postgresql.org/docs/11/release-11.html > > "pg_dump and pg_restore, without --create, no longer dump/res

Re: Restoring Database on Version 11 does not restore database comment

On Fri, Nov 20, 2020 at 3:58 PM George Weaver wrote: > What am I missing? > > Release notes. https://www.postgresql.org/docs/11/release-11.html "pg_dump and pg_restore, without --create, no longer dump/restore database-level comments and security labels; those are now treated as properties of t

Restoring Database on Version 11 does not restore database comment

Good afternoon, If I backup a PostgreSQL 10.14 database using pg_dump from Version 11.10, and restore to Version 11, the comment for the database is lost. I haven't encountered this before when upgrading between major versions. Test case: C:\Program Files\PostgreSQL\10\bin>psql psql (10.14)