Question : I am trying to create a function which will dynamically create a unique table name, populate the table […]
Tag: postgresql-10
Replicate only a few tables in PostgreSQL 10
Question : I have a need to keep updated just a few tables between databases with different purposes and schemas, […]
archive_command failed causing master to run out of disk space. Is there a command that prioritizes master’s health
Question : I had replication set up with a simple archive_command in postgresql.conf: archive_command = ‘rsync -a %p _postgresql@serverip:/var/postgresql/wal_archive/%f’ Which […]
ERROR: could not connect to the publisher: FATAL: no pg_hba.conf entry for replication connection from host
Question : I am trying to create a logical replication between 2 postgres servers. But when I try to create […]
Can a trigger create a TABLE when inserting data?
Question : I have a trigger that keeps track of history of table dev by inserting a row in table […]
Flip a flag from one row to another in a single query
Question : Given this table: CREATE TABLE rollouts ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), device_id TEXT NOT NULL, is_active […]
PostgreSQL. Unstable execution time hugely exceeding planning time
Question : PG version: 10.9 Schema: create table core_bundle ( id serial not null constraint core_bundle_pkey primary key, dt_add timestamp […]
Optimizing a recursive CTE or replacing it with a temporary table
Question : I have a recursive query like this: with recursive PCte(id) as ( select p1.id from Product p1 where […]
Postgres Server staying in read only mode after a barman recover command is executed
Question : All, I am trying to perform a PITR restore using barman using recover command. The problem is that […]
Filter array attribute in jsonb column type using jsonb_array_elements_text
Question : My Postgres version: 10.9 Using JsonB Column type which has a below structure: columnName: favorites { “favouriteCity”: “Boston”, […]