All Questions
Tagged with postgres-10 or postgresql-10
682 questions
-1
votes
1
answer
156
views
postgis fails on postgresql 10 DB on ubuntu 24.04 because wrong version of libproj present
I recently updated a computer that had been running Ubuntu 20.04 to Ubuntu 24.04. On this computer, I have a large postgresql 10 database with postgis 2.4.8 that for various reasons would be hard to ...
- 885
1
vote
1
answer
263
views
Postgres pg_background asynchronous queries
I am trying to perform DELETE and INSERT statements in a trigger function, like
BEGIN
IF (TG_OP = 'DELETE') THEN
DELETE FROM…;
INSERT INTO…;
RETURN OLD;
ELSIF (TG_OP = 'UPDATE' OR ...
- 13
0
votes
1
answer
63
views
PostgreSQL populate a column based on other 2 columns
I have the following table in Postgres 10.4.
Name Email EmailType
--------------------------------------
John [email protected] Primary Email
John [email protected] Secondary Email
...
- 3,360
0
votes
0
answers
497
views
Cannot start PostgreSQL database: Invalid primary and secondary checkpoints
My specific problem is that we are unable to restart our postgreSQL database.
We have an ubuntu server (release 18.04) with PostgreSQL 10 installed. I commonly revise my IP address in the pg_hba.conf ...
- 1
0
votes
1
answer
978
views
How to handle invalid token "False" in postgresql
select replace(pol.bundle_product, '''', '"')::json ->> 'display_name' from pos_order_line pol where order_id in ('164568','140750');
i will query json data in postgresql but it shows ...
- 69
1
vote
0
answers
44
views
Postgres, create index for WHERE ... OR .. case without rebuilding a query
I have a query(Posgres) that looks like this (I replaced fields with * meaning that fields could vary):
SELECT *
FROM actions
WHERE
(logs."group"=$1 OR logs."team" IN ($2))
and ...
- 19
0
votes
1
answer
289
views
change in behavior declaring index on timestamp column
I am hitting a problem with index creation across different versions of Postgres. We are upgrading a Postgres database from 10.21 to 14.4. In preparation for this, I've been running our tests on the ...
- 1,689
0
votes
0
answers
74
views
Error : set returning functions are not allowed in CASE, in Postgresql 10
sql is not my strong point
upgrading from postgres 9.6 to 10.6 and I get an error from this query:
select
CASE WHEN wlh.status_reason_code like '%DR%' THEN
concat('RR',...
0
votes
0
answers
66
views
Is possible to create a "demi/sub"-superuser in Postgres (10)?
I want to create a "demi/sub" super user, which can perform duties as admin user, but shouldn't be able to delete or create Dbs, alter system, but must have all privileges except delete on ...
- 18
1
vote
0
answers
660
views
Postgres autocomplete not working in version 10
Whenever i press up/down arrows, the command history is not getting displayed and whenever i press tab, autocomplete is not happening.
- 107
4
votes
1
answer
797
views
node.js | Replacing DB client with Prisma keeping preserving DB structure - issue with uuid_generate_v4()
I am trying to add the Prisma DB client to the existing node.js project while preserving the DB structure.
Postgresql
Prisma 4.7.1
I've set up the initial Prisma configuration (env vars, etc.).
I've ...
- 502
0
votes
0
answers
617
views
pg dump with folder format fails for large database with error : no space left on the device
We are running postgresql database server running as docker container inside a VM. Postgresql docker image version is 10. Server size is 32 cpus and 256 GB memory.
VM Specs : Ubuntu 18.04, Docker ...
0
votes
0
answers
58
views
String equals "=" on a varchar column breaks after upgrade from Postgres 10.20 to 10.22
Yesterday I upgraded our Postgres DB from 10.20 to 10.22. I'm using Docker to run the DB, so I just updated the Docker config to run the newer version and kept the same data folder. As far as I know, ...
- 57
0
votes
0
answers
146
views
PostgreSQL: Matching integer ids in where clause (apparently) fails
I do not understand the behaviour of the following query:
SELECT qs.id_gen::int as qs_i
, fi.id_gen::int as fi_i
, ABS(qs.id_gen::int - fi.id_gen::...
- 11
3
votes
3
answers
901
views
Postgres query planner won't use less expensive composite index
We've run into a strange issue with Postgres, initially unearthed as we prepare to upgrade from 10.21 to 11+. What we'd initially thought was a performance regression in newer versions of Postgres ...
- 647
1
vote
1
answer
548
views
Query optimization on a huge table
I have a table that have at least 3 columns :
id, type : uuid, primary key
number : smallint, can't be null
end : timestamptz, can't be null
I am using this query :
SELECT
number AS key,
MAX(...
- 1,193
1
vote
1
answer
931
views
DC-DR Sync issue in Patroni PostgreSQL setup
We have a 3 instance cluster in DC and a 3 instance cluster in DR as standby_cluster. For DC-DR real-time sync, we have added the DC cluster's leader's IP as standby_cluster IP in the DR patroni ...
- 11
3
votes
1
answer
467
views
How to optimize fuzzy string matching pairs of phrases (intersection names) in PostgreSQL
We have a table of intersection names like 'Main St / Broadway Ave' and we are trying to match potentially messy user input (of the form (street1, street2)) to these names. There's no guarantee the ...
- 2,879
1
vote
1
answer
3k
views
How to migrate a PostgreSQL 10 database from Windows C drive to another drive
I have almost an identical problem as this post:
How to migrate a Windows 10 installation of PostgreSQL 9.5.7 to a larger disk
I have a PostgreSQL database on my C drive which is running out of space. ...
- 11
0
votes
1
answer
822
views
ActiveRecord `in_batches` times out after scrolling a few pages
I have a purge job that runs every day cleaning up some old records. I'm using PostgreSQL 10.21.The table in which it is performing the action have these attributes (the ones that are relevant for the ...
- 3
1
vote
1
answer
850
views
Postgres get the next row with bigger value (coparing different columns)
Postgres version: 10
Table example:
CREATE TABLE log (
group_id INTEGER,
log_begin TIMESTAMP,
log_end TIMESTAMP
);
My goal: I want to know, for distinct groups, which log began right ...
0
votes
1
answer
147
views
Postgres 13.6 is using Sequential scan and Postgres 10.18 is using Index Only Scan
We have upgraded our db from version 10.18 to 13.6 and for simple count select I have noticed a different behaviour.
Postgres 13.6:
explain select count(id) from jobs;
...
- 545
0
votes
0
answers
3k
views
Postgresql fatal the database system is starting up
I have a PostgreSQL database which I tried to start in two different machines (same OS version windows 10) without installing. It is started in one machine without issues (immediately started) but ...
- 165
3
votes
1
answer
17k
views
PostgreSQL idle_in_transaction_session_timeout seems to have no effect
I'm working with a PostgreSQL server version 10.5 (can't upgrade it at the moment) running in Docker. XL Deploy is connected to it and I upload a new archive that is 232MB. I get the error FATAL: ...
- 327
1
vote
1
answer
4k
views
How to downgrade a postgres database from version 10 to 9.1?
I have a system that only supports version 9.1 of postgres and a client (company) has been managing their data with version 10. There are many tables and I need to know if there is a script to ...
- 31