> Now I want to use Postgres as frontend to connect to MS SQL server
> on a Windows machine . Is it possible ?
No. In your terms Postgres is a backend, not a frontend. What you've
installed with RedHat is a PostgreSQL server (backend). Of course
you can write, use frontends (there are some with the ditribution,
eg. psql) with PostgreSQL from the Linux box or from any Windows
machine, but only for accessing PostgreSQL backends. This list is
only for these issues.
The PostgreSQL backend uses its own backend protocol as the M$ SQL
Server does. They are absolutely incompatible. So use a backend for
M$ SQL on Windows. You needn't use any PostgreSQL related thing...
Please refer your SQL Server documentation, or visit
http://www.microsoft.com/Servers/
Regards,
Tibor Laszlo
ltibor@mail.tiszanet.hu