I have a cluster running on PostgreSQL v13 (1 primary 2 standby). I am trying to migrate a database (has 12 schemas) in this cluster to another PostgreSQL v16 Patroni Cluster ...
Hello everyone, I have 3 users in my database: A_User, B_User. And postgres user by default. The authorizations I give are as follows: GRANT SELECT ON ALL TABLES IN SCHEMA p...
Actually I am investigating this process to migrate some databases from version 13 to version 16. pg_dump is not enough for my database size because it takes too long. From P...
Hello everyone, I want to restore pgbackrest backups from postgresql v13 to postgresql v16. Is this possible? I get a version error. "The data directory was initialized by ...
Hi Community, I use patroni. I configure patronictl edit-config with LDAP authentication. My connections matches the wrong pg_hba line. I get this error : "password authenti...
Hello everyone, How can I log who/when made a select query on a specific table ? I'm using PGAUDIT with pgaudit.log='write, ddl, role'. Since my disk space is limited, I do ...
Hello everyone. When I want to restart my Postgres cluster, I get the following error: "Cluster is already running. Can't open PID file /run/postgresql/15-main.pid (yet?) af...
Hello everyone, I have a question about migrating from mysql to postgresql. I researched some methods. I could do these operations with pgLoader and mysql_fdw. When I reviewe...
Hello everyone, i have a question. When defining user/role operations for web application's DML operations, I authorize my users using predefined roles. there are two differen...
Hello all, I am currently using Ubuntu Server for PostgreSQL Clusters. Which operating system should I choose among Ubuntu Server, CentOS and Rocky Linux for database manageme...
Hi! I have a cluster with 3 servers on Patroni. I map some tables to another external cluster with logical replication. But for some reasons (I cannot understand), the replica...
Hello everyone, What are the popular open source BI Tools/Reporting Tools you use? When I searched on the internet, I saw these: metabase, tableau, looker, qlikview, qliksen...
I have logical replications and foreign data wrappers on target database. I want to transfer only the tables and data without dropping and creating the target database. (in...
I am using patroni cluster with etcd and pgbouncer. I'm trying to find logical replication error logs I cannot find postgresql log files or it doesn't create postgresql log fi...
Data_dir is "var/lib/postgresql/" In patroni.yml Should the log file be under /var/log/postgresql or /var/lib/postgresql or /var/log/patroni?
Hi All, What to use for SSIS-like ETL operations in PostgreSQL? What's the popular way?