Re: Setup pgpool-II with streaming replication

Поиск
Список
Период
Сортировка
От Venkata B Nagothi
Тема Re: Setup pgpool-II with streaming replication
Дата
Msg-id CAEyp7J932aTorhB9ADjCuFgxvrnHSr6XkVOvT7m5QONnKHVEXg@mail.gmail.com
обсуждение исходный текст
Ответ на Setup pgpool-II with streaming replication  (Ashish Chauhan <Ashish.Chauhan@support.com>)
Ответы Re: Setup pgpool-II with streaming replication  (Ashish Chauhan <Ashish.Chauhan@support.com>)
Список pgsql-general


I gone through below articles but some or other way require DB server restart which is not possible in our case. Could you please provide some documentation or steps how to achive connection pooling without any downtime?


DB server restart ? Why do you think you need to restart the database ? that can be confirmed if you could help us know your planned architecture and the existing database configuration settings.

Yes, downtime is definitely needed as the Application needs to connect to the database using pgPool port instead of DB port which is something to do with the Application server.

Regards,
Venkata B N

Fujitsu Australia

В списке pgsql-general по дате отправления:

Предыдущее
От: "dandl"
Дата:
Сообщение: Re: What limits Postgres performance when the whole database lives in cache?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Setup pgpool-II with streaming replication