Questions tagged [postgresql-17]
Use this tag if your question is about PostgreSQL version 17 specific feature or behaviour. Please also add the generic [postgres] tag.
11 questions
0
votes
1
answer
21
views
Postgres database migration. pg_restore seems to hang
I'm attempting to migrate (users, structures, triggers, data - everything) a postgres 17 database on a windows 10 machine to a new windows 11 server.
The new machine has a default installation of ...
- 1,313
1
vote
1
answer
57
views
Generated column with date and interval
I have read this answer: How to add a generated column with an expression subtracting days? but it throws generation expression is not immutable and i can't get why ?
Here's the table:
CREATE TABLE ...
- 214
0
votes
0
answers
38
views
Query planning time much higher compared to Postgres 14 and TimescaleDB 2.16
We recently upgraded our development environment from Postgres 14 → Postgres 17 and TimescaleDB 2.16 → 2.21.
Since then, we’ve noticed that certain queries involving joins now take 2.5× longer in the ...
1
vote
1
answer
348
views
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 ...
1
vote
1
answer
288
views
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: ...
- 375
1
vote
0
answers
39
views
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 ...
- 375
0
votes
1
answer
157
views
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 ...
- 1,313
2
votes
2
answers
324
views
(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'
...
- 123
0
votes
0
answers
79
views
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),...
0
votes
1
answer
210
views
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 ...
- 103
0
votes
1
answer
303
views
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 ...
