database connection problem

[Jeff K. <jt...@ad...>]

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.

Database 
Host:localhost				Port:5432  
Database Administrator: postgres	Password: (blank)  
Connect to: mypgdb
(choose 'create database' results in:)
Error! connectDBStart() -- connect() failed: Connection refused 


Likewise, I have a sql-ledger user with the following profile:
Driver: Pg		Host: localhost  
Name: mypgdb	Port: 5432  
User: postgres	Password: (blank) 
(Logging in as this user results in:)
Error! Database is offline; please try again later

Looking at the 'Granted Priveledges" thru webmin, I see no tables having
any explicitly granted priviledges. Isn't the 'postgres' user implicitly
granted permission?

Can anyone help me figure this out? I have to deploy this sql-ledger
test ASAP. Thanks.