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

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13

    Exclamation NETWORK ACCESS of PostgreSQL


    Hi

    I've created a PostgreSQL database on a Linux box. How can I access this db from a windows client ?? Should I telnet to the linux box and access the db ?

    or

    is there something like Net8/SQL*NET configuration found in oracle, for windows clients accessing the oracle db ??

    Please advise.

    Thanks & Regards.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13
    Thanks for the reply.

    However, my questions are not answered.

  6. #4
  7. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Well .. you can telnet, or you can install the ODBC driver and use pgAdmin:
    pgAdmin II uses the PostgreSQL ODBC Driver (psqlODBC) to communicate with a PostgreSQL server.
    I don't think you need a specific client install, like Oracle
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Posts
    55
    Rep Power
    13
    Hello all,

    I too would like to keep database scripts on the client and run them into the database remotely.

    I can access the db directly via putty/psql, but not from my pc.

    My problem is that the ODBC connection does not seem to work.
    I have installed both pgAdmin and WinSQL, and configured my ODBC connection. But on both of them I get "could not connect to the server, could not connect to remote socket".

    The ODBC driver is set to port 5432. This is the same port that I use to access the db from psql.

    Does anyone know what could be causing this problem?

    Merl

    p.s. From the little I've seen, pgAdmin isn't a script running tool, which is what I'm after. Does anyone know of a Win2K app for doing this?
  10. #6
  11. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    You also need to configure pg_hba to allow connections from the computer you are trying to connect from. Problematic if you aren't using a static IP.

    What do you mean by "script running tool"?
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Posts
    55
    Rep Power
    13
    We are using static IP's, and ph_hba.conf is set up to allow the entire IP range, i.e.
    host all 192.168.1.0 255.255.255.0 password

    But anyway, that problem is fixed now. It turned out that postgresql.conf needed TCP/IP sockets set to true (was set to false) :~)


    On to the secondary problem (and the same one ggnanaraj had).

    I would like to keep of my data/metadata scripts on my pc, and run them remotely into the database. I come from an oracle background and would use sqlplus or svrmgrl to accomplish this with Oracle. I know that I can use pgAdminII to run SQL statements, but I would like to do execute DML statements and create stored procedures etc.

    Is there a Win2K tool that allows one to do this for PostgreSQL?

    Thanks in advance.
  14. #8
  15. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Location
    Maine, USA
    Posts
    1
    Rep Power
    0
    It's not strictly a WIN2K solution, but I've had great luck with phpPGAdmin (available on SourceForge). It requires a web interface (meaning you need access to a web server to use it) that's set up with PHP. It's full-featured, and allows (even assists with) creating procedures and functions and views, and also has nice screens for creating DDL (creating tables and indexes). You use a web browser to connect. It's not perfect, but seems to get better with every release.

    If you're setting up your PostgreSQL server to dish out data via an internet/intranet connection you've probably got most of the infrastructure already.

IMN logo majestic logo threadwatch logo seochat tools logo