Re: postgresql with SuSE 8.0

System is SuSE 8.0 with Postgresql 7.2

When I try to start postgresql with the runlevel editor or rcpostresql
start I get FATAL 1: File /var/lib/pgsql/data/PG_VERSION is missing.
This is not a valid data directory.

If I try postmaster -D /var/lib/pgsql/data >logfile 2>&1 &, I get Exit
1.

If I run psql template1, I get psql: could not connect to server: No
such file or directory. Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Would help if I could find what the errors mean.

What is PG_VERSION that is missing? Where does it come from?

What is Unix domain socket? I am trying to run localhost.

>From the SuSE installation, What is the first thing to do? the second?
etc.

What config files do I have to edit and where are they?

As you can see I am lost. Documentation leads me in circles. It would
also help if it was searchable.

Art

On Sun, 2003-01-26 at 11:26, Ben Prescott wrote:
> I'm running suse 8.1, but it can't be that different.
>
> As I recall, the directory is set up for read/write access only by use
> 'postgres' - you'll need to 'su' to that first. I tried opening it up, and I
> think the database then refused to run.
>
> I ran it all from that user. I didn't get very far ... notably because the
> machine insisted on freezing given some time alone running postgresql, but I
> did get a table built and a perl script inserting a few thousand rows of data.
>
> If that doesn't help, can you post some listings for the directory
> properties. I think you'll find the database in /var/lib/pgsql/data.
>
> Apoligies for being vague, all the machines with postgresql installed on are
> powered down right now!
>
> regards, Ben.
>
> On Sunday 26 January 2003 17:28, Art Fore wrote:
> > I have postgresql 7.2 installed from the SuSE 8.0 CDROM. Have gone
> > through the documentation on setting up the database, but when I try to
> > access either the directory or the database as a user, I get permission
> > denied.
> >
> > Since the documentation does not match reality as I guess SuSE
> > bastardized the installation, If there is anyone one the list who has it
> > installed and working, could you maybe give me a clue as to how to get
> > this to operating?
> >
> > Art
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html