Lock file

Поиск
Список
Период
Сортировка
Искать

Lock file

От:
Marek Dabrowski <marek.dabrowski@infor.pl>
Дата:
Hello

I've server with two addresses IP on one net interface. I would like 
start on it two instances postgresql, eg: 192.168.1.2:5432 (7.4.6) and 
192.168.1.3:5432 (8.0.2). But when try to start second one, postmaster 
write error that /tmp/.s.PGSQL.5432.lock alredy exist. How to avoid this 
problem?

Regards
Marek

Re: Lock file

От:
Marcin Giedz <marcin.giedz@eulerhermes.pl>
Дата:
Użytkownik Marek Dabrowski napisał:

> Hello
>
> I've server with two addresses IP on one net interface. I would like 
> start on it two instances postgresql, eg: 192.168.1.2:5432 (7.4.6) and 
> 192.168.1.3:5432 (8.0.2). But when try to start second one, postmaster 
> write error that /tmp/.s.PGSQL.5432.lock alredy exist. How to avoid 
> this problem?
>
Hi,

You have to change port parameter in postgresql.conf - default is 5432 
so leave 5432 for first instance and change to 5433 for the second one. 
That's all.

BR,
Marcin

> Regards
> Marek
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

Re: Lock file

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Marek Dabrowski  writes:
> I've server with two addresses IP on one net interface. I would like 
> start on it two instances postgresql, eg: 192.168.1.2:5432 (7.4.6) and 
> 192.168.1.3:5432 (8.0.2). But when try to start second one, postmaster 
> write error that /tmp/.s.PGSQL.5432.lock alredy exist. How to avoid this 
> problem?

Use two different port numbers.

			regards, tom lane
FAQ