Re: [GENERAL] password in recovery.conf [SOLVED]

2014-09-27 Thread Nelson Green
On Fri, Sep 26, 2014 at 6:40 PM, John R Pierce wrote: > On 9/26/2014 4:32 PM, Nelson Green wrote: > >> >> Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became >> obvious >> that I was doing something wrong. And yes, in the end you were right. >> Doubling >> the quote does indeed

Re: [GENERAL] password in recovery.conf [SOLVED]

2014-09-27 Thread Nelson Green
On Fri, Sep 26, 2014 at 6:46 PM, Adrian Klaver wrote: > On 09/26/2014 04:32 PM, Nelson Green wrote: > >> On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver >> > > Doubling the quote seems to work here. >> >> >> Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became >> obvious >>

Re: [GENERAL] password in recovery.conf [SOLVED]

2014-09-26 Thread Gavin Flower
On 27/09/14 11:56, John R Pierce wrote: On 9/26/2014 4:40 PM, John R Pierce wrote: I'd consider using `mkpasswd -l 15 -s 0` just to avoid any such problems. 15 random alphanumerics is already plenty complex, 62^15th possible combinations, without needing to mix in special characters. $ mkp

Re: [GENERAL] password in recovery.conf [SOLVED]

2014-09-26 Thread John R Pierce
On 9/26/2014 4:40 PM, John R Pierce wrote: I'd consider using `mkpasswd -l 15 -s 0` just to avoid any such problems. 15 random alphanumerics is already plenty complex, 62^15th possible combinations, without needing to mix in special characters. $ mkpasswd -l 15 -s 0 eec1kj7ZsthlYmh btw, t

Re: [GENERAL] password in recovery.conf [SOLVED]

2014-09-26 Thread Adrian Klaver
On 09/26/2014 04:32 PM, Nelson Green wrote: On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver Doubling the quote seems to work here. Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became obvious that I was doing something wrong. And yes, in the end you were right. Doubling

Re: [GENERAL] password in recovery.conf [SOLVED]

2014-09-26 Thread John R Pierce
On 9/26/2014 4:32 PM, Nelson Green wrote: Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became obvious that I was doing something wrong. And yes, in the end you were right. Doubling the quote does indeed work. It turns out it this particular password also had a \ in it, and

Re: [GENERAL] password in recovery.conf [SOLVED]

2014-09-26 Thread Nelson Green
On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver wrote: > On 09/26/2014 12:58 PM, Nelson Green wrote: > >> Hello all, >> >> I am setting up a streaming replication stand-by, and the replication >> role password has a single quote in it. I am unable to properly >> reference the password in the conni

Re: [GENERAL] password in recovery.conf

2014-09-26 Thread Adrian Klaver
On 09/26/2014 12:58 PM, Nelson Green wrote: Hello all, I am setting up a streaming replication stand-by, and the replication role password has a single quote in it. I am unable to properly reference the password in the conninfo setting of recovery.conf so it will authenticate to the master. Doub

Re: [GENERAL] password in recovery.conf

2014-09-26 Thread DrakoRod
Hi! Have you tried escape the Single or Double quote? Maybe this information can help you: http://stackoverflow.com/questions/12316953/insert-varchar-with-single-quotes-in-postgresql http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html Best Regards! - Dame un poco de fe,

Re: [GENERAL] password in recovery.conf

2014-09-26 Thread Bosco Rama
On 09/26/14 12:58, Nelson Green wrote: > > I am setting up a streaming replication stand-by, and the replication > role password has a single quote in it. I am unable to properly > reference the password in the conninfo setting of recovery.conf so it > will authenticate to the master. Doubling the

[GENERAL] password in recovery.conf

2014-09-26 Thread Nelson Green
Hello all, I am setting up a streaming replication stand-by, and the replication role password has a single quote in it. I am unable to properly reference the password in the conninfo setting of recovery.conf so it will authenticate to the master. Doubling the quote gives me a syntax error, and es