Lists: | pgsql-admin |
---|
From: | "Stefan Bayer" <stefan(dot)bayer(at)gmx(dot)net> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | WindowsXP setup user account problem |
Date: | 2005-06-16 09:41:00 |
Message-ID: | 20050616094058.D629E528A9@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
I want to create the postgresql service user unattended (in a batch
process). How can I do that? Especially I couldn't create the right to logon
as service.
What is the correct procedure to create a service user for postgresql and to
start the service in a batch (unattended) mode?
Thanks
Stefan Bayer
E-Mail: stefan(dot)bayer(at)gmx(dot)net
From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Stefan Bayer <stefan(dot)bayer(at)gmx(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: WindowsXP setup user account problem |
Date: | 2005-06-18 14:20:11 |
Message-ID: | 20050618142011.GC15547@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
On Thu, Jun 16, 2005 at 11:41:00 +0200,
Stefan Bayer <stefan(dot)bayer(at)gmx(dot)net> wrote:
> I want to create the postgresql service user unattended (in a batch
> process). How can I do that? Especially I couldn't create the right to logon
> as service.
>
> What is the correct procedure to create a service user for postgresql and to
> start the service in a batch (unattended) mode?
The preferred method is ident authentication if your OS supports it for
domain sockets and the batch job is running on the same server as
postgres. Otherwise you can put the password in the pgpass file.
See 27.12 of the 8.0 documentation.