Questions tagged [pg-upgrade]
6 questions
4
votes
1 answer
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 the following error: "old and new pg_controldata…
user3159253
- 143
- 3
4
votes
0 answers
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 installed two instances one with postgres 15 and another…
Sajith P Shetty
- 312
- 3
- 12
1
vote
1 answer
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 little bit more complicated because you need the…
D M
- 445
- 5
- 10
1
vote
0 answers
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.
new version: PostgreSQL 12.20 on…
Vinh Lam
- 11
- 2
0
votes
1 answer
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 follow, but want to know what analyze option are…
0
votes
1 answer
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.2 here: …
s.k
- 414
- 1
- 9
- 26