Re: Moving from MySQL

Kevin Waterson wrote:
> This one time, at band camp,
> "Rob" <rob(at)jamwarehouse(dot)com> wrote:
>
>> For a quick solution run "netstat -tlnp" and see if postgres is
>> running. If it is, kill it. Otherwise just delete the loc file. I
>> can't make any guarentees on how safe this is though ...
>
> Worked a treat, thanks
>
> now, if I do
> #createuser kevin
> from the command line it seems ok..
> but when I try
> [kevin(at)anthem file_db]$ psql kevin
> psql: FATAL 1: Database "kevin" does not exist in the system catalog.
>
> How do I create the database from kevin
>
Assuming you are now the postgres user:
createdb kevin
you can invoke user kevin with any db as well
psql -U kevin -d template1
Note: If you want kevin to have all rights to the database kevin you'll have
to make him the owner some how (eg create Kevin with createdb rights, create
the database as Kevin, then remove the rights in psql (as postgres) alter
user kevin nocreatedb).
hth,
- Stuart

DISCLAIMER:The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.