pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
switching postgres from windows to linux 3+ messages / 2 participants [nested] [flat]
* switching postgres from windows to linux @ 2003-12-30 03:58 vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 2003-12-30 05:49 ` Re: switching postgres from windows to linux Együd Csaba <csegyud@vnet.hu> 0 siblings, 1 reply; 3+ messages in thread From: vidhya baskaran @ 2003-12-30 03:58 UTC (permalink / raw) To: pgadmin-support@postgresql.org 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: switching postgres from windows to linux 2003-12-30 03:58 switching postgres from windows to linux vidhya baskaran <vidhyabhaskaran@yahoo.co.in> @ 2003-12-30 05:49 ` Együd Csaba <csegyud@vnet.hu> 2003-12-30 06:10 ` Re: [pgadmin-support] switching postgres from windows to linux vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 0 siblings, 1 reply; 3+ messages in thread From: Együd Csaba @ 2003-12-30 05:49 UTC (permalink / raw) To: vidhya baskaran <vidhyabhaskaran@yahoo.co.in>; +Cc: Pgadmin-Support (E-mail) <pgadmin-support@postgresql.org> 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [pgadmin-support] switching postgres from windows to linux 2003-12-30 03:58 switching postgres from windows to linux vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 2003-12-30 05:49 ` Re: switching postgres from windows to linux Együd Csaba <csegyud@vnet.hu> @ 2003-12-30 06:10 ` vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 0 siblings, 0 replies; 3+ messages in thread From: vidhya baskaran @ 2003-12-30 06:10 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] 3+ messages in thread
end of thread, other threads:[~2003-12-30 06:10 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-12-30 03:58 switching postgres from windows to linux vidhya baskaran <vidhyabhaskaran@yahoo.co.in> 2003-12-30 05:49 ` Együd Csaba <csegyud@vnet.hu> 2003-12-30 06:10 ` vidhya baskaran <vidhyabhaskaran@yahoo.co.in>
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