Pgpool with high availability

HI Team, "I'm encountering challenges while configuring Pgpool with high availability. The initial setup is completed, and Pgpool is operational on a single node, functioning without issues. However, upon attempting to start Pgpool on any additional nodes, particularly node 2, it becomes immediate

Re: Pgpool with high availability

cessible from the leader node (ha0002) but not from the standby nodes (ha0001 and ha0003). Thanks Vijay On Tue, May 28, 2024 at 11:31 PM Adrian Klaver wrote: > > > On 5/28/24 1:31 AM, vijay patil wrote: > > > > HI Team, > > > > "I'm encountering

Re: Pgpool with high availability

mented steps to set up the Pgpool configurations > pgpool.conf,pcp.conf and pool_hba.conf . > > Regards, > Muhammad Imtiaz > > On Tue, 28 May 2024 at 23:01, Adrian Klaver > wrote: > >> >> >> On 5/28/24 1:31 AM, vijay patil wrote: >> > >> &g

Re: Pgpool with high availability

w (master, > standby and standby1) and now what are the issue you are facing? > > Regards > Kashif Zeeshan > > On Thu, May 30, 2024 at 2:00 AM vijay patil > wrote: > >> Thanks Muhammad ! >> >> Here i uploaded details. >> >> Thanks >> Vijay >&g

Re: Issue with Password Authentication for Pgpool

Thanks David. On Thu, Jan 9, 2025 at 11:42 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, January 8, 2025, vijay patil > wrote: > >> Pgpool needs to be restarted for the changes to take effect. >> > > You should look for and lev

Issue with Password Authentication for Pgpool

Hello Everyone, Need assistance on below requirements. My requirement is to prompt for a password when connecting through Pgpool (port ) and to avoid using the pool_password file. However, I’m currently getting the error related to the lack of an entry in the pool_passwd file. Could you plea

Re: Issue with Password Authentication for Pgpool

hns...@gmail.com> wrote: > On Wednesday, January 8, 2025, vijay patil > wrote: > >> This behavior might be related to how Pgpool handles authentication. >> > > Having never used pgpool I very well could be wrong but from what I can > gather what you want to do is simply no

Re: Issue with Password Authentication for Pgpool

configuration changes! Thanks Vijay On Thu, Jan 9, 2025 at 10:47 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, January 8, 2025, vijay patil > wrote: > >> Could you please advise how I can achieve password authentication without >> usi

Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

Hi All, We are exploring auditing solutions for our PostgreSQL database and are considering using pgaudit for this purpose. However, we have a few questions: 1. *What is the best tool for auditing PostgreSQL databases?* - We are specifically looking for a solution that offers det

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

> yours, > > Kenan Çiftçi > > On Tue, Apr 15, 2025 at 1:44 PM vijay patil > wrote: > >> Hi All, >> >> We are exploring auditing solutions for our PostgreSQL database and are >> considering using pgaudit for this purpose. However, we have a few >>

Request for Feedback on PostgreSQL HA + Load Balancing Architecture

Hi Team, I am planning to implement a PostgreSQL High Availability (HA) and Load Balancing setup and would greatly appreciate your feedback on the architecture we've designed (see attached diagram). [image: image.png] *Overview of the Setup:* - Two PostgreSQL nodes (VM1 and VM2) configure