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.
12 questions
0
votes
1
answer
20
views
Monitoring long-running queries in Aurora PostgreSQL
I'm supporting a new system that's going live next month. I'm trying to have PostgreSQL log any long-running (over 1 second) queries to the error log. I've set the following parameters:
log_duration: ...
- 173
1
vote
1
answer
65
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
1
vote
1
answer
422
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
0
answers
40
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
2
votes
2
answers
341
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
1
answer
214
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