Moving from MySQL

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

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Waterson 2003-01-13 13:36:00 Re: Moving from MySQL
Previous Message Rob 2003-01-13 12:46:44 Re: Moving from MySQL