Hi,
please help me...
I have downloaded Drupal and trying to install it on Hosting server, based on Linux, Apache etc...
When stating the installation, Drupal stops and says:
Failed to connect to your PostgreSQL database server. PostgreSQL reports the following message: Connection failed. See log file for failure reason.
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?
* Are you sure you typed the correct database name?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
PostgreSQL is running, name, password, server are correct...
Does anybody know, where could be the problem?
Many thanks.
Comments
Couple things...
1) Don't go live on that version of PG. It's ancient
Is postgres installed on the same box that you're webserver is on?
You'll probably need to play with the pg_hba.conf file in the postgres data directory. You'd need to add a line to allow your webserver to connect to the database:
host all all web.server.ip.addy/32 md5
After saving that file, reload the database
pg_ctl -D /path/to/data reload
Then, try connecting again.
You should also make sure that your username / password are correct when trying to connect to the database.
If you keep having trouble, check out the stackbuilder stuff (http://drupal.org/node/335484) You download and install postgres and can then have the PG installer automatically install drupal for you.
If you're looking for a quick way to install / upgrad Postgres, you can use: http://www.enterprisedb.com/products/pgdownload.do#linux
If you want PostgresPlus (a comprehensive installer with db and many tools): http://www.enterprisedb.com/products/postgres_plus/overview.do
Hello! I think you must
Hello! I think you must create the database in postgresql before the installation.