[pgpool-general: 1130] Re: Configuring pgsql nodes

Mino Haluz mino.haluz at gmail.com
Thu Oct 25 05:19:35 JST 2012


It works :) No error messages for now.

Question, pgpool admin states that there is no replication between
nodes now (also in this scenario it is off). So can I enable binary
log replication within postgresql configuration on those two nodes?

On Wed, Oct 24, 2012 at 9:53 PM, Lonni J Friedman <netllama at gmail.com> wrote:
> Looks like pgpool can't connect to the database server.  Is
> pg_hba.conf configured correctly on the database server(s) ?
>
> On Wed, Oct 24, 2012 at 12:39 PM, Mino Haluz <mino.haluz at gmail.com> wrote:
>> Ok thanks, now arping works. I feel I'm close to the working solution
>> :) now I have these errors, it has something to do with configuration
>> of the postgresql but I do not know how can I fix it:
>>
>> 2012-10-24 21:35:55 ERROR: pid 4769: s_do_auth: expecting R got E
>> 2012-10-24 21:35:55 ERROR: pid 4769: make_persistent_db_connection:
>> s_do_auth failed
>> 2012-10-24 21:35:55 ERROR: pid 4769: find_primary_node:
>> make_persistent_connection failed
>> 2012-10-24 21:35:55 DEBUG: pid 4769: starting health checking
>> 2012-10-24 21:35:55 DEBUG: pid 4769: health_check: 0 th DB node status: 1
>> 2012-10-24 21:35:55 DEBUG: pid 4769: pool_ssl: SSL requested but SSL
>> support is not available
>> 2012-10-24 21:35:55 ERROR: pid 4769: s_do_auth: expecting R got E
>> 2012-10-24 21:35:55 ERROR: pid 4769: make_persistent_db_connection:
>> s_do_auth failed
>> 2012-10-24 21:35:55 DEBUG: pid 4769: health_check: 0 th DB node status: 1
>> 2012-10-24 21:35:55 DEBUG: pid 4769: pool_ssl: SSL requested but SSL
>> support is not available
>> 2012-10-24 21:35:55 ERROR: pid 4769: s_do_auth: expecting R got E
>> 2012-10-24 21:35:55 ERROR: pid 4769: make_persistent_db_connection:
>> s_do_auth failed
>> 2012-10-24 21:35:55 ERROR: pid 4769: health check failed. 0 th host
>> host1 at port 5432 is down
>> 2012-10-24 21:35:55 LOG:   pid 4769: set 0 th backend down status
>> 2012-10-24 21:35:55 DEBUG: pid 4769: failover_handler called
>> 2012-10-24 21:35:55 DEBUG: pid 4769: failover_handler: starting to
>> select new master node
>> 2012-10-24 21:35:55 LOG:   pid 4769: starting degeneration. shutdown
>> host host1(5432)
>>
>>
>>
>> On Wed, Oct 24, 2012 at 6:48 PM, Lonni J Friedman <netllama at gmail.com> wrote:
>>> my arping comes from http://www.skbuff.net/iputils/
>>>  -U     Unsolicited ARP mode to update neighbours' ARP caches.  No
>>> replies are expected.
>>> -w deadline
>>>               Specify  a timeout, in seconds, before arping exits
>>> regardless of how many packets
>>>               have been sent or received. In this case arping does not
>>> stop after  count  packet
>>>               are sent, it waits either for deadline expire or until
>>> count probes are answered.
>>>
>>>
>>> I'm guessing yours comes from here, and seems to be a completely
>>> different implementation:
>>> http://www.habets.pp.se/synscan/programs.php?prog=arping
>>>
>>>
>>> On Wed, Oct 24, 2012 at 9:44 AM, Mino Haluz <mino.haluz at gmail.com> wrote:
>>>> dpkg -l | grep arping
>>>> ii  arping                             2.11-1
>>>> sends IP and/or ARP pings (to the MAC address)
>>>>
>>>> arping -h
>>>> ARPing 2.11, by Thomas Habets <thomas at habets.se>
>>>> usage: arping [ -0aAbdDeFpqrRuv ] [ -w <us> ] [ -S <host/ip> ]
>>>>               [ -T <host/ip ] [ -s <MAC> ] [ -t <MAC> ] [ -c <count> ]
>>>>               [ -i <interface> ] <host/ip/MAC | -B>
>>>>
>>>> no -U and -w microseconds :)
>>>>
>>>> So what -U is doing anyways?
>>>>
>>>> On Wed, Oct 24, 2012 at 6:20 PM, Lonni J Friedman <netllama at gmail.com> wrote:
>>>>> I've got iputils-sss20101006 here.  What version do you have?
>>>>>
>>>>> On Wed, Oct 24, 2012 at 9:17 AM, Mino Haluz <mino.haluz at gmail.com> wrote:
>>>>>> Debian wheezy testing
>>>>>>
>>>>>> On Oct 24, 2012 6:11 PM, "Lonni J Friedman" <netllama at gmail.com> wrote:
>>>>>>>
>>>>>>> On Wed, Oct 24, 2012 at 9:03 AM, Mino Haluz <mino.haluz at gmail.com> wrote:
>>>>>>> > I found out what was making congestion in the network
>>>>>>> >
>>>>>>> > the original
>>>>>>> >
>>>>>>> > arping -U <ip> -w 1
>>>>>>> >
>>>>>>> > BUT -U does not exist anymore and -w means microseconds not seconds.
>>>>>>>
>>>>>>> -U certainly exists in the version of arping that ships on
>>>>>>> modern/recent Linux distributions.  -w means seconds on recent
>>>>>>> versions of arping.
>>>>>>>
>>>>>>> What are you running?
>>>>>>>
>>>>>>> >
>>>>>>> > On Wed, Oct 24, 2012 at 6:01 PM, Lonni J Friedman <netllama at gmail.com>
>>>>>>> > wrote:
>>>>>>> >> On Wed, Oct 24, 2012 at 8:57 AM, Wolf Schwurack <wolf at uen.org> wrote:
>>>>>>> >>> You are missing something - did you read the docs? Here's my info
>>>>>>> >>> which may help
>>>>>>> >>>
>>>>>>> >>>  pgpool.conf
>>>>>>> >>> delegate_IP = '192.20.0.192'  - Your delegate IP
>>>>>>> >>>
>>>>>>> >>> wd_hostname = ' '   - I did not put a hostname, it failed when I put
>>>>>>> >>> in a hostname
>>>>>>> >>
>>>>>>> >> I'm using the IP address of the pgpool node, and it seems to work,
>>>>>>> >> mostly.
>>>>>>> >>
>>>>>>> >>>
>>>>>>> >>> other_pgpool_hostname0 = 'pgpool2'  - This is your other pgpool server
>>>>>>> >>> name. Then on your other server put this pgpool name
>>>>>>> >>
>>>>>>> >> I'm using the IP address of the other pgpool node.
>>>>>>> >>
>>>>>>> >>>
>>>>>>> >>> Wolf
>>>>>>> >>>
>>>>>>> >>>
>>>>>>> >>> -----Original Message-----
>>>>>>> >>> From: martin.formanko at gmail.com [mailto:martin.formanko at gmail.com] On
>>>>>>> >>> Behalf Of Mino Haluz
>>>>>>> >>> Sent: Wednesday, October 24, 2012 9:19 AM
>>>>>>> >>> To: Wolf Schwurack
>>>>>>> >>> Cc: pgpool-general at pgpool.net
>>>>>>> >>> Subject: Re: [pgpool-general: 1106] Configuring pgsql nodes
>>>>>>> >>>
>>>>>>> >>> Thanks for info. I configured two nodes and pgpools and the first
>>>>>>> >>> pgpool boots up ok but second one cannot start because the first one creates
>>>>>>> >>> the virtual IP address already:
>>>>>>> >>>
>>>>>>> >>> wd_init: delegate_IP already exists
>>>>>>> >>> 2012-10-24 17:12:08 ERROR: pid 665: watchdog: wd_init failed
>>>>>>> >>> 2012-10-24 17:12:08 ERROR: pid 665: wd_main error
>>>>>>> >>> 2012-10-24 17:12:08 ERROR: pid 665: unlink(/tmp/.s.PGSQL.9898) failed:
>>>>>>> >>> No such file or directory
>>>>>>> >>> 2012-10-24 17:12:08 DEBUG: pid 665: shmem_exit(1)
>>>>>>> >>>
>>>>>>> >>> Am I missing something or I just did not understand it well ? :)
>>>>>>> >>> Thanks.
>>>>>>> >>>
>>>>>>> >>> On Wed, Oct 24, 2012 at 3:30 PM, Wolf Schwurack <wolf at uen.org> wrote:
>>>>>>> >>>> Take a look at this doc
>>>>>>> >>>>
>>>>>>> >>>>
>>>>>>> >>>> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en
>>>>>>> >>>> .html
>>>>>>> >>>>
>>>>>>> >>>> Wolf
>>>>>>> >>>>
>>>>>>> >>>>
>>>>>>> >>>> -----Original Message-----
>>>>>>> >>>> From: pgpool-general-bounces at pgpool.net
>>>>>>> >>>> [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Mino Haluz
>>>>>>> >>>> Sent: Wednesday, October 24, 2012 6:00 AM
>>>>>>> >>>> To: pgpool-general at pgpool.net
>>>>>>> >>>> Subject: [pgpool-general: 1106] Configuring pgsql nodes
>>>>>>> >>>>
>>>>>>> >>>> Hi,
>>>>>>> >>>>
>>>>>>> >>>> I want to test bit the replication mode of pgool-II, I configured the
>>>>>>> >>>> pgpool.conf but is there any manual how should I configure pgsql
>>>>>>> >>>> nodes
>>>>>>> >>>> so they could connect to the pgpool host ? Thank you,
>>>>>>> >>>>
>>>>>>> >>>> Mino Haluz


More information about the pgpool-general mailing list