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

Thu Oct 25 04:53:42 JST 2012

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