Postgres 9.5 - password for new windows user

From: "Weisenberg, Sofy Hefets" <sweisenb(at)vols(dot)utk(dot)edu>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Postgres 9.5 - password for new windows user
Date: 2016-02-02 15:14:57
Message-ID: SN1PR0201MB1933E212B375F0C6431935F6F0DF0@SN1PR0201MB1933.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am brand new to Postgres 9.5 and have just installed it on my Windows OS, using the Win x86-64 installer, downloaded from:
http://www.enterprisedb.com/products-services-training/pgdownload#windows

I am trying to setup a new database from the Windows command prompt (run as admin) and I am being prompted for a password after entering the command "psql -U postgres" from the directory containing psql.exe.

At no point during installation was I asked to create a password, so from reading http://pgsnake.blogspot.com/2010/07/postgresql-passwords-and-installers.html , I understand that what I need is a service password. I have tried, unsuccessfully, to find such a password. The file pgpass.conf (C:\Users\<Username>\AppData\Roaming\postgresql\pgpass.conf ) is blank, and manually entering something produces no results when I try to type it into the command prompt.

Any ideas on how I can find/set this password?

Thank you,
Sofy H. Weisenberg
Graduate Research Assistant
Institute of Biomedical Engineering
University of Tennessee, Knoxville

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yu Nie 2016-02-02 15:16:57 Re: strange sql behavior
Previous Message Yu Nie 2016-02-02 15:00:41 Re: strange sql behavior