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