Re: postgresql with SuSE 8.0

(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