Use this tag to indicate that your question is about PostgreSQL version 15. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-15]
112 questions
0
votes
1 answer
Setting up a Connection db utility using psycopg3
I have this db_utils.py section where I define newconnect():
def newconnect():
with psycopg.connect("host=aaa port=5432 dbname=ccc user=bbb password=xxx") as conn:
print("Connected")
cur = conn.execute('SELECT version()')
db_version…
Mark G
- 27
- 5
0
votes
0 answers
How to implement pgAgent Jobs in PostgreSQL 15?
What do I have to do so that PostgreSQL 15 using pgAdmin shows me the "pgAgent Jobs" section? It is not enough to create the extension and update, unlike PostgreSQL 12.
PostgreSQL 12
PostgreSQL 15
Felipe Renovato
- 57
- 5
0
votes
2 answers
Why is my logical replication failing with "could not drop replication slot ... does not exist"?
Our logical replication has started to fail with a lot of these errors on the subscriber:
ERROR: could not create replication slot
"pg_148211637_sync_148178452_7161337762731575223": ERROR: all replication slots are in use
May 2 07:43:01 psql-06…
Niels Kristian
- 8,661
- 11
- 59
- 117
0
votes
0 answers
What could cause Postgresql to suddenly report waiting for MultiXactOffsetSLRU and MultiXactOffsetBuffer for almost all active queries?
Today we have encountered a performance problem with our postgresql 15 Cluster. All of a sudden today we have seen a massive performance drop starting to occur without any changes to the database servers, the client behaviour nor any software…
Niels Kristian
- 8,661
- 11
- 59
- 117
0
votes
1 answer
bitnami postgresql replaces postgresql.conf after restarting docker
I'm using docker pull bitnami/postgresql:15.2.0 and I mount 2 directories:
/bitnami/postgresql/data to /la/la/la/data
/opt/bitnami/postgresql/conf to /la/la/la/conf
/opt/bitnami/postgresql/conf has postgresql.conf which I'm trying to change
After…
Pavel Kovalev
- 7,521
- 5
- 45
- 67
0
votes
0 answers
PostgreSQL: ERROR: permission denied for function autoprewarm_start_worker
After I am running pg_restore, I am trying to grant all privileges to the new user, with the following command order:
GRANT ALL PRIVILEGES ON DATABASE "my_database" TO "my_user";
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO…
CurlyError
- 305
- 2
- 15
0
votes
0 answers
CREATE DATABASE WITH TEMPLATE Postgres 11 -> 15 Performance
On our DEV workstations we have for test reasons to databases. Origin Database and Test Database, which is "destroyed" after testing.
In Postgres 11 we use the CREATE DATABASE with template command to reset the testing Database:
CREATE DATABASE…
Mario P
- 1
0
votes
1 answer
Unable to Connect to PostgreSQL Server hosted on a Virtual Machine from my local machine
I am trying to connect to a Remote PostgreSQL Server(WINDOWS 8 Server) from my local machine (WINDOWS 10 Machine) and i am getting connection timeout error.
I have tried following things before posting this question.
Checked and made sure that…
ManojRawat
- 61
- 1
- 8
0
votes
1 answer
Making array unique in the PostgreSQL
I have the following query in my system:
SELECT
DISTINCT ON(consultant_profiles.id)
consultant_profiles.id,
(
array_remove(array_agg(DISTINCT(function_experiences.experience)), NULL) ||
…
Mateusz Urbański
- 7,352
- 15
- 68
- 133
0
votes
0 answers
postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency
I'm using an EC2 on AWS running Amazon Linux 2. I'm trying to install Postgresql version 15 server along with the contrib libraries for various extension.
This is how I installed Posgres15
sudo rpm --import…
maxTrialfire
- 532
- 3
- 16
0
votes
1 answer
How to simplify the JSON returned by a query using PostgreSQL 15
I am stuck with the PostgreSQL json_build_object function.
I am trying to build a query to return a JSON results like this:
{
"id": 1001,
"is_active": true,
"created_dt": "2023-04-22T14:37:37.985197",
"updated_dt":…
coterobarros
- 941
- 1
- 16
- 25
0
votes
0 answers
how to install postgis on postgres15 on an amazon linux 2
I have Postgres-15 installed with geos-3.9.1 and postgis-3.2.1 on my Amazon Linux 2 machine. I have a problem with the installing postgis. I've built and installed everything from source.
The error I'm getting when I run CREATE EXTENSION postgis;…
0
votes
2 answers
Postgresql distinct on 1 column with highest possible second column
I have table in PostgreSQL with 2 columns:
id
employee_id
In this table there are some records with duplicated employee_id but always unique id. I need to get unique employee_id with highest id possible. What i want to achieve is distinct query…
jokonoo
- 83
- 1
- 7
0
votes
1 answer
How to check if there is no more rows to fetched using libpq?
I am using C++ and using libpq to access PostgreSQL. I am a newbie to libpq and need to process data of table row by row.
below is snippet of code
PGresult* res = PQexec(conn, "DECLARE myCursor CURSOR FOR select * from my_table");
if…
Rakesh Mehta
- 35
- 5
0
votes
1 answer
enable_memoize and max_parallel_workers_per_gather problem or bug?
using Postgresql 15.2, I tried any kind of query that join a CTE with a table:
with t as (select t.day from calendar where idtime between 20230101 and 20230224)
select idcell, sum (tmean)
from weather w join t on w.day = t.day
group by…
Tony Zucchini
- 11
- 3