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