On 27 Sep 2009, at 10:44, Ricky Tompu Breaky wrote:
RB>I forgot to show you that I've done these steps too: postgres=# ALTER ROLE ivia WITH LOGIN; ALTER ROLE postgres=# alter user ivia with password '<<my password>>'; ALTER ROLE postgres=# alter user ivia with login; ALTER ROLE postgres=# commit; WARNUNG: keine Transaktion offen COMMIT postgres=# \q sussy:~ # psql -h 127.0.0.1 -U ivia -W Password for user ivia: psql: FATAL: Datenbank »ivia« existiert nicht sussy:~ #
You didn't specify a database to connect to. By default psql tries to connect to a database named after the login user, in this case "ivia". You probably want to connect to the database named "postgres" that's created by default (at the initdb step).
Alban Hertroys -- Screwing up is the best way to attach something to the ceiling. !DSPAM:737,4abf320b11688043321471! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
