On 2/2/2016 7:14 AM, Weisenberg, Sofy Hefets wrote:
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
