Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgaccess error

pgaccess error

From
paul simdars
Date:
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.
Thank you.
Paul


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

Re: pgaccess error

From
"PG Explorer"
Date:
Have a look at my FAQ's it might be of help

http://www.pgexplorer.com/faqs.php

http://www.pgexplorer.com
Gui Tool for Postgres


----- Original Message ----- 
From: "paul simdars" <psimdars@lisco.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Thursday, March 07, 2002 7:14 PM
Subject: [INTERFACES] pgaccess error


> 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.
> Thank you.
> Paul
> 
> 
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: pgaccess error

From
Constantin Teodorescu
Date:
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