Hi Diego
I resolve the problem .
I thank you for the TIP .
A big big big THANKS.
I try now a workaround to get something faster than the PGLB , because I
tested it and I made a select from a table which contains 100.000 data
entries and it makes a delay of 1 second.
I m now trying to let DBBALANCER act as a loadbalancer and keep the 2
cluster-DBs and the Replicator working .
Happy week end from GERMANY !
Diego Gutierrez schrieb:
> Both pglb and pgreplicate run without even a data directory in place.
>
> Anyway, that pglb and postmaster both start using port 5432 is a matter of
> default values: pglb acts like a proxy, so it makes sense to use the same
> port on which postgresql usually listens.
>
> DiegoG
>
> On Friday 25 August 2006 04:04, Largo wrote:
>
>> Hi Diego
>>
>> Sure I did !
>> I ´ configuring postmaster to user 5432.
>> So , U mean PGLB will also start on the same port . I got each component
>> of the PGCluster on a seperate server.
>> I have the LoadBalancer running on a separate machine ; should I start
>> its postmaster or no ?
>> Is postmaster on a LB necessary? I thought yes !
>>
>> Diego Gutierrez schrieb:
>>
>>> Maybe you're running pglb on the same machine as postmaster? If so, you
>>> should change postmaster's port to something else so they don't collide
>>> (search for "port" in postgresql.conf).
>>>
>>> DiegoG
>>>
>>> On Thursday 24 August 2006 09:22, Largo wrote:
>>>
>>>> Hi Everybody
>>>>
>>>> I am now using PGCluster 1.3c (postgresql 8.0)
>>>> I got the following error message directly when I start the pglb at the
>>>> Loadbalancer !
>>>> *ERROR:load_balance_main():PGRcreate_unix_domain_socket failed*
>>>>
>>>> The whole error message was the following :
>>>> ------------------------------------------------------------------------
>>>> --- --------------------------------------
>>>> DEBUG:init_pglb():/usr/local/pgsql/etc/pglb.log open ok
>>>> DEBUG:PGRset_status_on_cluster_tbl():host:sipdb-test1 port:5432 max:32
>>>> use:0 status2
>>>> DEBUG:PGRset_status_on_cluster_tbl():host:sip-test1.kh.emindgroup.com
>>>> port:5432 max:32 use:0 status2
>>>> DEBUG:init_pglb():Child_Tbl size is[49536]
>>>> ERROR:PGRcreate_unix_domain_socket(): bind() failed. reason: Address
>>>> already in use
>>>> ERROR:load_balance_main():PGRcreate_unix_domain_socket failed
>>>> ------------------------------------------------------------------------
>>>> --- -------------------------------------- and PGLB keeps running :
>>>> ------------------------------------------------------------------------
>>>> --- -------------------------------------- ps -aux | grep pglb
>>>> postgres 5351 0.0 0.3 3076 972 pts/1 S 13:58 0:00
>>>> /usr/local/pgsql/bin/pglb -D /usr/local/pgsql/etc -l -n -v
>>>> postgres 5352 0.0 0.3 2996 892 pts/1 S 13:58 0:00
>>>> /usr/local/pgsql/bin/pglb -D /usr/local/pgsql/etc -l -n -v
>>>> postgres 5402 0.0 0.1 1536 452 pts/1 R+ 14:08 0:00 grep pglb
>>>> ------------------------------------------------------------------------
>>>> --- --------------------------------------
>>>>
>>>> I was always working on Postgres 7.4.7 and now :
>>>> When editing "/usr/local/pgsql/data/*postgresql.conf*" , I found that,
>>>> there is no parameter with the name "tcpip_socket" as for PGSQL 7.4.7 .
>>>> So if I add the line "tcpip_socket = true" , the postmaster refuses to
>>>> start and writes
>>>> FATAL: unrecognized configuration parameter "tcpip_socket" .
>>>>
>>>> How can I get this running ?
>>>>
>>>> should I change somethind at :
>>>> unix_socket_directory =
>>>> unix_socket_group =
>>>> unix_socket_permissions =
>>>>
>>>> They are at the moment disabled (commented).
>>>>
>>>>
>>>> Thank you very much for the answer !
>>>>
>>>> Largo
>>>>
>>> _______________________________________________
>>> Pgcluster-general mailing list
>>> Pgcluster-general@xxxxxxxxxxxxx
>>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>>
>> _______________________________________________
>> Pgcluster-general mailing list
>> Pgcluster-general@xxxxxxxxxxxxx
>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general@xxxxxxxxxxxxx
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
|
