From: | George Weaver <gweaver(at)shaw(dot)ca> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Restoring Database on Version 11 does not restore database comment |
Date: | 2020-11-20 22:57:59 |
Message-ID: | b486a10f-6a9f-9844-18f6-4708b3b54872@cleartagsoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-11-20 23:01:26 | Re: Restoring Database on Version 11 does not restore database comment |
Previous Message | Mark Johnson | 2020-11-20 22:32:18 | Re: pg_dump - how to force to show timestamps in client log |