August 9th, 2002, 02:20 AM
NETWORK ACCESS of PostgreSQL
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 ?
is there something like Net8/SQL*NET configuration found in oracle, for windows clients accessing the oracle db ??
Thanks & Regards.
August 9th, 2002, 03:27 AM
August 9th, 2002, 03:47 AM
Thanks for the reply.
However, my questions are not answered.
August 9th, 2002, 03:54 AM
Well .. you can telnet, or you can install the ODBC driver and use pgAdmin:
I don't think you need a specific client install, like Oracle
September 17th, 2002, 04:45 PM
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?
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?
September 17th, 2002, 06:12 PM
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"?
September 18th, 2002, 05:01 PM
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.
September 24th, 2002, 07:23 PM
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.