Written by 
Image I am using: cnpg-postgresql16-citus12:16.4-bookworm. Data is backed up on s3 using barmanObjectStore The restoration manifest being used is… externalClusters: – name: citus-cnpg-coord barmanObjectStore: wal: compression: gzip maxParallel: 8 encryption: AES256 destinationPath: s3://blitz-citus-backup/citus-cnpg-coord s3Credentials: accessKeyId: name: s3-backup-bucket-secret key: accessKeyId secretAccessKey: name: s3-backup-bucket-secret key: secretAccessKey bootstrap: recovery: source: citus-cnpg-coord However, as the recovery init job starts, […]
I tried to login after adding log4net to create logs in the Postgres SQL Database but, failed to login. The issue is “ERROR: {code: 0, message: ‘An internal error occurred during your request!’, details: null, validationErrors: null}” from the console. This code is in log4net.config file, I tried using below code for datetime parameter to […]
In a previous blog post, we’ve advertised the use of SQL EXISTS rather than COUNT(*) to check for existence of a value in SQL. I.e. to check if in the Sakila database, actors called WAHLBERG have played in any films, instead of: SELECT count(*) FROM actor a JOIN film_actor fa USING (actor_id) WHERE a.last_name = […]