Use this tag if your question is about PostgreSQL version 17 specific feature or behaviour. Please also add the generic [postgres] tag.
Questions tagged [postgresql-17]
8 questions
2
votes
2 answers
(non-breaking space) is not considered whitespace by Postgres?
String-functions in Postgres do not recognize non-breaking-space as whitespace, neither when trimming nor when using regular expressions:
select 'x' || test || 'x'
, 'x' || trim(test) || 'x'
, 'x' || regexp_replace(test, '\s+', '') ||…
Rune
- 123
- 5
1
vote
0 answers
PostgreSQL logical replication fails with memory allocation error
We have a geographically distributed database setup with seven servers. There are 62 master tables set up for logical replication with six subscribers.
This was working fine for a long time with PostgreSQL 15. Recently we migrated to PostgreSQL…
Thadeus Anand
- 56
- 6
1
vote
1 answer
Error "could not reserve shared memory region ... error code 487" on Postgresql 17.5 in Windows
In PG 17.5 on Windows, I'm seeing errors in the log that look like:
2025-06-10 12:53:44.548 EDT [18612] LOG: could not reserve shared memory region (addr=0000022916760000) for child 00000000000014C4: error code 487
2025-06-10 13:09:44.667 EDT…
sevzas
- 373
- 3
- 12
1
vote
0 answers
PG 17.5 pg_ctl output not being logged on Windows Server 2019
I'm working on migrating a PG cluster from PG 13.18 to 17.5 on Windows Server 2019
I'm using the community build of PG 17.5 from EDB.
I've completed the migration using pg_upgrade.exe
I've updated the default postgresql.conf that was created by…
sevzas
- 373
- 3
- 12
0
votes
1 answer
Does the MERGE PARTITION functionality actually exist in PostgresSQL 17?
Is it possible to merge partitions in Postgres 17?
There a a lot of blog posts on the internet suggesting that partition MERGE and SPLIT are (or will be) available in PostgreSQL 17 but there's no explicit mention of this in the release notes, nor…
ConanTheGerbil
- 1,303
- 5
- 31
- 50
0
votes
0 answers
Unable to access Postgress in PgAdmin 4 in windows as it is accessible in terminal wsl
i added screenshot as one is in wsl and one in window terminal as both have same commands but one(WSL) has 8 schemas and the othe one(window) has 6
My project runs on WSL (Windows Subsystem for Linux), and I have PostgreSQL installed on Windows. I…
Numaira Nawaz
- 3
- 4
0
votes
1 answer
Postgresql 17 take automatic daily incremental backups
Postgresql 17 added a new feature to make incremental backups. I want to use this to make daily incremental backups, however I am struggling to find a good method for automatization, as the build in pg_basebackup --incremental always needs a path to…
McToel
- 103
- 2
0
votes
1 answer
Postgres updates xmin on every UPDATE within a transaction
If I do an UPDATE to a row within a transaction, each time xmin increments. I thought that xmin always represents the current tx id. But it seems to be storing current xid + cmin instead.
But when figuring out whether the row is visible or not, then…
Stanislav Bashkyrtsev
- 587
- 3
- 9