97 questions
-2
votes
2
answers
71
views
Postgres LIKE returns a match but = does not [closed]
I am running the below query against a Postgres 16 database:
SELECT * FROM tablename
where entitlementinstanceid = 'entitlementInstance_Z06PPZ0eHoUF';
But I get no results even though there is an ...
- 5
-1
votes
1
answer
39
views
connection failed: :1), port 5432 failed: could not receive data from server: Connection refused
I got this error when im trying to get access to my postgreql db by pgAdmin.
[tag:connection failed: :1), port 5432 failed: could not receive data from server: Connection refused]
Run this brew ...
2
votes
1
answer
70
views
Postgresql SELECTs went from 0.6s to 10+s after killing a (different) long running SELECT query
We are running a PostgreSQL 16.2 server on a dedicated physical machine with local storage. This database has been stable and fast for years. We started seeing significant and increasing slowdowns on ...
- 21
0
votes
1
answer
33
views
ZEOSLIB, Delphi error: "close all lob streams before closing the resultset"
I am getting this error when exiting my application. I am using delphi 7 with ZEOSLIB 8, PostgreSQL database ver 16.
The Delphi statement I use for loading blobs from database into bitbutton blobs is ...
- 6,537
1
vote
1
answer
56
views
How to improve Postgres pg_trgm for text similarity and make more similar text rank higher?
I am using Postgres's pg_trgm for finding similarity of alphanumeric text based on trigram matching. The text being searched on is a title column containing various titles of news articles.
SELECT ...
0
votes
1
answer
245
views
Could not create postgis-3 extension in postgresql-16 on Ubuntu 22.04
I was recreating my database with fresh test data, so I dropped / created it.
I installed Postgres 16 / postGIS 3 successfully on Ubuntu 22.04 a month ago, but then after I dropped my database, the ...
- 21
0
votes
0
answers
55
views
Update join effect not visible in first run of select
I have this very strange behavior using pglite (PostgreSQL version 16) in Firefox, where I run an UPDATE JOIN, and then a SELECT which the first time around doesn't reflect the change made by the ...
- 10.6k
1
vote
4
answers
109
views
Switch ASC / DESC in ORDER BY with a CASE construct?
In PostgreSQL, I am trying to have SQL which orders by multiple columns. The first column will always be priority DESC NULLS LAST. The second one needs to be dynamic based on some conditions (for ease ...
0
votes
1
answer
66
views
What does `+` (plus) means next to enum elements [duplicate]
I'm playing with Postgresql ENUM types, and noticed something I can't find explanation for:
Schema | Name | Internal name | Size | Elements | Owner | Access privileges | ...
- 6,697
0
votes
1
answer
263
views
AAD roles on Postgres flexible server
Happy Friday, fellow IT people!
I am creating infrastructure for Azure Postgres flexible server along the roles required for authentication via terraform. Below is the contents of my main.tf file:
...
1
vote
1
answer
199
views
Use MERGE with CTE
Does Postgresql allow use of cte as source of the MERGE instruction ?
CREATE TABLE IF NOT EXISTS graph
(
idgraph SERIAL PRIMARY KEY,
from_table varchar(128)
);
WITH cte2 AS
(
SELECT 'tag'...
- 10.6k
0
votes
0
answers
90
views
PostgreSQL pg_dump Fails: Password Authentication Error with Special Characters in Password
I am trying to execute a pg_dump command from PostgreSQL using a stored procedure. My setup uses EXECUTE format to dynamically construct the command. Here is the relevant code:
'COPY (SELECT 1) TO ...
- 131
0
votes
3
answers
413
views
ERROR: must be owner of table, but I am superuser
I have an postgres 16 DB in Docker container with volume. I wanted to hide standard postgres user and changed it's name to super (as example). Now I try to make something with any tables (DDL ...
0
votes
0
answers
34
views
Django Docker Setup: OperationalError - "FATAL: database 'guardian_grid' does not exist" with PostgreSQL After Running for a Few Days
I’m experiencing a recurring issue with my Django project configured to run with PostgreSQL in Docker. After a few days of smooth operation, the PostgreSQL database unexpectedly fails, and I receive ...
1
vote
1
answer
128
views
How to set replica identity full for a table having different owner?
I have two owners in my postgresql database e.g. testdb, I have some tables of owner1 and some tables of owner2. I am facing issue in setting replica identity full for tables of owner1 using owner2 ...
- 11