Postgresql windows user account

PostgreSQL provides a bevy of authentication methods to allow you to pick the one that makes the most sense for your environment.

I've put together this guide to help you take advantage of this setup in your own environment. The first step in setting up a Windows Active Directory is to create a regular user account. The password can be anything but shouldn't expire and it needs to be unique in the environment.

In this instance, we'll use pg1postgres. Once the user account exists, we have to create a mapping between that user account and the service principal and create a keytab file. These steps can be combined using the Windows ktpass command, like so:. This should create a pg1. Lastly, in the Windows system, go into the User account, under Properties for the pg1postgres user, on the 'Account' tab, be sure to check the box that says "This account supports Kerberos AES bit encryption.

On both the client and servers, the krb5-user package should be installed. In an Active Directory environment, that's likely all that will be required since the rest of the information is available in DNS.

In postgresql. The documentation for createuser indicates that a -U switch is accepted: -U username --username username User name to connect as not the user name to create.

Greg Hewgill Greg Hewgill k gold badges silver badges bronze badges. This worked for me --username Shweta; Now to create a database create database db;. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta.

New post summary designs on greatest hits now, everywhere else eventually. Linked Related Hot Network Questions. I initially installed it out of the box and it had "Network Service" as the account running the Postgres service.

After creating the new GSMA and configuring it the way we thought it should work, it is now giving us the following messages in the Event Viewer when trying to start the service under this new account:. I'm hoping I don't need to totally reinstall postgres, because we've already built out a lot of different databases in the existing instance.

I think you will need to add the new GSMA account with the same permissions as were assigned for the "Network Service" account.