PCI-DSS Requirements

Hi Team, Anyone on PCI-DSS requirements for PostgreSQL DB, need help for some of the points. Regards, Inzamam Shafiq DBA

pgbackrest Help Required

restore commands are configured using traditional zip method. Thanks. Regards, Inzamam Shafiq Sr. DBA

Re: PCI-DSS Requirements

to ask if disk or instance level encryption useful or we should focus on column level encryption? Also if any error occurred during DML and a plain query will be written into the logs which may not be compliant with PCI. How to overcome that? Thanks. Regards, Inzamam Shafiq Sr. DBA

Re: pgbackrest Help Required

info * If standby is having replication issues, then --delta restore using pgbackrest * Check the replication 1. Test Streaming Replication 2. Edit pgbackrest.conf on Standby Node for backup 3. Perform backup from Standby 4. Test Steaming Replication again Regards, I

Autovacuum on sys tables

? Thank you. Regards, Inzamam Shafiq Sr. DBA

Re: Autovacuum on sys tables

Thanks Thomas for the response, It means if I run VACUUM ANALYZE on pg_attribute or pg_class table, it is completely safe? Can you please also please confirm what is meant by "mid-level" vacuum? Regards, Inzamam Shafiq Sr. DBA From: Thomas Bouss

Re: Purging few months old data and vacuuming in production

Hi, I think partitioning will be a good option, you can easily detach partitions will minimal time. Regards, Inzamam Shafiq Sr. DBA From: Ranjith Paliyath Sent: Friday, December 30, 2022 11:39 AM To: pgsql-general@lists.postgresql.org Subject: Purging few

Oracle to PostgreSQL Migration

we want to migrate to PostgreSQL that have a new table structure, so we want to perform data transformation and real time CDC from Oracle to PostgreSQL. Do we have any good open source tool to achieve this with No Coding involved.?? Thanks. Regards, Inzamam Shafiq Sr. DBA

Re: Oracle to PostgreSQL Migration

? Regards, Inzamam Shafiq Sr. DBA From: Ron Johnson Sent: Monday, March 20, 2023 7:15 PM To: pgsql-general@lists.postgresql.org Subject: Re: Oracle to PostgreSQL Migration Real-time CDC is the difficult part. ora2pg (using views) can do a static migration. No coding

Re: Oracle to PostgreSQL Migration

Hi Thomas, We have tried kafka, but in that we stuck in CDC part, update/delete was not working due to some NULL value issue. Do you have any helping material for Oracle to PostgreSQL data migration using debezium? Regards, Inzamam Shafiq Sr. DBA From: Thomas

Re: Oracle to PostgreSQL Migration

Hi Umair, Thanks, oracle_fdw can be used, but it doesn't provide real time sync, we have to schedule jobs to insert data in actual schema from foreign tables, so some delay might be there. Regards, Inzamam Shafiq From: Umair Shahid Sent: Tuesday, Mar

PostgreSQL vs MariaDB

Hi Team, Hope you are doing well. Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)? Thanks. Regards, Inzamam Shafiq Sr. DBA

Re: PostgreSQL vs MariaDB

used at the DB level. There are some triggers and complex procedures as well. Regards, Inzamam Shafiq Sr. DBA From: Ben Chobot Sent: Friday, March 24, 2023 7:08 PM To: Inzamam Shafiq Cc: pgsql-general@lists.postgresql.org Subject: Re: PostgreSQL vs MariaDB

Patroni vs pgpool II

, Inzamam Shafiq

Re: Patroni vs pgpool II

But, I heard PgPool is still affected by Split brain syndrome. Regards, Inzamam Shafiq Sr. DBA From: Tatsuo Ishii Sent: Wednesday, April 5, 2023 12:38 PM To: cyberd...@gmail.com Cc: inzamam.sha...@hotmail.com ; pgsql-general@lists.postgresql.org Subject: Re

Re: Replicate data from one standby server to another standby

Yes, you can replicate data from one slave to another. Sent from Outlook for Android From: Atul Kumar Sent: Sunday, April 9, 2023 3:14:06 PM To: pgsql-general Subject: Replicate data from one standby server to another standby Hi, I have

ETCD for Patroni configuration error

http://xxx.xx.xx.xx:2380"; listen-client-urls: "http://xxx.xx.xx.xx:2379,http://localhost:2379"; advertise-client-urls: "http://xxx.xx.xx.xx:2379"; Regards, Inzamam Shafiq Sr. DBA

Patroni Issue

ponse localhost:5432 - no response 2023-05-10 16:44:19,163 INFO: Lock owner: None; I am pg1 2023-05-10 16:44:19,163 INFO: not healthy enough for leader race 2023-05-10 16:44:19,169 INFO: restarting after failure in progress localhost:5432 - no response localhost:5432 - no response localhost:5432 - no response Thanks. Regards, Inzamam Shafiq Sr. DBA

Re: Replication between different 15.x minor versions ok?

Streaming replication between minor versions works perfectly fine. However, it's better to use same versions but different minor versions also work. Sent from Outlook for Android From: David Tinker Sent: Wednesday, June 28, 2023 3:02:22 p

Re: Regarding HA, Failover and Load Balancing

Hi, You can use combination of patroni, pgbouncer, and HAProxy. patroni will work for auto failover, pgbouncer is for connection pooling and HAProxy can be used for load balancing. These all tools are open source. Regards, Inzamam Shafiq From: Arif Hussain

Re: Connection fails on one system in a address range allowed to connect

you need to allow connection from this IP in your pg_hba file and reload the configurations. From: Johnson, Bruce E - (bjohnson) Sent: Wednesday, November 22, 2023 4:27 AM To: pgsql-general@lists.postgresql.org Subject: Connection fails on one system in a address