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@gmail.com> wrote:
> On Fri, 21 Jan 2011 12:01:40 -0500, Mike Thomsen <mikerthomsen@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
