|
Home > Archive > PostgreSQL Administration > April 2005 > Lock file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Marek Dabrowski 2005-04-19, 3:24 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
| |
| Marcin Giedz 2005-04-19, 3:24 am |
| 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
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
| |
| Tom Lane 2005-04-19, 3:24 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)
|
|
|
|
|