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
0 answers

pg_rewind succeed but postgresql showing error when trying to make standby with common ancestor

Have 3 node setup: node1(50.2), node2(50.3) and node3(50.4). node1(50.2) is primary and node2(50.3) and node3(50.4) are standby. I promoted node2 and node3 to make them independent. When i try to make the node3 slave of node2, using pg_rewind, it…
Niraj Nandane
  • 1,318
  • 1
  • 13
  • 24
0
votes
1 answer

Restoring a database dump throws lots of «could not open file "base/nnnnn/nnnnn"» errors

I'm trying to restore a database dump from Render locally which worked fine in the past. But now I get lots of errors. $ PGPASSWORD="###" pg_dump -h ###.render.com -O -U app_production app_production >dump.sql $ psql -U app_production -f dump.sql…
svoop
  • 3,318
  • 1
  • 23
  • 41
0
votes
0 answers

PGAFIS Extension Installation Guide

I need to install the PGAFIS on my postgress database in order to use it for a project. However, I cannot find any guide on how to compile or install the extension. Neither does the extension has any tangible document on implementation online. I…
Darren Williams
  • 1
  • 1
0
votes
0 answers

old and new data directory size of postgresql does not match

I am trying to update PostgreSQL 11.2 to PostgreSQL 14.0. My PG 11 Data directory size is 1.1 GB and my PG 14 data directory is 41 MB before the upgrade. I am now running my below upgrade command: "C:\Program…
Bala
  • 184
  • 3
  • 19
0
votes
0 answers

pgbench : too many client connections for select()

I was working on benchmark testing for pg10 and pg14. I did the testing for 100 clients with 12 threads in pg14 I was getting following error, "pgbench:too many client connections for select()" (screen shot attached) The same was working fine in…
mathin0496
  • 1
0
votes
1 answer

Can't find temporary table in pg_class

I have created a large temporary table. I can find it in the /var/lib/pgpro/1c-14/data/base/16385 directory (where 16385 is the OID of the database). /var/lib/pgpro/1c-14/data/base/16385$ ls | grep -Eh…
RomanShan
  • 11
  • 5
0
votes
1 answer

Return entire row from table and columns from other tables

I'm using postgresql 14 and trying to return an entire record from a table in addition to columns from different tables. The catch is, that I don't want to write all the titles in the record. I tried working with the guide lines here [1], but I'm…
Liran_T
  • 69
  • 7
0
votes
2 answers

Restoring Postgres Database from backup does not work - public.uuid_generate_v1() does not exist

I am restoring a postgres database via .backup file from one postgres-14 instance to another: pg_restore -h localhost -p 5432 -U postgres -d mydatabase -v "mybackupfile.backup" The backup fails, complaining about pg_restore: error: could not execute…
Lokomotywa
  • 2,624
  • 8
  • 44
  • 73
0
votes
1 answer

PgBouncer - Server DNS lookup failed

I am trying to test PgBouncer connection with pgbench on a PostgreSQL server. But I'm getting error as closing because: server DNS lookup failed and at pgbench getting this message: pgbench -c 10 -t 10 -C -f…
yugck
  • 11
  • 3
0
votes
1 answer

Is it possible to EXPLAIN ANALYZE COPY from a file to a table in POSTGRESQL?

I'm trying to analyze if the triggers before and after on my table with huge data to check for any bottlenecks and for improvements but i'm getting syntax error and wanted to see if it's possible to do EXPLAIN ANALYZE COPY i did some research but…
John-rym Aoun
  • 3
  • 1
0
votes
0 answers

PostgreSQL pgbench error "pgbench: fatal: could not count number of branches: ERROR: relation "pgbench_branches" does not exist"

I am getting error like "pgbench: fatal: could not count number of branches: ERROR: relation "pgbench_branches" does not exist" when i ran the commmand "pgbench -c 20 -t 1000 -C -f d:\test_postgres\script.sql -p 5432 -U postgres -S Shiftlog" in…
Pavuluri Satishbabu
  • 1
  • 2
0
votes
2 answers

Number format equivalent function in PostgreSQL

Trying to format the number as per the given format and culture. Given: -4059587.225000, --Value '#,##0.00;(#,##0.00)' --Format 'en-US' --Culture Will have many patterns, the given one is for example. Expected output: (4,059,587.23) In SQL Server…
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
1 answer

How can I select just the first X characters from a text column

On my PostgreSQL DB I have a table that looks like below. The description column can store a string of any size. What I'm looking for, is a way to select just the first X chars from the content of the description column, or the whole string if X >…
Yonoss
  • 1,242
  • 5
  • 25
  • 41
0
votes
1 answer

postgresql upsert on view with triggers

I'm working with a postgresql 14 database where I have access to data through a view schema, and inserts and updates are performed with triggers. There is a unique constraint on the storage table, and I was wondering if there is a way to do upserts…
Norling
  • 1,153
  • 2
  • 10
  • 24
0
votes
0 answers

how to import .csv file in PostgreSQL?

create table covid19( FIPS varchar(6), Admin2 VARCHAR(41), Province_State VARCHAR(40), Country_Region VARCHAR(32), Last_Update VARCHAR(19), Lat VARCHAR(19), Long_ varchar(19), Confirmed integer, Deaths integer, Recovered…
簡宥文
  • 1
  • 1
1 2 3
…
14 15