Re: pgaccess error - Mailing list pgsql-interfaces

From Constantin Teodorescu
Subject Re: pgaccess error
Date
Msg-id 3C9048B6.8010904@flex.ro
Whole thread Raw
In response to pgaccess error  (paul simdars <psimdars@lisco.com>)
List pgsql-interfaces
paul simdars wrote:
> I am trying to use pgaccess.  I have postgres installed and I created a
> database.  I start pgaccess and go to 'open' a database and get an 'Error
> trying to connect to database 'xyz' on host localhost'.  It also says,
> "Is the server runnint on host localhost and accepting TCP/IP connections
> on port 5432?".
> I know the apache server is running and I can open a web page that
> accesses the database I want to connect to.  Is that what they are asking
> about?  If so, then that isn't the problem.  Unless I have to create a
> new postgres user for pgaccess like I created a user 'apache' for the
> apache server to be able to access the database.
> Any help would be appreciated because it looks like it will be a good
> tool.

Try opening the database leaving host and port entry fields empty.

Otherwise, modify the /etc/rc.d/init.d/postgresql file adding -i option 
to the start section.

teo




pgsql-interfaces by date:

Previous
From: "Nicolas Bazin"
Date:
Subject: Re: ecpg weird behavior
Next
From: Marc Blanc
Date:
Subject: Re: TCP/IP database connection problem with pgaccess