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 (view raw or flat )
Thread:
2012-09-12 11:54:59 from amit(dot)kapila(at)huawei(dot)com
2012-09-12 16:41:44 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-09-13 04:00:24 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-12 16:45:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-13 04:22:08 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-13 17:27:52 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-14 13:01:37 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-15 05:57:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-15 07:26:05 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-15 18:44:19 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-16 06:10:43 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-17 07:03:28 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-18 12:32:43 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-09-18 12:50:33 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-09-21 11:18:01 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-01 10:38:49 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-01 15:06:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-02 07:43:50 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-01 16:57:34 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-02 00:02:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-02 03:50:42 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-02 07:36:39 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-02 08:26:24 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-04 10:12:30 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-04 12:27:52 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-08 14:08:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-08 14:42:23 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-09 12:29:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-09 13:04:31 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-10 15:44:34 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-11 10:17:11 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-11 14:52:40 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-11 15:52:25 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-13 16:35:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-15 10:13:01 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-15 14:27:56 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-15 16:31:09 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-16 12:31:08 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-10-18 16:48:31 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-07 17:22:04 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-11-08 16:40:47 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-08 16:56:41 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-17 11:46:04 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-17 13:07:30 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-18 15:19:30 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-10-19 11:42:16 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-08 08:33:42 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-11-08 08:53:53 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-08 17:12:14 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-09 06:03:32 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-12 14:53:58 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-13 04:06:51 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-13 16:02:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-15 13:59:12 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-16 11:40:03 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-01 16:48:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-02 07:11:15 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-04 12:43:08 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-07 14:23:02 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-09 04:02:58 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-16 07:48:17 from Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com>
2013-01-16 10:31:54 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-18 06:50:58 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-18 10:15:53 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-18 11:41:36 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-18 12:05:05 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-18 13:24:54 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-19 12:19:28 from Magnus Hagander <magnus(at)hagander(dot)net>
2013-01-22 09:56:44 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-24 15:13:50 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-18 13:43:08 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-19 12:20:23 from Magnus Hagander <magnus(at)hagander(dot)net>
2013-01-19 17:05:02 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-19 17:33:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-19 20:06:37 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-20 16:45:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-21 12:51:44 from Magnus Hagander <magnus(at)hagander(dot)net>
2013-01-22 06:31:14 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-28 09:45:10 from Magnus Hagander <magnus(at)hagander(dot)net>
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
In response to
Responses
pgsql-hackers by date
Next :From: Stefan KellerDate: 2013-01-18 11:25:18Subject : Re: 9.3 Pre-proposal: Range Merge JoinPrevious :From : Amit kapilaDate : 2013-01-18 10:05:26Subject : Re: Proposal for Allow postgresql.conf values to be changed via SQL
[review]
pgsql-bugs by date
Next :From: TsunezumiDate: 2013-01-18 11:26:57Subject : Re: BUG #7814: Rotation of the log is not carried out.Previous :From : Amit KapilaDate : 2013-01-18 06:50:58Subject : 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
