Bug 2486

Summary:	Postgres SQL does not appear to be working.
Product:	[Retired] Red Hat Linux	Reporter:	jhall
Component:	postgresql	Assignee:	Jay Turner <jturner>
Status:	CLOSED WORKSFORME	QA Contact:
Severity:	medium	Docs Contact:
Priority:	medium
Version:	6.0	CC:	jhall, srevivo
Target Milestone:	---
Target Release:	---
Hardware:	i386
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	1999-05-03 17:32:47 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description jhall 1999-05-02 23:44:30 UTC

Starting postgresql service: /usr/bin/postmaster does not
find the database system.  Expected to find it in the PGDATA
directory "/var/lib/pgsql", but unable to open file with
pathname "/var/lib/pgsql/base/template1/pg_class".

No data directory -- can't proceed.
postmaster []

---------------------------------------------

[root@xanax] (pts/2) # ls /var/lib/pgsql
[root@xanax] (pts/2) #

Comment 1 Jeff Johnson 1999-05-03 17:32:59 UTC

You need to create a database before starting postmaster:
    su postgres
    /usr/bin/initdb --pgdata=/var/lib/pgsql --pglib=/usr/lib/pgsql