Dear Alban.

You've solved my problem....

Thank you 1000x.

On Sun, 27 Sep 2009 11:36:09 +0200
Alban Hertroys <dal...@solfertje.student.utwente.nl> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to