From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
---|---|
To: | Ricky Tompu Breaky <ricky(dot)breaky(at)uni(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How should the first step of PostgreSQL implementation should be? (revised) |
Date: | 2009-09-27 09:36:09 |
Message-ID: | 9E9047F1-2B1A-4A9C-9308-69980D259A1F@solfertje.student.utwente.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-09-27 12:16:21 | Re: How should the first step of PostgreSQL implementation should be? |
Previous Message | Ricky Tompu Breaky | 2009-09-27 08:44:28 | Re: How should the first step of PostgreSQL implementation should be? (revised) |