From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Victor Wagner <vitus(at)wagner(dot)pp(dot)ru> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Patch (2): Implement failover on libpq connect level. |
Date: | 2015-10-23 21:14:56 |
Message-ID: | CAA-aLv5-uPNejEvFNjAbRPy+4FVSM4Xc=wwqNFr2RfAWm08LJw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
On 23 October 2015 at 12:52, Victor Wagner <vitus(at)wagner(dot)pp(dot)ru> wrote:
> On Thu, 22 Oct 2015 14:33:11 +0100
> Thom Brown <thom(at)linux(dot)com> wrote:
>
>> On 21 October 2015 at 10:07, Victor Wagner <vitus(at)wagner(dot)pp(dot)ru> wrote:
>> > On 2015.10.14 at 13:41:51 +0300, Victor Wagner wrote:
>> >
>> >>
>> >> Attached patch which implements client library failover and
>> >> loadbalancing as was described in the proposal
>> >> <20150818041850(dot)GA5092(at)wagner(dot)pp(dot)ru>.
>> >>
>> >
>> > I'm sending imporoved verison of patch. As Olexander Shulgin noted,
>> > previous version of patch lacks support for service files.
>> >
>> > Now support for service files is implemented and multiple host
>> > statements in the service file are allowed.
>>
>> This is causing breakage:
>>
>> $ pg_basebackup -v -x -D standby1 -h localhost -p 5532 -U rep_user
>> row number 0 is out of range 0..-1
>
> It seems that pg_basebackup should always specify readonly attribute
> for the connection.
>
> Your data directory is named standby1, so I suspect
> that you are trying to make backup from read-only standby instance of
> the base.
No, the -D option on pg_basebackup specifies the directory to receive
the backup into, not from. This is backing up a primary instance.
> Can you check if problem persists in your setup with command
>
> pg_basebackup -v -x -D standby1 \
> -d "host=localhost port=5532 user=rep_user readonly=1"
Yes, this works:
$ pg_basebackup -v -x -D standby1 -d "host=localhost port=5532
user=rep_user readonly=1"
transaction log start point: 0/2000028 on timeline 1
transaction log end point: 0/2000130
pg_basebackup: base backup completed
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2015-10-23 21:20:30 | Re: 9.5Beta1 psql wrapped format expanded output |
Previous Message | Jeff Janes | 2015-10-23 20:56:08 | 9.5Beta1 psql wrapped format expanded output |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2015-10-23 22:28:03 | JDBC driver debug out? |
Previous Message | Korry Douglas | 2015-10-23 20:02:33 | Re: Patch (2): Implement failover on libpq connect level. |