From: | "Rob" <rob(at)jamwarehouse(dot)com> |
---|---|
To: | "Kevin Waterson" <kevin(at)oceania(dot)net>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Moving from MySQL |
Date: | 2003-01-13 12:46:44 |
Message-ID: | IFEGJGMKBFBOAODJNALHKEEICCAA.rob@jamwarehouse.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)jamwarehouse(dot)com
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**************************
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Kevin Waterson
Sent: Monday, January 13, 2003 2:51 PM
To: pgsql-novice(at)postgresql(dot)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(at)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Waterson | 2003-01-13 12:51:18 | Moving from MySQL |
Previous Message | Lex Berezhny | 2003-01-13 00:52:29 | Re: Reference to multiple cols |