Re: postgresql with SuSE 8.0

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