Discussion:
switching from windows to linux
(too old to reply)
vidhya baskaran
2003-12-30 06:18:57 UTC
Permalink
Hi,

We are using postgres under Cygwin on a win2k server and we would like to move it to a Linux box.

You told to use PsqlODBC driver to establish a connection between a Linux based postgres server and a Windows application.

We have to install psqlODBC driver in win2k server is it right?
Do we have to change the pg_hba.conf file of linux server?
Do we need to install unixOBDC or any other ODBC in Linux box?

Regards,

Vidhya



Yahoo! India Mobile: Ringtones, Wallpapers, Picture Messages and more.Download now.
Uwe C. Schroeder
2003-12-30 06:37:34 UTC
Permalink
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Post by vidhya baskaran
Hi,
We are using postgres under Cygwin on a win2k server and we would like to
move it to a Linux box.
Good decision
Post by vidhya baskaran
You told to use PsqlODBC driver to establish a connection between a Linux
based postgres server and a Windows application.
We have to install psqlODBC driver in win2k server is it right?
yes
Post by vidhya baskaran
Do we have to change the pg_hba.conf file of linux server?
yes, you'd have to allow remote access to the linux machine. If you're not
concerned with security (i.e. you're behind a firewall) you could add a line

host all all 192.168.1.0 255.255.255.0 trust

The above line would trust all clients in your local network, assuming that
you use the 192.168.1.0/24 network. Check the comments in the pg_hba.conf
file for more secure solutions.
Post by vidhya baskaran
Do we need to install unixOBDC or any other ODBC in Linux box?
Not unless you want to use your application locally on that linux box.
Post by vidhya baskaran
Regards,
Vidhya
Yahoo! India Mobile: Ringtones, Wallpapers, Picture Messages and more.Download now.
- --
UC

- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/8R0ujqGXBvRToM4RAh+qAJ4sGhO7dgDfbu2n3jvlxTMwglJKagCguAzq
6k+QhtuMmfKyih5NVLgU6b8=
=+8md
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Loading...