Results 1 to 5 of 5

Thread: PostgreSQL port

  1. #1
    Join Date
    Jul 2004

    Unanswered: PostgreSQL port

    I try to connect from windows to linux postgresql using pgOLEDB using this 'Provider=PostgreSQL OLE DB Provider;Location=posdbv2005;Data Source=;UserID=postgres;Password=dlink5 17',
    but this error prompt out " Could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "" and accepting TCP/IP connections on port 5432?"

    I understand that pgOLEDB ver could not listen to other port except 5432 as default for time being, i try to start the database in port 5432 and another error message prompt as this "
    LOG: could not create IPv6 socket: Address family not supported by protocol
    FATAL: Lock file "/usr/local/pgsql/data/" always exists
    HINT: Is another postmaster (PID 3248) running in data directory "/usr/local/pgsql/data"? "

    i need to connect to the database at port 5433 using pgOLEDB, can anyone help me?

    thank a lot

    chew see

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    Haven't tried it but you might try:
    'Provider=PostgreSQL OLE DB Provider;Location=posdbv2005;Data Source=,5433;UserID=postgres;Password=d link5 17'
    That's the syntax I've found that works for other providers.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jul 2004


    Thanks Mirtheil for reply, but when i try to use this syntax to connect, it comes out another error message as below
    "could not translate host name ",5433" to address: Unknown host."

    Do anyone have any idea to solve this? Please help ...

    Thanks in advance

    chew see
    Last edited by csong; 02-25-05 at 02:58.

  4. #4
    Join Date
    Jun 2004
    Arizona, USA
    Have you configured PostgreSQL to accept client connections?

    Look at "Client Authentication" in the PostgreSQL documentation (pp 297 in v8.0x documentation.) Essentially, you need to configure pg_hba.conf on the server to allow remote computers to communicate to the server.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

  5. #5
    Join Date
    Jul 2004
    Thanks for your guidance, but i did the configuration already. it was only configure the IP address not the port no.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts