Don't forget to CC: the list - that way everyone can help. asfar khan wrote:
My problem is that I have two postgress server on window platform. I would like to know how to communicate between them.
Ah - can't help you here. I don't run PG on Windows. Is there an option on the installer?
1-> What database entries I have to do in postgress folder. As in oracle, we give IP Address of machine in the tnsname.ora file. Here in which particular file I have to place the entry. 2-> Any specific .sql file, I have to run?
Well, on the various *nix systems there is a contrib/dblink folder in the source tarball with a Makefile, small C library and a dblink.sql file with a bunch of "create function" entries. Notes are in README.dblink and there are some examples too.
3-> Then how to create the dblink, if suppose I want to access the table of one server to another vice-versa?
There's a dblink_connect(...) function.
Please reply, as I need its urgently.
Check the installer as step 1. While that's happening you can always download the source tarball in the background - look in the contrib directory for all the documentation etc.
-- Richard Huxton Archonet Ltd
