Postgres Pro
Downloads
Home   >   mailing lists

Re: switching postgres from windows to linux - Mailing list pgadmin-support

From Együd Csaba
Subject Re: switching postgres from windows to linux
Date
Msg-id 002901c3ce98$b978fa10$230a0a0a@compaq
Whole thread Raw
In response to switching postgres from windows to linux  (vidhya baskaran <vidhyabhaskaran@yahoo.co.in>)
List pgadmin-support
Tree view
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 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.
-- 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.

pgadmin-support by date:

Previous
From: vidhya baskaran
Date:
Subject: switching postgres from windows to linux
Next
From: "vidhya"
Date:
Subject: switching postgres from windows to linux