Stack Overflow
Stack Overflow

Questions tagged [postgres-12]

32 questions
0
votes
0 answers

Odoo server not recognizing 'mumu' as database name on localhost:8069

Facing problem in running odoo server localhost:8069 After running the command python odoo-bin -r mumu -w mumu --addons-path=addons -d mumu the output error- 2023-06-03 14:26:06,127 3592 INFO ? odoo: Odoo version 16.0 2023-06-03 14:26:06,127 3592…
Afnan Alauddin Mumu 19-47
  • 1
  • 1
0
votes
0 answers

Postgres select queries inside a transaction is slow

What could be the reason that select queries performed inside a transaction is really slow even though the queries are with just their primary key? I have two tables after updating one row in table1 the query in table2 within the same transaction is…
Sreejith A G
  • 48
  • 9
0
votes
1 answer

`require': /var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres/do_postgres.so: undefined symbol: pg_fprintf

I got this error after upgrading to ubuntu 22.04 from 20.04, what should I do to fix this? :85:in `require':…
Kokizzu
  • 24,974
  • 37
  • 137
  • 233
0
votes
1 answer

Count rows for each distinct column values in result set and display zeros

I have the following table name type created_at John student 2022-10-01 Tom student 2022-10-02 Susan teacher 2022-10-10 I need a query to get the count for each distinct value in type column in filtered result and display zero's if…
Archie
  • 115
  • 1
  • 3
  • 10
0
votes
1 answer

Why the amount of WAL files decrease

I monitor the amount of WAL files in pg_wal. Overtimes, it reduces by itself. I dont have clustering, just single server with logical replication. My parameter : archive_timeout = 3600 min_wal_size = 2 GB max_wal_size = 16 GB wal_keep_segment =…
padjee
  • 125
  • 2
  • 12
0
votes
1 answer

how to bypass postgresql.conf

I have a database that can not be started. It started when I change max_wal_size < wal_segement_size. The error is FATAL ERROR "max wal sender must be at least twice wal_segment_size" I have changed the value back to its original size, but the error…
padjee
  • 125
  • 2
  • 12
0
votes
1 answer

Updating a nested array element in a jsonb column with postgres 12.10

I am trying to update a record in an array. The table is participant and the column is activities with the shape: { enrolled: [{ sport: { id: 1, name: 'soccer' } }, { sport: { id: 2, name: 'hockey' } …
VtoCorleone
  • 16,813
  • 5
  • 37
  • 51
0
votes
1 answer

Postgres query taking long to execute

I am using libpq to connect the Postgres server in c++ code. Postgres server version is 12.10 My table schema is defined below Column | Type | Collation | Nullable | Default | Storage | Stats target | Description…
Mayank Kandari
  • 13
  • 2
0
votes
3 answers

How to prevent duplicates when getting sum of multiple columns with multiple joins

Lets say I have 3 tables: Invoices, Charges, and Payments. Invoices can have multiple charges, and charges can have multiple payments. Doing a simple join, data would look like this: invoiceid | chargeid | charge | …
lucky.expert
  • 743
  • 1
  • 15
  • 24
0
votes
0 answers

Data from FDW loads only once and subscription status = "synchronized"

I'm facing problem within postgres12 FDW and can't understand where is the issue. In DWH we are replicating tables from two difference sources (for example source1 and source2) but there is this once table to whom replication from source keep…
Jānis Freibergs
  • 36
  • 3
0
votes
1 answer

Adding a Serial Column to existing table with 100,000,000 rows

I have a table with roughly 100,000,000 rows. We need to delete around 80,000 of them for a remediation. In order to prevent downtime, I have a job setup to grab the records that needs to be deleted and then processes the delete in chunks of 100.…
Nicole Staline
  • 557
  • 4
  • 15
0
votes
1 answer

Why does psql -f COPY FROM STDIN fail when -c succeeds?

Using psql with COPY FROM STDIN works fine when executed via -c (inline command) but the same thing fails if -f (script file) is used. I've created a Docker-based test to demonstrate below; tested on MacOS w/ zsh and Debian w/ bash. I was unable to…
Neil C. Obremski
  • 18,696
  • 24
  • 83
  • 112
0
votes
1 answer

AWS Aurora Postgres 12 Setting Collation

I am trying to set the collation on AWS Aurora Postgres 12 to a user defined collation type. CREATE COLLATION ndcoll (provider = icu, locale = 'und', deterministic = false); I am able to create the collation just fine. It ends up being entered into…
Eshara Mondal
  • 25
  • 1
  • 3
0
votes
0 answers

Tiger Geocoder - Postgres SSL SYSCALL error: EOF detected with signal 11 segmentation fault

I'm using r6g.4xlarge AWS machine to test tiger geocoder of my own and succeeded in setting up the Tiger Geocoder data of 2019 in a postgresql version 12. I've setup pgtune for better performance and made changes in the postgresql.conf file. When I…
S A R
  • 146
  • 3
  • 20
0
votes
2 answers

How to update a column date of postgres to some days ahead

Im using postgres as my database and I have a table that has a date column. The current value in this column is 2021-04-1 17:19:08 I want to update this column's value and move the date 20 (or any other amount of days) ahead so the new value will be…
Tal Levi
  • 363
  • 1
  • 6
  • 22
1
2
3