Re: FW: Setting up streaming replication problems

Hi, Am 29.01.2018 um 06:03 schrieb Thiemo Kellner: Thanks for your patience. you are welcome. From the other mail (in german) i think i know the issue now: you have placed the recovery.conf NOT in the data_directoy but in /etc/... PostgreSQL is looking for the recovery.conf in the data_d

Re: FW: Setting up streaming replication problems

Thanks for your patience. On 01/29/18 00:11, Martin Goodson wrote: "A password needs to be provided too, if the primary demands password authentication. It can be provided in the primary_conninfo string, or in a separate ~/.pgpass file on the standby server (use replication as the database name)

Re: FW: Setting up streaming replication problems

On 28/01/2018 22:24, Thiemo Kellner wrote: Me again. Hope you wont feel to bothered by me. I just summarise so far and am still in dire need of guidance. I am not sure whether to put the md5 value of the repuser password into primary_conninfo or the plain one. I don't feel the documentation or

Re: FW: Setting up streaming replication problems

Me again. Hope you wont feel to bothered by me. I just summarise so far and am still in dire need of guidance. Debian 9 with PostreSQL 10. I have two nodes in the cluster I use as master and as standby. I tried to setup replication with Rigg's book and the official documentation and a couple o

Re: FW: Setting up streaming replication problems

Do you mind me bumping the issue? Zitat von "Thiemo Kellner, NHC Barhufpflege" : Andreas, thanks for your reply. I try to set up synchronous streaming replication as try-out. I use my laptop with Debian 9 and PostgreSQL package 10+189.pgdg90+1. And of this PostgreSQL installation I have tw

Re: FW: Setting up streaming replication problems

On 23/01/2018 18:08, Pavan Teja wrote: On Jan 23, 2018 11:34 PM, "Martin Goodson" > wrote: On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: 1) I am not sure whether to put the md5 value of the repuser password

Re: FW: Setting up streaming replication problems

On Jan 23, 2018 11:34 PM, "Martin Goodson" wrote: On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: > 1) I am not sure whether to put the md5 value of the repuser password > >> into primary conninfo or the plain one. I don't feel the documentation >>> or the book is clear on that. >

Re: FW: Setting up streaming replication problems

On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: 1) I am not sure whether to put the md5 value of the repuser password into primary conninfo or the plain one. I don't feel the documentation or the book is clear on that. Anyone two dimes on that? Password, not an md5. Or, at leas

Re: FW: Setting up streaming replication problems

Andreas, thanks for your reply. I try to set up synchronous streaming replication as try-out. I use my laptop with Debian 9 and PostgreSQL package 10+189.pgdg90+1. And of this PostgreSQL installation I have two clusters main (master) and main2 (hot standby). I tried with Rigg's book and the Post