Обсуждение: Multiple postgresql serices on same windows machine..
Can I install multiple postgresql 8.2.4 services on same Windows 2003 Server ?
My scenario
Application A which is already existing in the system is using postgres database ( It used port 5432 and Windows account postgres is used as the service account )
Application B too uses postgresql database.( It uses a windows account say “ServiceAccount” for starting postgresql service and uses another port say 54321)
The service account postgres’s password is not known to application B and service account ServiceAccount’s password is not known to application B.
How can we install both application on same machine?
AnooP
Visit our Website at www.rmesi.co.in
This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the information for the intended purpose only. Internet communications are not secure; therefore, RMESI does not accept legal responsibility for the contents of this message. Any views or opinions presented are those of the author only and not of RMESI. If this email has come to you in error, please delete it, along with any attachments. Please note that RMESI may intercept incoming and outgoing email communications.
Freedom of Information Act 2000
This email and any attachments may contain confidential information belonging to RMESI. Where the email and any attachments do contain information of a confidential nature, including without limitation information relating to trade secrets, special terms or prices these shall be deemed for the purpose of the Freedom of Information Act 2000 as information provided in confidence by RMESI and the disclosure of which would be prejudicial to RMESI's commercial interests.
This email has been scanned for viruses by Trend ScanMail.
- vishal
Subject: [ADMIN] Multiple postgresql serices on same windows machine..
Date: Fri, 8 Feb 2008 10:20:34 +0530
From: aspillai@in.rm.com
To: pgsql-admin@postgresql.org
Can I install multiple postgresql 8.2.4 services on same Windows 2003 Server ?
My scenario
Application A which is already existing in the system is using postgres database ( It used port 5432 and Windows account postgres is used as the service account )
Application B too uses postgresql database.( It uses a windows account say “ServiceAccount” for starting postgresql service and uses another port say 54321)
The service account postgres’s password is not known to application B and service account ServiceAccount’s password is not known to application B.
How can we install both application on same machine?
AnooP
This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the information for the intended purpose only. Internet communications are not secure; therefore, RMESI does not accept legal responsibility for the contents of this message. Any views or opinions presented are those of the author only and not of RMESI. If this email has come to you in error, please delete it, along with any attachments. Please note that RMESI may intercept incoming and outgoing email communications.
Freedom of Information Act 2000
This email and any attachments may contain confidential information belonging to RMESI. Where the email and any attachments do contain information of a confidential nature, including without limitation information relating to trade secrets, special terms or prices these shall be deemed for the purpose of the Freedom of Information Act 2000 as information provided in confidence by RMESI and the disclosure of which would be prejudicial to RMESI's commercial interests.
This email has been scanned for viruses by Trend ScanMail.
Post free auto ads on Yello Classifieds now! Try it now!
On Feb 7, 2008 11:27 PM, Vishal Arora <aroravishal22@hotmail.com> wrote: > You can have more than one instance of PostgreSQL server running on the same > Windows machine as long as you have different DataDir for each of them. you > can have initdb process indicating different datadir. And you need each instance (or cluster, as it's usually called in postgresql lingo) to listen on a different port. Be careful when doing this because multiple clusters don't play nice with resources like shared memory. Anoo, with the usage scenario you suggested, couldn't you just create some roles in the database cluster, and create new databases? For example, you could, - Create the database "app_a_db" and the role "app_a" (with a properly encrypted password) for Application A. Application A connects to the server as user "app_a" and does its work in "app_a_db". - Create the database "app_b_db" and the role "app_b" (with a properly encrypted password) for Application B. Application A connects to the server as user "app_b" and does its work in "app_b_db". app_a doesn't know the password of app_b, and vice-versa, and neither knows the Windows system passwords for postgres or ServiceAccount. Since they're working in different databases, they won't interfere with each other's data. And, you only have to maintain one cluster/server instead of two. If it turns out that this doesn't meet your needs, then a separate cluster is the way to go. I'm just giving you another option. Hope this helps. Peter