[GENERAL] Auotmated postgres failover

Hello I'm looking for a tool to automate PostgreSQL cluster management failover in the event the master database were to become unavailable. Currently are manually issuing a "pg_ctl promote" once we become aware that the master database has crashed. Is repmgr a via solution? Please pass

[GENERAL] Synchronous replication

Is it possible to set up synchronous replication to more that one node in a cluster? Or, am I limited to one synchronous node and one asynchronous node? Assuming my replicated databases are on nodes: testqa1, testqa2. What would my synchronous_standby_names entry in my postgresql.conf on my

Re: [GENERAL] PSQL Tools

windows or Mac OS - Original Message - From: "Melvin Davidson" To: jwienc...@comcast.net Cc: "Adrian Klaver" , pgsql-general@postgresql.org Sent: Sunday, October 18, 2015 9:55:26 AM Subject: Re: [GENERAL] PSQL Tools PgAdmin seems

[GENERAL] PSQL Tools

Hello Is anyone aware of any tools like TOAD that are available for Postgresql? Regards John Wiencek

Re: [GENERAL] PSQL Tools

Hello I am looking for a tool like TOAD for DBA's. I would like something that can generate/extract DDL; report manage tablespace, create explain plans, create/mange users, synonyms, triggers, etc. regards John Wiencek - Original Message - From: "Adrian Klaver"