Stack Overflow
Stack Overflow

Questions tagged [postgresql-13]

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

368 questions
0
votes
1 answer

upgrading postgres 11 to 13 fails in consistency check

when i try to upgrade Postgres from version 11 to version 13 using this command: /usr/lib/postgresql/13/bin//pg_upgrade -b /postgresql/11/bin/ -B /postgresql/13/bin/ -d /data/service/postgres.1061/nanny/data/postgres -D…
Muthu Naaraayanan
  • 25
  • 1
  • 9
0
votes
2 answers

Postgresql - How to query postgresql array element

I have JSON data in PostgreSQL 13 table. I want to query this table in such a way that in the output it will print each element on the array in a separate column. I tried using the below query which uses ->> operator but it is not giving me the…
Vikas J
  • 795
  • 3
  • 14
  • 31
0
votes
0 answers

How to pass pg-promise transaction/task between ExpressJS middlewares?

ExpressJS can have a chain of middlewares for a single route, which at the very least allows to split input validation logic from the actual handling of the inputs. The usual pattern looks like this: import { Router } from "express"; const router =…
Biller Builder
  • 303
  • 3
  • 10
0
votes
1 answer

postgres pg_column_compression is giving error: No function matches the given name and argument types?

My Postgres DB version is 13.5. When I run - SELECT pg_column_size(jdoc) FROM dataingest.refresh limit 10; I am getting result as expected. pg_column_size| --------------+ 2523| 2530| But when I run - SELECT …
samshers
  • 1
  • 6
  • 37
  • 84
0
votes
1 answer

Cannot drop schema because schema does not exist but it exists in pg_namespace

I am having a problem with dropping schema to create it again. When I run: drop schema 'schema_name' cascade I get the error message saying "schema does not exist". But when I search pg_namespace, the 'schema_name' is still there; even with \dn in…
DorothyL
  • 3
  • 1
0
votes
0 answers

How to get selected json objects from a nested json in postgres sql

I have the data stored in a table named 'userfields' the below format in one of the columns named 'params' in Postgres SQL. I want to select two json objects and the output should be in the same format { "default": { …
Gopinath Thatha
  • 1
  • 1
0
votes
0 answers

SQL Statement takes 7h instead of 1:30min after update PostgreSQL 10 to PostgreSQL 13. Why? How to fix that?

There are a number of SQL Statement I have to repeat on a regular basis. After my PosgreSQL Version was updated from 10 to 13 one particular querytakes 7 hours instead of 1:30min. That's the query: SELECT polyssqlspatial.objid,…
bluesky
  • 1
  • 2
0
votes
0 answers

Connection to server at port 5436 failed running on docker

I am trying to install pgAdmin4 in my windows machine. I am getting error message of connection to server failed. I found a similar kind of issue here but the solution doesn't work. I have been struggling with the issue and didn't found any working…
DevD
  • 304
  • 1
  • 4
  • 11
0
votes
0 answers

Why is PostgreSQL giving me an UndefinedFunction error (Version 9.6)

I'm learning PosgreSQL, i'm trying to call function get_color in a SELECT statement inserting the column name of the table as parameter, but PostgreSQL version 9.6 (i've tried on 13.0 with the same result) returns me an UndefinedFunction…
EDOARDO ROSSO
  • 1
  • 3
0
votes
0 answers

Postgis st_transform error: SQL Error [XX000]: ERROR: could not form projection (LWPROJ) from 'srid=7801' to 'srid=4326'

I have 4 servers with the same versions of OS (Ubuntu 20.04), Postgis and Postgre: POSTGIS="3.2.1 5fae8e5" [EXTENSION] PGSQL="130" GEOS="3.10.1-CAPI-1.16.0" PROJ="6.3.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0…
Ivaylo Nikolov
  • 1
  • 1
0
votes
0 answers

Why do i get PG::ConnectionBad: FATAL: role "webapp" does not exist when i migrate ruby on rails from heroku to elastic beanstalk?

I am migrating a Ruby on Rails app from Heroku free tier to Amazon Elastic Beanstalk. I've successfully pg_dump ed the Heroku database and pg_restore d into Amazon RDS. The RDS_HOST, RDS_PORT environment variables are set. When I try to deploy…
Davie Overman
  • 114
  • 1
  • 13
0
votes
0 answers

MS-SQL & Postgresql behavior against READ-COMMITTED isolation level is acting differently

When we run the CASE:A & B one line by line (means one line CASE:A then one line CASE:B) MS-SQL Hangs on select statement but PostgreSQL executes it very well CASE:A SET TRANSACTION ISOLATION LEVEL READ COMMITTED begin transaction insert into…
Viny
  • 13
  • 2
0
votes
0 answers

how to know who tries to connect to a database in postgresql

I have a server with postgresql 13 and several postgresql clients that are mutually synchronized by logical replication. Due to problems with the replication in base A that I couldn't solve, I decided to create another identical base B, pass all the…
vittorio
  • 1
  • 1
0
votes
0 answers

Required Configuration for DC-DR Sync in Patroni PostgreSQL Setup

We have a cluster of 3 nodes in DC and a cluster of 3 nodes in DR. I need to sync DR leader from DC Leader keeping both cluster separated from each other. Though I got a solution of adding parameter standby_cluster from link: DC-DR Sync issue in…
Aviral Singh
  • 1
  • 3
0
votes
1 answer

How to change Odoo Logo on POS - Odoo 16 installed on Docker?

I try to find the location of the Odoo logo on POS, but I could not find it any where in my VPS. Search the answer online and found out that I could change it in location, but I have not found the directory yet. Any suggestion? Thanks in…
semighoti
  • 11
  • 1
1 2 3
…
24 25