Обсуждение: 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! =-----
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
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