#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2010
    Posts
    4
    Rep Power
    0

    Connection timeouts


    Hello

    I have been developing a Drupal web site which connects to postgres and on my development environment everything works fine.

    Now that i am deploying to our servers i am experimenting some connection timeouts from time to time, that result in setting my site offline for a few minutes.

    the error i get is the following one:

    The*pgsql*error was:*pg_connect() [<a href='function.pg-connect'>function.pg-connect</a>]: Unable to connect to PostgreSQL server: could not connect to server: Connection timed out Is the server running on host "sql1.gss3.com" and accepting TCP/IP connections on port 5432?.

    drupal is running on a Ubuntu 9.10 server with IP 95.80.206.30 and postgres at 95.80.206.50.

    when the site goes offline, i can still access postgres using pgAdminIII and Webmin also connects to the DB without problem...

    any idea of what might be causing this?
    Is there any special parameter(s) in the postgres config files that i should check/change?

    any help is welcome!

    thanks in advance!
    Julien
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2010
    Posts
    4
    Rep Power
    0
    problem solved, in case someone runs into something similar,
    this had nothing to do with postgres, it was a problem with our DNS, switching to the real IP instead of domain name in the connection did the trick.

    cheers

IMN logo majestic logo threadwatch logo seochat tools logo