Stack Overflow
Stack Overflow

Questions tagged [postgresql-14]

Use this tag to indicate that your question is about PostgreSQL version 14. Questions concerning database administration should go to https://dba.stackexchange.com/

227 questions
0
votes
1 answer

How to query Postgresql-14 Timestamptz field in C#?

I use Postgresql-14, I have a timestamptz field named 'start_datetime' like below: select start_datetime from table1 2023-08-01 07:00:00.000 +0700 2023-08-01 07:00:00.000 +0700 2023-08-02 07:00:00.000 +0700 2023-08-03 07:00:00.000 +0700 2023-08-04…
Donald
  • 551
  • 2
  • 6
  • 22
0
votes
0 answers

Change in plan after upgrading aurora Postgres from 13.4 to 14.8

Recently upgraded Aurora Postgres from 13.4 to 14.8. We observe there is a change in plan for many SQL's and causing major performance issue. Is there any change in optimizer in v14.8.? SQL Query select row_number() over ( order by…
MOHAN
  • 1
0
votes
3 answers

Strict condition check on each element of jsonb array postgres

I have a table master_data_approval_table in my postgres DB having field approval_value (type Jsonb) which contains below structure: We want only those records where each object of jsonb array strictly matches the given condition "status":…
srp
  • 619
  • 7
  • 18
0
votes
1 answer

Unable to setup connection through pgAdmin, says `password authentication failed for user "postgres" `

I was configuring postgresql and pgAdmin4 in my system, for a project i have been working on. Followed the process as directed in the official documentation, installed and started postgresql using these commands sudo apt update sudo apt install…
Adi Akhilesh Singh 5-Year IDD
  • 1
  • 1
0
votes
0 answers

node inaccessible via SSH postgresql

inaccessible via SSH [postgres@hq-pgsql-test01 ~]$ repmgr cluster crosscheck INFO: connecting to database Name | ID | 1 | 2 -----------------+----+---+--- hq-pgsql-test01 | 1 | * | * hq-pgsql-test02 | 2 | ? | ? WARNING: following…
khaled ghazy
  • 1
  • 2
0
votes
0 answers

psql configuration problems

I am running postgres on Ubuntu 22.04 and whenever I run psql -U postgres I get the error psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: password authentication failed for user "postgres" This is…
akaleonard
  • 1
  • 1
0
votes
0 answers

Citus logs show error after upgrade to 11.2

I have upgraded Citus extension from 10.2 to 11.2 running on postgres version 14. I disabled the version checks for citus and was able to apply the extension to database for the coordinator and workers nodes and than on coardinator node, I did run…
Devaddy
  • 45
  • 6
0
votes
0 answers

pg_agent can't connect to server

Good afternoon. Red Hat 8.7. Postgresql Pro Standard 14.8. When execute: pgagent_14 hostaddr=127.0.0.1 dbname=postgres user=postgres port=5432 password=somepassword Error: WARNING: Couldn't create the primary connection Password checked in…
mraklbrw
  • 23
  • 3
0
votes
1 answer

Using Seq scan even though the column has an Index

We've a requiremant ie., Result should come within in 3 seconds. Here i've described about 2 large tables which are having around 20Million records. As commented earlier, when we combine two columns of a different tables(1 is integer data type &…
jptech84
  • 1
  • 3
0
votes
1 answer

Migrate from serial to identity

We have a table in a Postgres 14 DB which id was created using SERIAL and we want to migrate to using IDENTITY instead. That table already has a lot of entries in prod. How can we safely migrate to IDENTITY? I did some research and found a script…
Edd
  • 1,948
  • 4
  • 21
  • 29
0
votes
0 answers

to_timestamp in generated column

I have a table in my DB (PstgreSQL 14) that is auto-generated by another software. This table contains a t_stamp column stored as a BIGINT. I need to use this t_stampsomewhere else as a TIMESTAMP data type. I thought about creating a generated…
Sim
  • 45
  • 1
  • 7
0
votes
0 answers

YuniQL own schema updates

We're using YuniQL as our schema versioning and database migration engine for a Postgres DB. The issue we're seeing is the following: We ran YuniQL initially with version v1.1.55.0 Yuniql creates the __yuniql_schema_version table with the schema…
Edd
  • 1,948
  • 4
  • 21
  • 29
0
votes
1 answer

PostgreSQL EXPLAIN gives two different plans for same query

I have a SQL export of a cloud-based Postgres DB that I've imported locally (Alpine PG 14.5 on Docker). I'm having an issue where a query returns two different results on each one (both are running 14.5). The remote machine has 7.5GB memory and 2…
jbeck
  • 2,184
  • 1
  • 19
  • 21
0
votes
1 answer

PostgreSQL UPDATE waiting

I have a web application which uses VUE, FastAPI and PostgreSQL. We constantly use this web app and recently it started to be unresponsive to logins and everything. I checked the logs of FastAPI because VUE seemed like it was working properly, there…
efesefe
  • 3
  • 4
0
votes
1 answer

Regex lookbehind with 2 options in Postgres substring

I need to extract text which has two possible formats for the preceding text. To be used in Postgres function In each of the two examples below the desired result is Request successful [May 08, 12:06AM] Request successful [Apr 18, 12:10AM] Request…
thehill
  • 93
  • 11
1 2 3
…
14 15