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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
