Re: [GENERAL] running multiple versions

2012-02-16 Thread John R Pierce
On 02/16/12 3:10 PM, John R Pierce wrote: so, if I was to install 8.4.somethignelse into a different directory, I'd need to create a seperate service for it, like... sc create postgres-8.4.5 binPath="D:/postgres/8.4.5/bin/pg_ctl.exe runservice -N postgresql-8.4.5 -D D:/postgres/8.4.5/data

Re: [GENERAL] running multiple versions

2012-02-16 Thread Brent Wood
Run them in different locations with different addresses (5432 & 5433 for example) see this thread:http://archives.postgresql.org/pgsql-admin/2008-02/msg00084.php Brent Wood GIS/DBA consultant NIWA +64 (4) 4 386-0300 From: pgsql-general-ow...@postgresql.

Re: [GENERAL] running multiple versions

2012-02-16 Thread Adrian Klaver
On Thursday, February 16, 2012 3:03:45 pm Guillaume Lelarge wrote: > On Thu, 2012-02-16 at 15:00 -0800, Adrian Klaver wrote: > > On Thursday, February 16, 2012 2:17:33 pm Guillaume Lelarge wrote: > > > Hi, > > > > > > > If so can you run different minor versions or only different major > > > > ver

Re: [GENERAL] running multiple versions

2012-02-16 Thread John R Pierce
On 02/16/12 3:00 PM, Adrian Klaver wrote: This is a limitation of the Postgres Windows Installer? Compiling from source would allow running different minor versions. probably the windows service names is the sticking point. you'd need to create a custom service, which could be done with the '

Re: [GENERAL] running multiple versions

2012-02-16 Thread Guillaume Lelarge
On Thu, 2012-02-16 at 15:00 -0800, Adrian Klaver wrote: > On Thursday, February 16, 2012 2:17:33 pm Guillaume Lelarge wrote: > > Hi, > > > > > > If so can you run different minor versions or only different major > > > versions? > > > > Only major versions. > > This is a limitation of the Postgr

Re: [GENERAL] running multiple versions

2012-02-16 Thread Adrian Klaver
On Thursday, February 16, 2012 2:17:33 pm Guillaume Lelarge wrote: > Hi, > > > If so can you run different minor versions or only different major > > versions? > > Only major versions. This is a limitation of the Postgres Windows Installer? Compiling from source would allow running different m

Re: [GENERAL] running multiple versions

2012-02-16 Thread Guillaume Lelarge
Hi, On Fri, 2012-02-17 at 00:11 +0200, Heine Ferreira wrote: > [...] > Is it possible to run more than one instance of Postgresql on Windows? Yes. > Can you run different versions simultaneously? Yes > If so can you run different minor versions or only different major versions? Only major ver

Re: [GENERAL] running multiple versions

2012-02-16 Thread John R Pierce
On 02/16/12 2:11 PM, Heine Ferreira wrote: Is it possible to run more than one instance of Postgresql on Windows? Can you run different versions simultaneously? If so can you run different minor versions or only different major versions? If possible how do you do this? install to different di

Re: [GENERAL] Running multiple versions

2012-01-06 Thread Tom Lane
praka...@uci.edu writes: > Thanks for your reply, Scott. Your suggestion sounds like it would be > fine, but I have a few more questions now. The docs at > http://www.postgresql.org/docs/9.1/interactive/upgrading.html recommend > using the new version's pg_dumpall to back up the existing cluster

Re: [GENERAL] Running multiple versions

2012-01-05 Thread prakashn
> > So assuming all this is done in regular userland. built from source > etc, you'll need to do a couple things. Each version needs to be > built with a different --prefix. I prefer something like > --prefix=/home/myusername/pg83 and --prefix=/home/myusername/pg91 and > so on. This will put the

Re: [GENERAL] Running multiple versions

2012-01-05 Thread Scott Marlowe
On Thu, Jan 5, 2012 at 9:48 PM, Nishad Prakash wrote: > > I'd like to keep my current installation (8.3.3) alive and running while > installing and running 9.1.2 on the same server.  Can I do this using only > the existing postgres superuser account?  I'd want to create two different > initdb loca