EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Avoiding the postgres user account  XML

Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Author Message
Laszlo_Szilagyi

Member

Joined: 19 Nov 2009 06:24:02
Messages: 10
Offline

Hello,

Our apps many times are used on notebooks as a desktop application, synchronized periodically with servers. Installing en extra account is disturbing for the user, running the engine under an administrator account is all fine. Is there a way to avoid the creation of the postgres user account and use the current account instead?

Sachin_S

Senior member

Joined: 1 Aug 2008 02:37:24
Messages: 445
Offline

Hello,

Use, --serviceaccount CLI option while installing, here you can give existing users also.
However, using an user with administrative privileges is strongly not-recommended.

--
Regards,
Sachin Srivastava
EnterpriseDB , the Enterprise Postgres company.
Laszlo_Szilagyi

Member

Joined: 19 Nov 2009 06:24:02
Messages: 10
Offline

Thank You!
Tim_Stone

New member

Joined: 25 Feb 2010 04:40:51
Messages: 2
Offline

Hi, can you please give me advice on how to run the postgres service using a local system account? I can't run this product by creating a new user and there will be multiple users using the same computer.

What is the command --serviceaccount CLI designed to do? in my tests all it does is create a user called CLI and try to run the service using that users account.
Sachin_S

Senior member

Joined: 1 Aug 2008 02:37:24
Messages: 445
Offline

Hello,

CLI option stands for Command Line options. So what i actually meant by it is:
--serviceaccount <what ever username you want to give here>, e.g.

--serviceaccount abc, will create a user 'abc' if not present or use the same if present..

To make the service run under 'Local System' account, go to the Service Control Manager and change the log-on properties of the service.

Hope it helps..

--
Regards,
Sachin Srivastava
EnterpriseDB , the Enterprise Postgres company.
Tim_Stone

New member

Joined: 25 Feb 2010 04:40:51
Messages: 2
Offline

Thanks for the reply, I was really hoping for a command line option that would enable me to run the service as Local system, I don't want to do this manually this needs to be deployed to many sites. Is that possible? surely there must be a method to deploy Postgres without an account being created?
scottiebo

Senior member
[Avatar]

Joined: 23 Oct 2005 21:05:02
Messages: 197
Offline


surely there must be a method to deploy Postgres without an account being created?


Due to the architecture of postgres, there is not a way to do this from the installer. You could however script the action. Using something like sc.exe (http://support.microsoft.com/kb/251192)


--Scottie
 
Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Go to:   
Powered by JForum 2.1.8 © JForum Team