upgrading postgres db
search cancel

upgrading postgres db


Article ID: 261687


Updated On:


DX Application Performance Management


I was following the steps from following link to upgrade our postgres https://knowledge.broadcom.com/external/article/228491 and ran into the following problem right as i try to upgrade. A

[postgres@jtcqa1lapmom01 data]$ /usr/pgsql-13/bin/pg_upgrade -b /opt/apm/postgres/PostgreSQL-9.6.2/bin -B /usr/pgsql-13/bin -d /opt/apm/postgres/PostgreSQL-9.6.2/data -D /opt/apm/pgsql/13/data
Performing Consistency Checks
Checking cluster versions                                   ok
Checking database user is the install user                  ok
Checking database connection settings                       ok
Checking for prepared transactions                          ok
Checking for system-defined composite types in user tables  ok
Checking for reg* data types in user tables                 ok
Checking for contrib/isn with bigint-passing mismatch       ok
Checking for tables WITH OIDS                               ok
Checking for invalid "sql_identifier" user columns          ok
Checking for invalid "unknown" user columns                 ok
Creating dump of global objects                             ok
Creating dump of database schemas

New cluster database "cemdb" is not empty: found relation "public.ts_app_auth_types"
Failure, exiting


Release : 10.7.0




Upgrade Error - New cluster is not empty; exiting

If pg_upgrade reports that the new cluster is not empty, please empty the new clusterThe target cluster may not contain any user-defined databases.