9 questions
-1
votes
0
answers
25
views
Logical replication not resuming after upgrading subscriber from PostgreSQL 13 to 18 [migrated]
My publisher is running PostgreSQL 17 and the subscriber is on PostgreSQL 13.
What I am trying to do
My goal is to upgrade PostgreSQL from version 13 to 18 on the subscriber side.
Because our ...
1
vote
1
answer
78
views
How do I create a "UUIDv7" column using the pgAdmin GUI in PostgreSQL?
I'm trying to figure out how I can add a new primary key column using the new UUIDv7 from PostgreSQL v18.
From reading online. It seems I can add them like this with code:
profile_id UUID PRIMARY KEY ...
- 4,471
2
votes
0
answers
40
views
Postgres logical replication to restored snapshot [migrated]
I am attempting to logically replicate a production postgres instance to facilitate a blue/green major version upgrade from 13 -> 18 (don't ask).
First, I start a replication slot on the blue (...
- 93
0
votes
1
answer
124
views
Cannot run my PHP Apache PHP-FPM website locally on MacOS because of weird ObjectiveC error: objc[1495]: +[NSPlaceholderString initialize]
This issue recently popped up after a macOS update probably Tahoe 26 but when I try to request a page of my website that uses Homebrew Apache PHP-FPM Memcached with PostgreSQL and PHP 8.4 files on OSX ...
- 519
Advice
0
votes
3
replies
82
views
How to set physical machine access when mount to docker container?
I'm trying to run postgresql. after checking their document, I added this volume mount
/path/to/data:/var/lib/postgresql/18/docker
my container failed immedeately,
chmod: changing permissions of '/var/...
- 487
0
votes
1
answer
219
views
Why doesn't index creation work any more in Postgres v17 and v18?
Considering the following SQL code:
create table test (a int, b int) ;
create type tst as (a int, b int) ;
create function tst (a int, b int) returns tst[] language sql immutable as
$$ select array(...
- 7,129
1
vote
0
answers
55
views
Postgres Temp table collation for text columns
We are converting a large database system from SQL Server 2022 to Postgres 18.
The SQL Server collation is Latin1_General_CI_AS.
The Postgres database default collation is English_United Kingdom.1252.
...
- 43
1
vote
0
answers
39
views
Postgres 18 ANALYZE allows an '*' as parameter - What does it do?
Postgres 18 ANALYZE documentation states:
table_and_columns is:
[ ONLY ] table_name [ * ] [ ( column_name [, ...] ) ]
Note the '*', which is not present in Postgres 17 ANALYZE documentation.
...
- 1,416
4
votes
1
answer
388
views
Retaining statistics when upgrading postgres 16 to 18
pg_upgrade 18 docs state that
pg_upgrade will transfer most optimizer statistics from the old cluster to the new cluster
The docs also state that
pg_upgrade supports upgrades from 9.2.X and later ...
- 1,416