Re: database connection problem

[Dieter S. <dsi...@sq...>]

You have to add the -i switch when you start postmaster.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

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.
> 
> 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.
> 
> 
>