Re: 2 postgresql server on the same station : conflict?

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 2 postgresql server on the same station : conflict?
Date: 2013-05-28 10:27:09
Message-ID: 20130528102709.GA21179@tux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> On 28/05/2013 10:57, image wrote:
> > Hello,
> >
> > On the same station, i have 2 postgresql server: one for my postgis db
> > (v9.1) and so another installed with opener^7 (9.2). Unfortunalty, i noticed
> > i'm obliged to stop service for my postgresql postgis (9.1) in order to use
> > openerp7 (postgres9.2). I 'm surprised about that. There is there a way to
> > use these two servers at the same time?
>
> Yes, absolutely - just run them on different ports (assuming you're
> connecting on TCP/IP). Set the "port" directive in postgresql.conf, and
> restart.

Not only different ports: different data directories.

But why 2 databases? PostGIS works well with 9.2, he can use ONE
database config/server for both tasks.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2013-05-28 11:31:34 Re: Success stories of PostgreSQL implementations in different companies
Previous Message DT 2013-05-28 10:11:03 What are ExecSeqMarkPos and ExecSeqRestrPos used for