I would recommend going and downloading the source of Postgres. In their
build instructions they have a nice step by step process for how to get
Postgres up and running. It includes how to set up the database and add
users. Unfortunately, I don't have my Postgres system up and running at the
moment so I can't be of much more help than that. If you're still having
problems next week, let me know and I'll see if I can help you some more.
David
-----Original Message-----
From: Theo Brinkman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 3:19 PM
To: David Joham
Subject: Re: [expert] need help with pgaccess in 8.0
Hmm, I'm not quite having the luck you describe. I've made the change
below, but I still get the same error message for creating the database
through pgaccess, but pgaccess just kind of hangs when I try to open one
now. What username/password combination should I be putting in? Or is
that not causing my problem?
- Theo
David Joham wrote:
> <<
> I'm having some difficulties with pgaccess in mandrake 8.0. It loads up
> fine, but I can't actually do anything with it. If I try to create a
> database, I get the following error message:
> "Tcl error executing pg_exec create database <dbName>
>
> is not a valid postgresql connection"
>
> If I try to open a database I created in psql, I get the following error
> message:
> "Error trying to connect to database '<dbName>' on host localhost
>
> PostgreSQL error message:Connection to database failed
> PQconnectPoll() -- connect() failed: Connection Refused
> Is the postmaster running (with -i) at 'localhost' and accepting
> connections on TCP/IP port '5432'?"
>
>
> What do I need to do to be able to use pgaccess? Looking through the
> '/etc/rc.d/init.d/postgres' script, I don't see the -i or the port set
> anywhere. Am I looking in the right place?
>
>
> Theo,
>
> You're in the right place, but you have to do some "magic" to get it to
work
> at this point. It astounds me that Mandrake doesn't do this for us (or
> provide a nice GUI for doing it ourselves), but you actually have to add
the
> -i option to the postres script. Unfortunately, its not that easy.
>
> Madrake calls pg_ctl to actually start postgres. It passes
> /usr/bin/postmaster as an arguement. One of the options to pass to pg_ctl
> are the options to pass to /usr/bin/postmaster (lost yet?). That option is
> -o. In that option is where you want to pass the -i.
>
> Since I've confused myself, here's my line from /etc/rc.d/init.d/postgres
> (line 83)
>
> su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o
'-i'
> start >/dev/null 2>&1"
>
> yips!
>
> At that point, I was able to go in and create databases and view them from
> pgaccess. It sounds like you've got that step down already.
>
> Good luck
>
> David
