Re: postgresql with SuSE 8.0 - Mailing list pgsql-novice

postgresql knows where to find its data directory from the environment
variable PGDATA.

From your symptoms, I think its OK.

The check I referred to ...

check its set:

echo $PGDATA

Check its OK:

ls -al $PGDATA.

shell will resolve the variable and then 'ls' will list the contents of the
directory, if set.

No such file or directory

will result if its incorrect.

Ben.

On Sunday 26 January 2003 23:36, Art Fore wrote:
> (verify $PGDATA is accurate)! What is $PGDATA and how do you verify it?
>
> Art
>
> On Sun, 2003-01-26 at 15:16, Ben Prescott wrote:
> > Seems most likely it isn't running.
> >
> > OK ... my checklist (documented 'cos I knew I'd forget it!!)
> >
> > # ensure /var/lib/pgsql/data is mounted
> > # switch user
> > su - postgres
> > # (verify $PGDATA is accurate)
> > # not sure what this does :o(
> > initdb
> > # start postgresql; eg:
> > pg_ctl -l /full/path/for/logile start
> > # or via the script in /etc/init.d
> >
> > if postegresql isn't running, you'll need to load it into the startup
> > environment. Yast2 has a runlevel editor. Its under 'system' - fire it
> > up, and edit the current level. Find the pgsql, select it, and then tick
> > the '3' and '5' boxes. This will start it whether or not your system
> > boots with X running.
> >
> > hth, Ben.
> >
> > On Sunday 26 January 2003 22:56, Art Fore wrote:
> > > 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
> > >
> > > ---------------------------(end of
> > > broadcast)--------------------------- TIP 6: Have you searched our list
> > > archives?
> > >
> > > http://archives.postgresql.org
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly