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
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 |