pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
switching from windows to linux 2+ messages / 2 participants [nested] [flat]
* switching from windows to linux @ 2003-12-30 06:18 vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 0 siblings, 1 reply; 2+ messages in thread From: vidhya baskaran @ 2003-12-30 06:18 UTC (permalink / raw) To: pgsql-admin 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: switching from windows to linux @ 2003-12-30 06:37 Uwe C. Schroeder <uwe@oss4u.com> parent: vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 0 siblings, 0 replies; 2+ messages in thread From: Uwe C. Schroeder @ 2003-12-30 06:37 UTC (permalink / raw) To: vidhya baskaran <vidhyabhaskaran@yahoo.co.in>; pgsql-admin -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Monday 29 December 2003 10:18 pm, vidhya baskaran wrote: > Hi, > > We are using postgres under Cygwin on a win2k server and we would like to > move it to a Linux box. Good decision > > 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 > 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. > 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. > 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----- ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-12-30 06:37 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-12-30 06:18 switching from windows to linux vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 2003-12-30 06:37 ` Uwe C. Schroeder <uwe@oss4u.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox