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

[Lonni J Friedman]

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
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general



-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama at gmail.com
LlamaLand                       https://netllama.linux-sxs.org