51 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
91
views
Why is my custom function inside pg_catalog not included in pg_dump or pg_upgrade?
I created a custom SQL function inside the pg_catalog schema in PostgreSQL. However, when I run pg_dump or perform a pg_upgrade, the function doesn't get included in the dump or upgraded cluster.
Here’...
0
votes
0
answers
159
views
upgrade of Postgres 12.3 /Timescaledb 2.5.1 , very large database of 30TB to PG 16.2 /timescaledb 2.14
We have a very large Postgres database on version 12.3 with timescaledb version 2.5.1.
Size of db ~30 TB
**# of entries in _timescaledb_internal = ~1.7 million. (chunks for historical data).
**# of ...
0
votes
1
answer
632
views
pg_upgrade failing with "No such file or directory"
I was going to update my postgresql from 10 to 12, using homebrew.
What I did:
brew uninstall postgresql@10
brew install postgresql@12
I got the server running after this with brew services (but ...
0
votes
1
answer
585
views
What to do if there are two tablespace directories after pg_upgrade using hard-links option
A while back, I ran a PostgreSQL pg_upgrade on a PG11 database, to PG12, which has a tablespace located at /ssd in it.
I used the --link option in my command to create hard links, as to not double up ...
0
votes
1
answer
679
views
Need some clarification on dropping database during pg_restore
When using pg_dump with the clean option, it generates SQL statements tailored to drop objects when restoring with pg_restore (pg_dump custom format file contains 'DROP DATABASE'). If pg_dump ...
0
votes
0
answers
311
views
Postgres Segfault when trying to pg_upgrade
Getting a segfault upgrading Postgres, is it memory related and how to workaround?
Ubuntu Jammy Postgres 10.x and 14.10 both installed. Trying to upgrade a geospatial database from pg10 with postgis ...
0
votes
1
answer
4k
views
"fe_sendauth: no password supplied" During pg_upgrade Process
I'm encountering an error "fe_sendauth: no password supplied" while attempting to run pg_upgrade to migrate from PostgreSQL 11 to 14. I've set up a .pgpass file with the password and ...
user avatar
user19868155
2
votes
1
answer
1k
views
Issue with AWS Aurora DB PostgreSQL Database Upgrade using pg_upgrade v13 to v14 or 15v
I'm encountering difficulties while trying to upgrade my Amazon Aurora PostgreSQL database from version 13 to version 15 using the pg_upgrade utility. The upgrade process is failing with an error, and ...
0
votes
0
answers
2k
views
Upgrading PSQL from 15 to 16, can upgrade client but not server
I have a server in which I wiped and booted with rhel9. I then used this resource to install psql 15 a couple months ago - https://www.tecmint.com/install-postgresql-and-pgadmin-rhel-9/
I am now ...
0
votes
1
answer
1k
views
Upgrade a Postgres Database Using pg_ugrade Issues with pglogical
I have a Postgres database running on version 11. I want to upgrade to Postgres 14. This database also have logical replication set up using pglogical extension. when I run a compatibility check on ...
1
vote
0
answers
3k
views
pg_upgrade fails with errors upgrading from PostgreSQL 14 to 15
I'm trying to upgrade from postgre 14 to 15 following the Arch Linux wiki (https://wiki.archlinux.org/title/PostgreSQL#Upgrading_PostgreSQL).
When I try to run pg_upgrade -b /opt/pgsql-14/bin -B /usr/...
0
votes
0
answers
2k
views
pg_upgrade port 50432 failed: fe_sendauth: no password supplied
I want to try my first upgrade from postgres 15.1 to 15.2
no instance is started,I run init on new dir:
d:\_dev_\postgres\pgsql\bin\initdb.exe -D d:\_dev_\postgres\pgsql\data
-U postgres -W -E ...
0
votes
1
answer
552
views
why rsync command to postgres upgrade replica are duplicating data folder size increasing disc space
I'm following this doc https://www.postgresql.org/docs/current/pgupgrade.html to upgrade my cluster postgres an its replica, but when I run the rsync command, it duplicate the data folder, consuming ...
0
votes
1
answer
351
views
Empty tables after pg_upgrade from v9.6 to v12
I used this command to upgrade the postgresql database from v9.6 to v12:
/opt/rh/rh-postgresql12/root/usr/bin/pg_upgrade -b /opt/rh/rh-postgresql96/root/usr/bin/ -B /opt/rh/rh-postgresql12/root/usr/...
0
votes
1
answer
1k
views
What is the location for pg_upgrade_dump log file?
I am trying to run a pg_upgrade on my existing 12.8 postgres and migrate it to 14.3 with docker based installation. I got the below error :
Performing Upgrade
------------------
Analyzing all rows in ...