2 postgresql server on the same station : conflict?

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.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 28 May 2013 11:57, image <lcelati@latitude-geosystems.com> 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?

What errors/information do you have when you want to run the second
postgres server while the first is running?

regards
Szymon

Raymond O'Donnell <rod@iol.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�

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 5/28/2013 3:02 AM, Raymond O'Donnell 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.

for RHEL/Fedora/Centos type Linux systems using the PGDG RPMs from the
yum repository, create a file

/etc/sysconfig/pgsql/postgresql-XX

(where postgresql-XX is the name of the init.d start/stop script for the
version you're wanting to munge), and insert into that file the line...

PGPORT=5433
PGDATA=/u01/pgsql/9.2/data

(or whatever). you can add other environment variables that are used by
the server.

you can also use this trick to run more than one instance of the same
version of postgresql. first copy /etc/rc.d/init.d/postgresql-9.2 to
another name, say postgresql-9.2B and then create
/etc/sysconfig/pgsql/postgresql-9.2B with the alternate vales you want
to use. now, `service postgresql-9.2B initdb` and start/stop it etc.

--
john r pierce 37N 122W
somewhere on the middle of the left coast