postgresql

[Net Llama!]

On 12/14/03 15:19, Ted Ozolins 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.

You might want to look in pg_hba.conf to ensure that postgresql is 
listening on the IP address(es) that you want it to.  If you make any 
changes, you'll need to restart postgresql.


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                       	       netllama at linux-sxs.org
Linux Step-by-step & TyGeMo: 		    http://netllama.ipfox.com

   3:40pm  up 7 days, 20:29,  1 user,  load average: 0.28, 0.23, 0.11