Thread: Lock file

Lock file

From
Marek Dabrowski
Date:
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

From
Marcin Giedz
Date:
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

From
Tom Lane
Date:
Marek Dabrowski <marek.dabrowski@infor.pl> 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