From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
Cc: | 'Boszormenyi Zoltan' <zb(at)cybertec(dot)at>, 'Hari Babu' <haribabu(dot)kommi(at)huawei(dot)com>, 'Fujii Masao' <masao(dot)fujii(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Magnus Hagander <magnus(at)hagander(dot)net> |
Subject: | Passing connection string to pg_basebackup |
Date: | 2013-01-18 10:15:53 |
Message-ID: | 50F920D9.1040804@vmware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
On 18.01.2013 08:50, Amit Kapila wrote:
> I think currently user has no way to specify TCP keepalive settings from
> pg_basebackup, please let me know if there is any such existing way?
I was going to say you can just use "keepalives_idle=30" in the
connection string. But there's no way to pass a connection string to
pg_basebackup on the command line! The usual way to pass a connection
string is to pass it as the database name, and PQconnect will expand it,
but that doesn't work with pg_basebackup because it hardcodes the
database name as "replication". D'oh.
You could still use environment variables and a service file to do it,
but it's certainly more cumbersome. It clearly should be possible to
pass a full connection string to pg_basebackup, that's an obvious oversight.
- Heikki
From | Date | Subject | |
---|---|---|---|
Next Message | Tsunezumi | 2013-01-18 11:26:57 | Re: BUG #7814: Rotation of the log is not carried out. |
Previous Message | Amit Kapila | 2013-01-18 06:50:58 | Re: Review of "pg_basebackup and pg_receivexlog to use non-blocking socket communication", was: Re: Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown |
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Keller | 2013-01-18 11:25:18 | Re: 9.3 Pre-proposal: Range Merge Join |
Previous Message | Amit kapila | 2013-01-18 10:05:26 | Re: Proposal for Allow postgresql.conf values to be changed via SQL [review] |