From: | Mike Thomsen <mikerthomsen(at)gmail(dot)com> |
---|---|
To: | "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: "Database does not exist"... but it does exist |
Date: | 2011-01-21 17:38:58 |
Message-ID: | AANLkTikVU3kdo-JLc1HYtM_3zPKNDixzcGbkfLd9A0EK@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I don't know what had happened to our test machine, but after I
dropped all of the other test databases and reran those commands in
the psql console, the user account can log in fine.
Strange.
On Fri, Jan 21, 2011 at 12:13 PM, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> On Fri, 21 Jan 2011 12:01:40 -0500, Mike Thomsen <mikerthomsen(at)gmail(dot)com>
> wrote:
>
> ...
>> psql -U postgres -c "create user miket with password 'miket'"
>> createdb testingdb -U postgres
>> psql -U postgres -d testingdb -c "create schema testingdb authorization
>> miket" psql -U postgres -d testingdb -c "grant all privileges on database
>> testingdb to miket"
>
> I guess that if you used the 1st line you weren't 'postgres' user, so the 2nd
> line can't give anything unless issued the way the 1st is.
>
> --
> My way of joking is to tell the truth. That's the funniest joke in the world.
> -- Muhammad Ali
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Campbell | 2011-01-21 18:39:56 | Passing a variable from the user interface to PostgreSQL |
Previous Message | Jean-Yves F. Barbier | 2011-01-21 17:13:38 | Re: "Database does not exist"... but it does exist |