Dear Alban. You've solved my problem.... Thank you 1000x. On Sun, 27 Sep 2009 11:36:09 +0200 Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > 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
