Re: FW: Setting up streaming replication problems

From: Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)com>
To: Martin Goodson <kaemaril(at)googlemail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: FW: Setting up streaming replication problems
Date: 2018-01-23 18:08:45
Message-ID: CACh9nsbVC_4DrUj1r34JJFvRfx+d5hX63gpvtrX8Ku9ZbVNM0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jan 23, 2018 11:34 PM, "Martin Goodson" <kaemaril(at)googlemail(dot)com> 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.
>>>
>>
> Anyone two dimes on that?
>
Password, not an md5. Or, at least, that's what's been working for me :)

Even better, I guess, would be to not put a password in there at all and
use a .pgpass.

--
Martin Goodson

"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."

Hello,

Instead you can keep trust connection for that user from only that ip
instead specifying in .Pgpass file.

Anything can be done as per your​convenience.

Regards,
Pavan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2018-01-23 18:21:44 Re: Hardware advice
Previous Message Martin Goodson 2018-01-23 18:04:41 Re: FW: Setting up streaming replication problems