From: | Ricky Tompu Breaky <ricky(dot)breaky(at)uni(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How should the first step of PostgreSQL implementation should be? (revised) |
Date: | 2009-09-28 04:51:40 |
Message-ID: | 20090928115140.772d42de@uni.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Alban.
You've solved my problem....
Thank you 1000x.
On Sun, 27 Sep 2009 11:36:09 +0200
Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)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!
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ricky Tompu Breaky | 2009-09-28 04:55:51 | Re: Newbie's question: How can I connect to my postgresql-server? |
Previous Message | Tom Lane | 2009-09-28 02:24:58 | Re: problem with array query |