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