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 is different from the one shown in the link. I went through all of the other steps, but it skipped the password step for some reason.
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@xxxxxxxxxxx>
Sent: Tuesday, February 2, 2016 5:41 PM
To: Weisenberg, Sofy Hefets; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
