From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jedwa@comcast.net
Subject: BUG #16131: pg_upgrade 9 -> 11.6 and a database is missing
Date: Thu, 21 Nov 2019 19:01:07 +0000
Message-ID: <16131-953e6ab7cb264396@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16131
Logged by: Jed Walker
Email address: jedwa@comcast.net
PostgreSQL version: 11.6
Operating system: CentOS Linux release 7.7.1908 (Core)
Description:
I did an upgrade of two matching servers, one from 9.2 -> 11.5 and had no
problems, but yesterday I did the other 9.2 -> 11.6 and a database and user
were missing from the upgraded database.
I saw no errors, other than the unix_socket_directories issue, but one of
our databases is not in the new 11 server. We had a similar system with the
same databases that I upgraded a week ago and all databases came across.
There is no reference to this database in the upgrade logs.
The key difference between the system that I did previously that worked and
this is that the one that worked was 9.2 -> 11.5, and this was 9.2 -> 11.6
Upgrade process:
yum install -y
https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rp...
yum install -y postgresql11
yum install -y postgresql11-server
shutdown -r now
systemctl stop postgresql
/usr/pgsql-11/bin/postgresql-11-setup initdb
/usr/pgsql-11/bin/pg_upgrade -v -r -d /var/lib/pgsql/data -D
/var/lib/pgsql/11/data -b "/usr/bin" -B "/usr/pgsql-11/bin"
systemctl disable postgresql
systemctl enable postgresql-11
systemctl start postgresql-11
~/analyze_new_cluster.sh
These are the databases, after upgrade database wasp and user wasp_user were
missing.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
-----------+-----------+----------+-------------+-------------+-------------------------
nasdb | nasuser | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
+
| | | | |
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres=CTc/postgres +
| | | | |
=c/postgres
wasp | wasp_user | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
=Tc/wasp_user +
| | | | |
wasp_user=CTc/wasp_user
The users are using the system, but I'd be happy to send logs etc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, jedwa@comcast.net
Subject: Re: BUG #16131: pg_upgrade 9 -> 11.6 and a database is missing
In-Reply-To: <16131-953e6ab7cb264396@postgresql.org>
References: <16131-953e6ab7cb264396@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox