Re: Moving from MySQL

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 ...

---
Rob

**************************
Rob Cherry
mailto:rob@jamwarehouse.com
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**************************


-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Kevin Waterson
Sent: Monday, January 13, 2003 2:51 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Moving from MySQL


Hi all, new to pgsql yadda yadda

I have a default RedHat install and run into the following problem
When trying to connect to postgres I get the following message..
[kevin@anthem kevin]$ postgres
postgres does not know where to find the database system data.  You must
specify the directory that contains the database system either by specifying
the -D invocation option or by setting the PGDATA environment variable.

ok, so I su to the user postgres and try...

bash-2.05b$ postgres -D /var/lib/pgsql/data/
Lock file "/var/lib/pgsql/data//postmaster.pid" already exists.
Is another postmaster (pid 16943) running in "/var/lib/pgsql/data/"?

What seems to be the problem here?

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly