Hi Sean take a look at port specification in postgresql.conf $PGDATA/postgresql.conf port =
Anyone else? Martin ----- Original Message ----- Wrom: JVTLBXFGGM To: Scott Marlowe Cc: pgsql-general@postgresql.org Sent: Thursday, December 20, 2007 3:00 PM Subject: Re: [GENERAL] Deploy postgres - upgrade strategy 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 ? ----- Original Message ---- Wrom: EPYOQKEDOTWFAOBUZXUWLSZLKBRNVWWCUFPEGAU 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 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: > > 3. If there is an older version of the same version line (e.g., 8.2.3) > installed, is it safe for me to upgrade it by running upgrade.bat, believing > that it won't break existing application using the old version? Under no circumstances should you simply do it. You should ask the user if it's ok to do it. If I had a machine running a specific version because that's what I'd tested and was deployed in other places, and it got updated by some other app being installed I would not be happy. > 4. If there is a newer version installed (e.g. 8.3), can I still install > 8.2.4 as a separate installation without touching the existing installation? That may be your best bet if you're looking to use postgresql and your app together as a kind of "bolted together" application. I'd say that you should ask the user up front if they have another postgresql server (it might not be on the same machine you're installing your app on, btw) they want to use, or if they'd like you to install a postgresql instance just for your application on the local machine. Then make all decisions based on that one question. ------------------------------------------------------------------------------ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
