Results 1 to 6 of 6

Thread: connect to a PostgreSQL Database on another Machine

  1. #1
    Join Date
    Jan 2006
    Posts
    273
    Thanks
    42
    Thanked 1 Time in 1 Post
    Qt products
    Qt3 Qt4
    Platforms
    Windows

    Default connect to a PostgreSQL Database on another Machine

    OS: WINXP PRO
    QT: 4.1.3
    COMPILER: MINGW
    PostgreSQL 8.1

    Hello everybody,
    I have a small program who are able to connect with a PostgreSQL Database on my machine (localhost) perfect.
    I have installed this application on another win xp machine and tried to connect to the PostgreSQL Database that are installed on another machine "PCPS391".
    If i try to connect me, i get following error message (Please open the picture).
    Have somebody make the same experience or can somebody see the problem?

    The PostgreSQL Service has started on the server.
    Attached Files Attached Files
    Think DigitalGasoline

  2. #2
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    33,359
    Thanks
    3
    Thanked 5,015 Times in 4,792 Posts
    Qt products
    Qt3 Qt4 Qt5 Qt/Embedded
    Platforms
    Unix/X11 Windows Android Maemo/MeeGo
    Wiki edits
    10

    Default Re: connect to a PostgreSQL Database on another Machine

    Maybe you have a firewall running there or the server is configured not to have remote access to it.

    Next time please attach a jpeg or png image instead of attaching a zip file with a bmp inside. It's much more convenient this way for others to see your pic.

  3. The following user says thank you to wysota for this useful post:

    raphaelf (28th August 2006)

  4. #3
    Join Date
    Jan 2006
    Posts
    273
    Thanks
    42
    Thanked 1 Time in 1 Post
    Qt products
    Qt3 Qt4
    Platforms
    Windows

    Default Re: connect to a PostgreSQL Database on another Machine

    Hi Wysota,
    On the server is no firewall installed and no winxp sp2 installed. I have checked the remote access permission and is enabled for remote access..
    Ok, i will not attach zip files for a picture

    Have you another idea?Or have you experience with client server connections with postgre?
    Think DigitalGasoline

  5. #4
    Join Date
    Jan 2006
    Posts
    273
    Thanks
    42
    Thanked 1 Time in 1 Post
    Qt products
    Qt3 Qt4
    Platforms
    Windows

    Default Re: connect to a PostgreSQL Database on another Machine

    Hi Wysota,
    I found the problem.. I had to konfigure on the PostgreSQL Server that my client are allowed to connect to my database. I had to insert there the ip address of my client.
    Thanks for inpiration
    Think DigitalGasoline

  6. #5
    Join Date
    Jan 2006
    Posts
    75
    Thanks
    3
    Thanked 5 Times in 4 Posts
    Qt products
    Qt3 Qt4 Qt/Embedded
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: connect to a PostgreSQL Database on another Machine

    Please modify your hba.conf to allow access from remote IP.

  7. The following user says thank you to ball for this useful post:

    raphaelf (28th August 2006)

  8. #6
    Join Date
    Jan 2006
    Posts
    273
    Thanks
    42
    Thanked 1 Time in 1 Post
    Qt products
    Qt3 Qt4
    Platforms
    Windows

    Default Re: connect to a PostgreSQL Database on another Machine

    Hi ball,
    yes i do that and it works

    thanks
    Think DigitalGasoline

Similar Threads

  1. Filling combobox from database
    By Philip_Anselmo in forum Qt Programming
    Replies: 3
    Last Post: 11th May 2006, 17:53
  2. My application can't connect to database when deploy it???
    By gtthang in forum Installation and Deployment
    Replies: 1
    Last Post: 15th February 2006, 11:01

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.