pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLock file
3+ messages / 3 participants
[nested] [flat]
* Lock file
@ 2005-04-19 05:28 Marek Dabrowski <marek.dabrowski@infor.pl>
0 siblings, 2 replies; 3+ messages in thread
From: Marek Dabrowski @ 2005-04-19 05:28 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lock file
@ 2005-04-19 05:36 Marcin Giedz <marcin.giedz@eulerhermes.pl>
parent: Marek Dabrowski <marek.dabrowski@infor.pl>
1 sibling, 0 replies; 3+ messages in thread
From: Marcin Giedz @ 2005-04-19 05:36 UTC (permalink / raw)
To: Marek Dabrowski <marek.dabrowski@infor.pl>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lock file
@ 2005-04-19 06:09 Tom Lane <tgl@sss.pgh.pa.us>
parent: Marek Dabrowski <marek.dabrowski@infor.pl>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-04-19 06:09 UTC (permalink / raw)
To: Marek Dabrowski <marek.dabrowski@infor.pl>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-19 06:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-19 05:28 Lock file Marek Dabrowski <marek.dabrowski@infor.pl>
2005-04-19 05:36 ` Marcin Giedz <marcin.giedz@eulerhermes.pl>
2005-04-19 06:09 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox