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
