postgresql

[David A. Bandel]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, 14 Dec 2003 15:19:10 -0800
Ted Ozolins <ted1 at telus.net> wrote:

> To start with I had messed up my postgresql install but dumped and
> redid the instalation. I have it up and running (postgresql) since:
> 
> crash root # pg_ctl status -D /var/lib/postgresql/data
> pg_ctl: postmaster is running (pid: 1955)
> Command line was:
> /usr/bin/postmaster '-N' '1024' '-B' '2048'
> 
> I'm trying to use eestock, a web based inventory program.
> http://localhost/eestock, the eestock page
> comes up nicely but I get:
> 
> *Warning*: pg_connect(): Unable to connect to PostgreSQL server: could
> not connect to server: Connection refused Is the server running on
> host 127.0.0.1 and accepting TCP/IP connections on port 5432? . in
> */var/www/localhost/htdocs/eestock/admin/utils/DB_Sql.inc* on line
> *44* PHP Error: pg_connect() failed.
> 
> I have tried using tcpip_socket=true and port=5432 in the postgresql 
> config file to no avail. Any ideas what to try next are welcome.
> Anyone running eestock, what did you have to do to get it to connect
> to postgresql? This is on a gentoo-1.4 fresh install.

Lately pg_hba.conf comes with extremely restrictive configurations. 
Make sure _that_ file permits TCP/IP (and you've started postmaster w/
- -i and also make sure the user connecting (and the connection source)
are permitted.  Just read the comments in pg_hba.conf.

Ciao,

David A. Bandel
- -- 
Focus on the dream, not the competition.
		Nemesis Racing Team motto
GPG key autoresponder:  mailto:david_key at pananix.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/3QUTj31PLQNUbV4RAvE8AKCWG3Mi0laPBwynSt2RBpBwdftt4QCgwmbJ
hj+6mPkNVHvb8V37JSWdF0g=
=vfC2
-----END PGP SIGNATURE-----