Re: [solved] Setting up streaming replication problems

On 01/31/18 13:26, Thiemo Kellner wrote: master by pg_basebackup. This lead to the error of unequal identifier error. Maybe I was not reading carefully enough, however, I was not sure Addendum: The error shows up in the standby log. -- +49 (0)1578-772 37 37 +41 (0)78 947 36 21 SIP/iptel.org:

Re: [solved] Setting up streaming replication problems

Oh, I forgot again already. *shame on me* I tried to set up streaming replication without cloning standby from the master by pg_basebackup. This lead to the error of unequal identifier error. Maybe I was not reading carefully enough, however, I was not sure what to do with the created files an

Re: [solved] Setting up streaming replication problems

Andreas Kretschmer and others of the german mailing list put me on the right track again. My working config changes from standard is as listed below. My problem was, that application_name in primary_conninfo of the standby was missing. This lead the master not to recognise standby having taken

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

Re: Setting up streaming replication problems

Am 22.01.2018 um 07:39 schrieb Thiemo Kellner: Hi all 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 wi

Setting up streaming replication problems

Hi all 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 PostgreSQL documentation an