Thread: pg_basebackup -R option in PG 9.3 beta
On Wednesday, May 15, 2013 2:50 PM Raghavendra wrote:
>Hi,
>
>While trying new features of Pg 9.3 beta, my eyes caught on pg_basebackup -R option so I have given a try but somehow I didn't succeed it to work...
>
>-bash-4.1$ ./pg_basebackup --version
>pg_basebackup (PostgreSQL) 9.3beta1
>
>-bash-4.1$ ./pg_basebackup -h localhost -D ../data_bkp -p 5555 -U postgres -R
>./pg_basebackup: symbol lookup error: ./pg_basebackup: undefined symbol: PQconninfo
>
>Can anyone help me where am doing the mistake ?
I feel the library is not able to load while executing pg_basebackup.
Try the following command in linux and check it.
export LD_LIBRARY_PATH=<lib path>
Regards,
Hari babu.
On Wednesday, May 15, 2013 2:50 PM Raghavendra wrote:
>Hi,
>
>While trying new features of Pg 9.3 beta, my eyes caught on pg_basebackup -R option so I have given a try but somehow I didn't succeed it to work...
>
>-bash-4.1$ ./pg_basebackup --version
>pg_basebackup (PostgreSQL) 9.3beta1
>
>-bash-4.1$ ./pg_basebackup -h localhost -D ../data_bkp -p 5555 -U postgres -R
>./pg_basebackup: symbol lookup error: ./pg_basebackup: undefined symbol: PQconninfo
>
>Can anyone help me where am doing the mistake ?
I feel the library is not able to load while executing pg_basebackup.
Try the following command in linux and check it.
export LD_LIBRARY_PATH=<lib path>
Regards,
Hari babu.
>on Wednesday, May 15, 2013 4:04 PM Raghavendra wrote:
>In earlier version of primary connection information was enclosed within one single quote:
>primary_conninfo = 'user=postgres host=localhost port=5432'
>
>But, the file created with -R option (recovery.conf) has doubled the single quotes for all variable values user/host/port/sslmode/sslcompression in primary connection.
>
>standby_mode = 'on'
>primary_conninfo = 'user=''postgres'' host=''localhost'' port=''5555'' sslmode=''disable'' sslcompression=''1'' '
>
>Was it intentional to double the singe quotes of variable values ?
Yes, It was intentional to support some of the special characters in configuration parameters which can be used in the primary_conninfo.
There is a patch in the next commit-fest which is further extending the special characters in password.
Please refer the following link.
https://commitfest.postgresql.org/action/patch_view?id=1085
Regards,
Hari babu.
>on Wednesday, May 15, 2013 4:04 PM Raghavendra wrote:
>In earlier version of primary connection information was enclosed within one single quote:
>primary_conninfo = 'user=postgres host=localhost port=5432'
>
>But, the file created with -R option (recovery.conf) has doubled the single quotes for all variable values user/host/port/sslmode/sslcompression in primary connection.
>
>standby_mode = 'on'
>primary_conninfo = 'user=''postgres'' host=''localhost'' port=''5555'' sslmode=''disable'' sslcompression=''1'' '
>
>Was it intentional to double the singe quotes of variable values ?
Yes, It was intentional to support some of the special characters in configuration parameters which can be used in the primary_conninfo.
There is a patch in the next commit-fest which is further extending the special characters in password.
Please refer the following link.
https://commitfest.postgresql.org/action/patch_view?id=1085
Regards,
Hari babu.