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

    Join Date
    Aug 2003
    Posts
    58
    Rep Power
    11

    Post Starting PostgreSQL


    I installed PostgreSQL 7.3.4 on red Hat Linux 8.0.

    I mounted clusters and started database server using initdb and pg_ctl tools. Everything looks fine, following message appears.

    postmaster successfully started.

    Whem I try to access database server using psql tool, following error occurs:
    could not connect to server: Connection refused.
    Is the server running on host xxx.xx.xx.xx and accepting TCP/IP connections on port 5432?

    I don't know what could be happening?

    I appreciate some help

    Best Regards
  2. #2
  3. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18
    What's the exact command you type at the prompt for psql?

    Also, just some prelims to check:
    1)Do a ps -aux | grep postgres to make sure postmaster is running

    2)Check your postgres.conf to see if you're enabling access through tcp. Port 5432 should be the default PG port so unless you've changed that you shouldn't need to mess with it.

    3)Check to make sure if you have a firewall setup that you're not blocking port 5432.

    HTH,
    -b
    PostgreSQL, it's what's for dinner...
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Poland
    Posts
    57
    Rep Power
    11
    or mayby try to connect to postgres trought unix socket (local).

IMN logo majestic logo threadwatch logo seochat tools logo