LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 03-29-2001, 08:35 AM   #1
Pain in the..........
LQ Newbie
 
Registered: Mar 2001
Location: Norwich
Posts: 2

Rep: Reputation: 0
Angry


Heeeeeeeeeeeeeeeeeeelp!!!!

When startng my Linux server Postgresql fails to start. Says something about the Postmaster not finding data directory.

When I login as postgres and type,

postmaster status

I get this message,

/usr/bin/postmaster does not know where to find the database system data. You m
ust specify the directory that contains the database system either by specifying
the -D invocation option or by setting the PGDATA environment variable.

No data directory -- can't proceed.

Any ideas?
 
Old 11-09-2001, 01:01 PM   #2
Bert
Senior Member
 
Registered: Jul 2001
Location: 406292E 290755N
Distribution: GNU/Linux Slackware 8.1, Redhat 8.0, LFS 4.0
Posts: 1,004

Rep: Reputation: 46
Gaaaah! I get the same errors..

Yes, it's a pain in the butt.

The main problem sees to be that in order to access the data files you need to be root and in order to run postmaster and postgresql you can't be root!!!

If you su to postgres you get the error than postmaster is already running (even though it's not!)

I'm lost.

It's doesn't seem to make sense in the documentation from the postgresql site either. Judging by the number of people having these setup problems (just on this site), some clarification is badly needed.
 
Old 11-09-2001, 01:32 PM   #3
entm
Member
 
Registered: Oct 2001
Location: Atlanta, GA
Distribution: Red Hat 7.0
Posts: 45

Rep: Reputation: 15
I run RedHat 7.0 and I have had no problems doing su postgres and working with the database. You might want to check and make sure that you have initialized a database.

Try psql -l

It will list all of the tables in the database. It sounds like you may need to create a few tables to get started.

Also, there is a new book out called PostgresSQL. I picked it up about 3 weeks ago and it has explained a lot. The book assumes no prior knowlede of SQL or databases. It might be boring for someone with years of experience, but for someone like me who is just starting it is perfect.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
PostgreSql sijomon_nd Fedora 1 09-27-2005 09:27 PM
PostgreSQL 7.3.2 redhatrosh Programming 6 06-01-2005 08:15 PM
need help in postgresql yawhum80 Linux - Newbie 0 10-28-2003 10:03 AM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM
postgreSQL dsgdevil Linux - Software 3 02-20-2003 10:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 04:12 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration