Re: postgresql with SuSE 8.0

Finally got Postgresql to running with postmaster. Done a createuser
afore, and createdb shadb. Now I cannot connect with Rekall It comes up
with could not connect to server: Connection refused. Is server running
on host sporthorse-home /TCP/IP connections on port 5432?
Also tried localhost with no success.

Could someone tell me where to look next?

Art


On Sun, 2003-01-26 at 16:31, Ben Prescott wrote:
> 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@xxxxxxxxxxxxxx so that your
> > message can get through to the mailing list cleanly
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster