Re: Postgres 9.5 - password for new windows user

On 02/03/2016 05:47 AM, Weisenberg, Sofy Hefets wrote:
> Thanks for the response!
>
> Yes, I am sure that I was not prompted during setup to enter a password. Perhaps the graphical installer that I have
isdifferent from the one shown in the link. I went through all of the other steps, but it skipped the password step for
somereason. 

I just downloaded the 9.5 Win x86-32 version from the link you show
below. When I do an install it prompts for a database superuser
password. Unfortunately I do not have an x86-64 Windows machine
available to test if the install is the same. I suspect it is, otherwise
this list would be seeing more on this topic.

Are you deep into setting up Postgres on your machine?

If not I would suggest uninstalling the installation you have now and
trying again.

>
> If you know of a different graphical installer to use, please let me know.
>
> Thanks!
>
> Sofy H. Weisenberg
>
>
> ________________________________________
> From: Adrian Klaver <adrian.klaver@aklaver.com>
> Sent: Tuesday, February 2, 2016 5:41 PM
> To: Weisenberg, Sofy Hefets; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Postgres 9.5 - password for new windows user
>
> On 02/02/2016 07:14 AM, Weisenberg, Sofy Hefets wrote:
>> 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.
>
> Are you sure?:
>
> http://www.enterprisedb.com/docs/en/9.3/pginstguide/PostgreSQL_Installation_Guide-07.htm#TopOfPage
>
> Figure 3.4
>
>>
>> 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
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>


--
Adrian Klaver
adrian.klaver@aklaver.com