Re: database connection problem

[Thomas G. <to...@ad...>]

On Sat, 18 Aug 2001, Jeff Kowalczyk wrote:

> I need some assistance getting SQL-Ledger 1.6 to run on RH7.1 with
> PostgreSQL 7.1.x. I have database connection problems. I'm wondering if
> I need to do some sort of "GRANT ALL" on the postgres user or something.
> 
> I've installed DBD::Pg and tested it successfully. There is a pgsqltest
> database as a result, in fact. I have (for the moment) postgres open
> with a blank password and listening with 'no authentication required',
> although I don't yet know how to tell the postgres-specific distinction
> between 'local connection' and localhost connection. How do I tell if
> postgres is listening on 5434? I easily can access postgres via webmin,
> for example.

Hi.  Have a look in /tmp 

# ls -al /tmp

See if you have a lock file (looks like .s.PGSQL.5432)
If not:
as root run:

/etc/rc.d/init.d/postgresql start

Good luck!

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------