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

Mino Haluz mino.haluz at gmail.com
Thu Oct 25 04:39:37 JST 2012


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
>
>
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> L. Friedman                                    netllama at gmail.com
> LlamaLand                       https://netllama.linux-sxs.org


More information about the pgpool-general mailing list