Re: pgaccess error

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: paul simdars <psimdars(at)lisco(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: pgaccess error
Date: 2002-03-14 06:52:38
Message-ID: 3C9048B6.8010904@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Marc Blanc 2002-03-14 07:37:00 Re: TCP/IP database connection problem with pgaccess
Previous Message Nicolas Bazin 2002-03-14 06:16:41 Re: ecpg weird behavior