Re: Moving from MySQL

From: Kevin Waterson <kevin(at)oceania(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Moving from MySQL
Date: 2003-01-13 13:36:00
Message-ID: 20030114003600.5922c74e.kevin@oceania.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Henshall, Stuart - Design & Print 2003-01-13 14:10:48 Re: Moving from MySQL
Previous Message Kevin Waterson 2003-01-13 12:51:18 Moving from MySQL