Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-20 Thread Sean Z.
@postgresql.org Sent: Wednesday, December 19, 2007 1:04:19 PM Subject: Re: [GENERAL] Deploy postgres - upgrade strategy On Dec 19, 2007 11:12 AM, Sean Z. [EMAIL PROTECTED] wrote: Hi, I need your kind advice on postgres deployment strategy. My application is developed on 8.2.4 and need

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-20 Thread Sean Z.
19, 2007 3:24:09 PM Subject: Re: [GENERAL] Deploy postgres - upgrade strategy On Dec 19, 2007 1:55 PM, Sean Z. [EMAIL PROTECTED] wrote: Yes, bolted together application is something I am thinking about. It will satisfied my application's requirement and it won't affect existing applications

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-20 Thread Dave Page
Sean Z. wrote: BTW, what's the best way to determine the installation folder, port number used by an existing postgres server? From registry HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations ? Yes. From a related doc I once wrote: When PostgreSQL is installed on Windows it adds a number of

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-20 Thread mgainty
To: Sean Z. [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, December 19, 2007 1:04:19 PM Subject: Re: [GENERAL] Deploy postgres - upgrade strategy On Dec 19, 2007 11:12 AM, Sean Z. [EMAIL PROTECTED] wrote: Hi, I need your kind advice on postgres deployment

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-20 Thread Harald Armin Massa
HKLM\Software\PostgreSQL\Services\Service ID\Service Account Where: [...] Service account is the Windows user account that the pg_ctl service runs under, eg. MYPC\postgres I guess that would be service account that was assigned to the postgres service during installation, and that that

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-20 Thread Dave Page
Harald Armin Massa wrote: HKLM\Software\PostgreSQL\Services\Service ID\Service Account Where: [...] Service account is the Windows user account that the pg_ctl service runs under, eg. MYPC\postgres I guess that would be service account that was assigned to the

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-20 Thread Scott Marlowe
On Dec 20, 2007 2:04 PM, Sean Z. [EMAIL PROTECTED] wrote: Sorry I am not familiar with hyperic. Do you mean I can use hyperic to do the job, or do you mean I can take the same approach as hyperic? I mean you can take the same approach as them. ---(end of

[GENERAL] Deploy postgres - upgrade strategy

2007-12-19 Thread Sean Z.
Hi, I need your kind advice on postgres deployment strategy. My application is developed on 8.2.4 and need to be deployed to Windows server 2003. Clients may /may not have postgres installed. How can I deploy postgres silently on client machine? Specifically: 1. How to determine if

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-19 Thread Magnus Hagander
Sean Z. wrote: Hi, I need your kind advice on postgres deployment strategy. My application is developed on 8.2.4 and need to be deployed to Windows server 2003. Clients may /may not have postgres installed. How can I deploy postgres silently on client machine? Specifically: 1. How to

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-19 Thread Scott Marlowe
On Dec 19, 2007 11:12 AM, Sean Z. [EMAIL PROTECTED] wrote: Hi, I need your kind advice on postgres deployment strategy. My application is developed on 8.2.4 and need to be deployed to Windows server 2003. Clients may /may not have postgres installed. How can I deploy postgres silently on

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-19 Thread Sean Z.
on the same windows box? - Original Message From: Scott Marlowe [EMAIL PROTECTED] To: Sean Z. [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, December 19, 2007 1:04:19 PM Subject: Re: [GENERAL] Deploy postgres - upgrade strategy On Dec 19, 2007 11:12 AM, Sean Z. [EMAIL

Re: [GENERAL] Deploy postgres - upgrade strategy

2007-12-19 Thread Scott Marlowe
On Dec 19, 2007 1:55 PM, Sean Z. [EMAIL PROTECTED] wrote: Yes, bolted together application is something I am thinking about. It will satisfied my application's requirement and it won't affect existing applications. So is it possible to install my postgres server (say 8.2.4) regardless of