From: | Nelson Green <nelsongreen84(at)gmail(dot)com> |
---|---|
To: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | password in recovery.conf |
Date: | 2014-09-26 19:58:04 |
Message-ID: | CAGo-KZkX-c7APeE9uZOm-9kECZYLLVvNzAzica1h2Xs=JSBAMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 escaping it
or quoting it with double-quotes gives me an authentication error. The
password is correct because I can copy it from the recovery.conf and supply
it when prompted by pg_basebackup, so if I may, what is the proper way to
handle single quotes within the conninfo string?
Obviously I can change the password, but we use an automated password
generator so I'd like to not have to keep generating passwords, and
checking them, until I get one that will work, unless that my only option.
Thanks,
Nelson
From | Date | Subject | |
---|---|---|---|
Next Message | Bosco Rama | 2014-09-26 20:24:59 | Re: password in recovery.conf |
Previous Message | David G Johnston | 2014-09-26 16:24:48 | Re: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device |