Thread: switching postgres from windows to linux
Hi,
We installed postgres 7.3.3 in windows 2000 server and using ASP applications.
But, due to overload postgres crashes very often.
So, we decided to switch the databases to Linux box.
We have to access the PG databases in windows from Linux.
Tell me how to the drivers required and how to establish connection between windows and linux.
Please tell me the steps involved to do this process. (very Urgent)
Kindly mail me to vidhyabhaskaran@yahoo.co.in
With Regards,
Vidhya
Yahoo! India Mobile: Ringtones, Wallpapers, Picture Messages and more. Download now.
Hi Vidhya,
if I can understand it clearly you are using postgres under Cygwin on a win2k server and you would like to move it to a Linux box.
To establish a connection between a Linux based postgres server and a Windows application you have to use the PsqlODBC driver. (http://gborg.postgresql.org/project/psqlodbc/projdisplay.php)
If you want to access your database from other machines you have to set up your pg_hba.conf file (see documentation for details).
There should not be any problems with PGAdmin3. PGAdmin3 doesn't use ODBC. It has it's own driver. Simply add your server and connect to that.
Regarding this process please send your questions to the pgsql-admin list.
Good Luck!
Bye,
-- Csaba Együd
-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]On Behalf Of vidhya baskaran
Sent: 2003. december 30. 4:58
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] switching postgres from windows to linuxHi,We installed postgres 7.3.3 in windows 2000 server and using ASP applications.But, due to overload postgres crashes very often.So, we decided to switch the databases to Linux box.We have to access the PG databases in windows from Linux.Tell me how to the drivers required and how to establish connection between windows and linux.Please tell me the steps involved to do this process. (very Urgent)Kindly mail me to vidhyabhaskaran@yahoo.co.inWith Regards,VidhyaYahoo! India Mobile: Ringtones, Wallpapers, Picture Messages and more. Download now.
-- Incoming mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.209 / Virus Database: 261 - Release Date: 2003. 12. 26.