Thread: 2 postgresql server on the same station : conflict?
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? Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/2-postgresql-server-on-the-same-station-conflict-tp5757102.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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
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°
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