Обсуждение: Postgres 9.5 - password for new windows user

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.

you shouldn't have to run as admin, and the password its prompting for is the sql user password for postgres, this is stored in the database server, (no I have no idea how it sets it up as I rarely use postgres on windows).    The enterpriseDB installer should have setup a shortcut to 'SQL Shell (psql)' in the start menu, you might try this instead of manually running psql.

-- 
john r pierce, recycling bits in santa cruz

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

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

Ccing list
On 02/03/2016 11:27 AM, Weisenberg, Sofy Hefets wrote:
> Hi Adrian,
>
> I have already uninstalled and installed before, and every time I run setup, I am not prompted for a password.

And you are not prompted to create a database superuser?

Or more to the point what are the steps that you presented with?

I forgot to ask previously, what version of Windows are you using?

>
> If you have a link other than http://www.enterprisedb.com/products-services-training/pgdownload#windows
>
> for downloading the graphical installer. Please let me know. Thank you.

I do not know of any. I do not run Postgres on Windows(except as a test)
so I am somewhat out of my depth here.

My suggestion would be to ask about this on the EDB installer forum, I
would guess there are more folks with practical experience hanging out
there:

http://forums.enterprisedb.com/forums/show/9.page;jsessionid=DBB4E62E2D95AF1C1B0C489DCAA308EE

>
> Sofy
>
>
> ________________________________________



--
Adrian Klaver
adrian.klaver@aklaver.com