We use postgresql as a database. For the backup part, we store full cluster backups and wal files to allow point in time restoration of our database. Our wal files take up quite a bit of space when compared to…
I have a table with year, area codes and each area code has 5 categories of age groups with people count as below. year areacode agegroup persons 2021 code 1 20-29 5 2021 code 2 30-39 11 2022 code 1…
I have a table definition like the following: CREATE TABLE what_happened ( id SERIAL PRIMARY KEY, action VARCHAR(128), created TIMESTAMP WITH TIME ZONE NOT NULL ); I want to be able to store the original time offset given for the…
I have a bit column (for example, 'Column'). How can I compare the value of this column to just any number? SELECT * FROM TABLE WHERE 'Column' = 5 After executing the above query, I get an error message: the…
We're doing a Postgres native logical replication between two databases. Now, we're getting an error trying to update from the publisher one of thousand tables that we have. When we try to update the table it returns this error: ERROR:…
I created a table for to store day off data of users. After, set a unique index for multi column but when exec insert sql, it duplicates datas again Here's my DDL: create table day_off_movements ( id bigserial primary key,…
I am creating pg dump of a database using following command: pg_dump mydatabase -Fc -c -U mydatabaseuser -f mydatabase_pgdump_$(date +^CY%m%dT%H%M") Then i am trying to to restore that dump using following: pg_restore -d mydatabase -U postgres mydatabase_pgdump_20230422T0540 However, this gives…
Our logical replication has started to fail with a lot of these errors on the subscriber: ERROR: could not create replication slot "pg_148211637_sync_148178452_7161337762731575223": ERROR: all replication slots are in use May 2 07:43:01 psql-06 postgres[1195903]: [2] HINT: Free one or…
I have table in PostgreSQL with 2 columns: id employee_id In this table there are some records with duplicated employee_id but always unique id. I need to get unique employee_id with highest id possible. What i want to achieve is…
I am trying to publicate the cnt_title table using PostgreSQL Logical Replication. Note that I only want to share the product titles. create publication cnt_publication_for_stk for table cnt_title where (doc_type = 'PRODUCT'); What I have found is a syntax error…