Questions tagged [pg-upgrade]
The pg-upgrade tag has no summary.
6 questions
4 votes
1 answer
236 views
upgrade from PG12/Postgis3 to PG15/Postgis3 without pg_upgrade
What is a recommended way to upgrade a medium size (3.1Tb) production database from PG12/Postgis3 to PG15/Postgis3 with a reasonable (up to an hour) downtime? pg_upgrade fails to perform the task with ...
- 143
4 votes
0 answers
320 views
Postgres: Queries are too slow after upgrading to PG17 from PG15
Most of the queries got slower after upgrading our postgres from version 15 to 17 using pg_upgrade. I reconfirmed that "vaccuum, analyze" were all taken care. To debug, instead of upgrade, I ...
- 312
2 votes
1 answer
690 views
Using docker containers to execute pg_upgrade
using pg_upgrade when you have installed both the 'old' version and the 'new' version on a system is quite straightforward. I tried to find a way using pg_upgrade with docker containers. This is a ...
- 465
0 votes
1 answer
2k views
Postgres Database Performance is slow after upgrade from v15 to 17
After upgrading the Postgres Server from Version 15 to Version 17 running on RHEL 9, few of the SQLs changed the plan and running pretty slow. I am basically an Oracle DBA and thinking to perform the ...
1 vote
0 answers
56 views
Performance issue after upgrading Postgresql from v11 to v12 (AWS RDS)
We have just upgraded our RDS instance to v12.2 from v11.22, and we are seeing some of the queries are performing much slower than v11.6 instance. Would highly appreciate if can get help with this. ...
- 11
0 votes
1 answer
985 views
pg_upgrade fails on pg_restore: error: connection to server at "localhost" port 5433 failed: FATAL: password authentication failed for user "postgres"
I have a PostgreSQL 13 installation on a Windows 10 server (on port 5432) that I want to migrate to a new PG 16.2 installation. To this end, I downloaded the Windows x86-64 installer for PostgreSQL 16....
- 444