Search Postgresql Archives

Restoring Database on Version 11 does not restore database comment

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

postgres=# CREATE DATABASE test_comment TEMPLATE = template0;
CREATE DATABASE
postgres=# COMMENT ON DATABASE test_comment IS 'Test Comment Database';
COMMENT
postgres=# SELECT pg_catalog.shobj_description(d.oid, 'pg_database') as "Version"
postgres-# FROM pg_catalog.pg_database d
postgres-#   where d.datname = 'test_comment';
        Version
-----------------------
 Test Comment Database
(1 row)

C:\Program Files\PostgreSQL\11\bin>pg_dump -h localhost -p 5433 -U postgres -f "G:\test_comment.bak" -Fc -O test_comment

C:\Program Files\PostgreSQL\11\bin>psql -p 5435
psql (11.10)

postgres=# CREATE DATABASE test_comment TEMPLATE = template0;
CREATE DATABASE
postgres=# \q

C:\Program Files\PostgreSQL\11\bin>pg_Restore -p 5435  -U postgres -d test_comment "G:\test_comment.bak"

C:\Program Files\PostgreSQL\11\bin>psql -p 5435
psql (11.10)

postgres=# SELECT pg_catalog.shobj_description(d.oid, 'pg_database') as "Version"
postgres-# FROM pg_catalog.pg_database d
postgres-#   where d.datname = 'test_comment';
 Version
---------

(1 row)

What am I missing?

Thanks,
George







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux