pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Lock 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