Re: pg_basebackup with -R option and start standby have problems with escaped password

On Wed, Jan 23, 2013 at 10:18 AM, Hari Babu <haribabu(dot)kommi(at)huawei(dot)com> wrote:
> Test scenario to reproduce:
> 1. Start the server
> 2. create the user as follows
> ./psql postgres -c "create user user1 superuser login
> password 'use''1'"
>
> 3. Take the backup with -R option as follows.
> ./pg_basebackup -D ../../data1 -R -U user1 -W
>
> The following errors are occurring when the new standby on the backup
> database starts.
>
> FATAL: could not connect to the primary server: missing "=" after "1'" in
> connection info string

What does the resulting recovery.conf file look like?

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/