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
Calculating a score for each road in Openstreetmap produces unexpected result. What am I missing?
I have a Postgres database with a postgis extention installed and filles with open street map data.
With the following SQL statement :
SELECT
l.osm_id,
sum(
…
Andreas
- 397
- 4
- 18
- 37
0
votes
1 answer
My DataGrip IDE can't find MERGE function even though it is in postgresql 15.1
because of the interest we have in postgresql 15, my team and I would like to migrate to this new version. As we work with docker, I loaded the postgres:15 image instead of the old postgres:13 image and got it on my PC.
Now my problem is that I…
Jugloo
- 3
- 3
0
votes
1 answer
Is it possible to optimize this query / table combination ? (bbox search / geometry)
I have a table graphs with a column bbox:
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description…
Andreas
- 397
- 4
- 18
- 37
0
votes
1 answer
psql cmd command using old user
I forgot my password for an older version of Postgres (I believe v14) and uninstalled it then deleted the remaining files in my program files folder.
I also deleted the environment variable in the path leading to it.
I installed the latest version,…
Timothy W. Times
- 31
- 5
0
votes
1 answer
PostgreSQL: I would like to do a subtraction operation on two tables that were joined (INNER JOIN) and grouped (GROUP BY) before
With postgreSQL I would like to ...
Goal: I would like to do a subtraction operation on two tables that were joined (INNER JOIN) and grouped (GROUP BY) before.
Below is a minimal reproducible script that I hope will work for you.
In this script I…
Carlos Zarzar
- 50
- 5
0
votes
1 answer
Postgres OUTER JOINS TABLE ALREADY JOINED
i'm facing issues migrating queries from Oracle to Postgres 15. How can i join a table that is already joined? The Oracle looks like this:
select ltd1.short_description || '_' || to_char( CASE WHEN lsd.origine_type_id = 2 THEN
…
user3523332
- 3
- 2
0
votes
1 answer
PostgreSQL: How to display comon results from the same table in different columns?
I have a table in Postgres database called FruitMarket and the columns are Fruit, Market, Rate and…
0
votes
1 answer
Why does postgresql planner choose bad plan, for a few specific values only
I have a biggish table in postgresql 15.1 — maybe 50 million rows and growing. A column mmsi has about 30k distinct values, so 1000+ rows per mmsi.
My problem is that I have a query that I need to execute repeatedly during DB load, and for certain…
Joachim Berdal Haga
- 2,001
- 2
- 6
- 7
0
votes
1 answer
psql doesn't prompt for password and throws wrong password error
I'm trying to use PostgreSQL 15 on my desktop at work (Windows 10). When installing, everything goes fine and I set a password to the default postgres user.
Using psql -U postgres on PowerShell, it throws this error message BEFORE prompting me to…
user16776319
0
votes
1 answer
Understanding memory situation for tuning a PostgreSQL database on Ubuntu 22.04.1 LTS
I'm trying to better understand my performance / tuning options for a PostgreSQL database.
System:
Ubuntu 22.04.1 LTS
aarch64, 80 cores, 256 GB RAM
PostgreSQL 15
Right now, the shared buffer size is configured as shared_buffers = 128MB. I…
Ralf
- 2,512
- 4
- 24
- 26
0
votes
1 answer
postgresql physical replication from v9.6 to v15 support
Is postgresql physical replication from v9.6 to v15 possible ? Thanks.
Not tested , I think it will not work.
Serhad Erdem
- 11
0
votes
0 answers
connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"
I've been learning postgresql recently and made a lot of mistakes with the project I started with so I decided to drop the whole database which was called postgres.
And I kept receiving this message:
[55006] error: cannot drop the currently open…
Abdullah Shekfeh
- 11
- 5
0
votes
1 answer
jsonb record object with variable numbre of keys to table
Is it possible to create a query that, given this jsonb field value:
{
"a": {
"e1": 10,
"e2": 30,
"e3": 50
},
"b": {
"e1": 20,
"e2": 40,
"e3": 60
}
...
}
(note that the json object may have a variable number of…
luis-fdz
- 161
- 1
- 7
-1
votes
0 answers
we have a couple of servers so , is it possible to set up replication on Debian server to centos server?
This error reflects server not yet started
Job for postgresql-15.service failed because the control process exited with error code.
See "systemctl status postgresql-15.service" and "journalctl -xeu postgresql-15.service" for Details.
I'm …
-1
votes
0 answers
PostgreSQL is working only for couple hour and connection faild. Where is the problem?
I have installed PostgreSQL on my server. Everything works fine for a few hours, but after some time, I can't connect to the PostgreSQL server until I restart the PostgreSQL service. Then it works again for a few hours, and then it stops working…
Matt Hol
- 1
- 1