Re: [GENERAL] two or more pg installations running as the same user

2008-11-26 Thread Grzegorz Jaśkiewicz
2008/11/26 Mikko Partio <[EMAIL PROTECTED]> > You know you don't need separate clusters (ie. installations) to have > multiple databases? > obvioiusly. so far I just do: mkdir $INST export PGDATA=$INST export PGPORT=$INSTPORT initdb pg_ctl start .. and that's it folks. -- GJ

Re: [GENERAL] two or more pg installations running as the same user

2008-11-25 Thread Mikko Partio
On Tue, Nov 25, 2008 at 12:37 PM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>wrote: > hey folks, > > I am thinking about testing enviroment here, and gotta setup temporary > instalation of postgres for that. More than one, because software operates > on few different connections, to different database

Re: [GENERAL] two or more pg installations running as the same user

2008-11-25 Thread Grzegorz Jaśkiewicz
On Tue, Nov 25, 2008 at 10:29 PM, Chris <[EMAIL PROTECTED]> wrote: > > If they are different versions of postgres (eg 8.2/8.3), make sure you > initdb with the right one :) > ok, I tried it and it works fine so far. basically, I need to setup test harness, that would involve using few physically s

Re: [GENERAL] two or more pg installations running as the same user

2008-11-25 Thread Chris
Grzegorz Jas'kiewicz wrote: hey folks, I am thinking about testing enviroment here, and gotta setup temporary instalation of postgres for that. More than one, because software operates on few different connections, to different databases. I know I can do it under same user, just by changing PG

Re: [GENERAL] two or more pg installations running as the same user

2008-11-25 Thread Rafael Martinez
Filip Rembiałkowski wrote: > > > 2008/11/25 Grzegorz Jaśkiewicz <[EMAIL PROTECTED] > > > > hey folks, > > I am thinking about testing enviroment here, and gotta setup > temporary instalation of postgres for that. More than one, because > software operat

Re: [GENERAL] two or more pg installations running as the same user

2008-11-25 Thread Filip Rembiałkowski
2008/11/25 Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> > hey folks, > > I am thinking about testing enviroment here, and gotta setup temporary > instalation of postgres for that. More than one, because software operates > on few different connections, to different databases. > I know I can do it under

[GENERAL] two or more pg installations running as the same user

2008-11-25 Thread Grzegorz Jaśkiewicz
hey folks, I am thinking about testing enviroment here, and gotta setup temporary instalation of postgres for that. More than one, because software operates on few different connections, to different databases. I know I can do it under same user, just by changing PGDATA/PGPORT before initdb gets t