Re: Several postgres installation on windows possible?

From: Paul Silveira <plabrh1(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Several postgres installation on windows possible?
Date: 2007-07-17 18:16:24
Message-ID: 11655068.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello,

What if you just rolled your own installer so that you would have control
over everything.

You could follow my blog (that was referenced earlier in this thread) to
some degree.

The first think that I would do is to get an install just the way you want
it on a DEV machine. Then I would package that install and deploy that
using .BAT files that would check to see if the NT User existed, registering
the service, and all of the other things that would need to be done.
Basically the second half of my blogged article.

Would that work?

Paul

Peter Elmers wrote:
>
> Hi!
>
> I am still working on this problem. With the installer of postgres,
> it is not possible for me to install a second postgresql(maybe i just
> try it in the wrong way?)!
> With the binary, there are some showstoppers for me (executing as
> postgres-user and adding a service with activated panda-VS and so on).
>
> Regards,
>
>
> Peter
>
> Am 13.07.2007 um 15:49 schrieb Umesh Shastry:
>
>> Hi Peter,
>>
>> Say you have installed PostgreSQL in C:/PostgresA directory... make
>> a copy of this folder as C:/PostgreSQLB... edit the conf file say
>> postgres.conf(this should be in /data directory) file of second
>> server in C:/PostgreSQLB & locate the port & change it to 5433...
>> then you can start both servers with
>>
>> C:\PostgresA>initdb -D /<path2PostgresADataDir>
>>
>> C:\PostgresB>initdb -D /<path2PostgresBDataDir>
>>
>> Pls note that I haven't checked this thing..if you want me to check
>> then gimme 1 day..I would check it & let you know..
>>
>> Thanks,
>> Umesh
>> ----- Original Message -----
>> From: Peter Elmers
>> To: Umesh Shastry
>> Cc: pgsql-admin(at)postgresql(dot)org
>> Sent: Friday, July 13, 2007 7:04 PM
>> Subject: Re: [ADMIN] Several postgres installation on windows
>> possible?
>>
>> Hi Umesh,
>>
>> Thanks for the fast reply, but how can i install the second,
>> third,.... postgres? As mentioned, the installer comes up with a
>> simple change dialogue.
>>
>>
>> Peter
>>
>> Am 13.07.2007 um 15:24 schrieb Umesh Shastry:
>>
>>> Hi Peter,
>>>
>>> I think it is possible you can run multiple servers on a single
>>> machine, provided on different port & data directory.
>>>
>>> Thanks,
>>> Umesh
>>> ----- Original Message -----
>>> From: Peter Elmers
>>> To: pgsql-admin(at)postgresql(dot)org
>>> Sent: Friday, July 13, 2007 6:52 PM
>>> Subject: [ADMIN] Several postgres installation on windows possible?
>>>
>>> Hi Guys,
>>>
>>> I like to deploy a application based on postgres and i am pretty
>>> unsure whether it is possible to have several postgres installation
>>> on windows running in parallel.
>>> The normal installer comes up with a "change dialogue" if i try to
>>> install a second time or postgres is already installed on the target
>>> machine and i run my setup with the postgres installer included.
>>>
>>> Thanks for reading and answering,
>>>
>>>
>>> Peter
>>>
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 3: Have you checked our extensive FAQ?
>>>
>>> http://www.postgresql.org/docs/faq
>>>
>>>
>>
>>
>
>
>

--
View this message in context: http://www.nabble.com/Several-postgres-installation-on-windows-possible--tf4074458.html#a11655068
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jessica Richard 2007-07-17 18:44:05 Can primary key be dropped and added back in?
Previous Message Umesh Shastry 2007-07-17 16:54:27 Re: plpgsql debugger