Re: Moving from MySQL - Mailing list pgsql-novice

From Kevin Waterson
Subject Re: Moving from MySQL
Date
Msg-id 20030114003600.5922c74e.kevin@oceania.net
Whole thread Raw
In response to Re: Moving from MySQL  ("Rob" <rob@jamwarehouse.com>)
Responses Re: Moving from MySQL  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
This one time, at band camp,
"Rob" <rob@jamwarehouse.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@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

In MySQL I would do something like
mysqladmin create <dbname> -u root -p

Kind regards
Kevin

--
Please avoid sending me Word or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html
Kevin Waterson
Port Macquarie, Australia

pgsql-novice by date:

Previous
From: "Rob"
Date:
Subject: Re: Moving from MySQL
Next
From: "Henshall, Stuart - Design & Print"
Date:
Subject: Re: Moving from MySQL