[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 [EMAIL PROTECTED] With Regards, Vidhya
Re: [pgadmin-support] switching postgres from windows to linux
Vidhya - do you mean you are using IIS on Win 2000 with ASP and now want the same web server/scripts to connect to the Linux box? If so then you must have already conf'd everything in the ASP as it currently works and simply need to change the host you are connecting to. This should mean that you already have the pgODBC drivers installed. Is this right? Rgds, Jason On Tuesday 30 December 2003 14:51, vidhya wrote: > 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 [EMAIL PROTECTED] > > > With Regards, > > Vidhya ---(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
[pgadmin-support] RedHat 8.0 error "Gdk-WARNING.."
I have installed pgadmin 3 on a redhat 8 . when I try to run it I get the following error : ( after choosing my language) Gdk-WARNING **: gdkdrawable-x11.c:787 drawable is not a pixmap or window Segmentation fault and it doesn't run . I have installed : gtk2-2.0.6-8.i386 gtk-devel gtk-engines gdk-pixbuf-gnomef-0.18.0-4.i386 gdk-pixbuf-develf-0.18.0-4.i386 gdk-pixbuf-0.18.0-4.i386 What can be the problem ? Regards Yitzhak Zinner Datatex Textile Information Systems Phone : 03- 9234101 ext 214 E-Mail :[EMAIL PROTECTED] URL :Http://www.datatx-tim.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] Crash
Hi. When trying to see the properties of any table, pgAdmin crashes. I'm using the pgadmin3-20031228-Win32.zip snapshot on Win2k. Thanks for your time. ---(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
Re: [pgadmin-support] Crash
I am using the same snapshot. However, pgAdmin does not crash for me when requesting table properties. At 02:43 PM 12/30/2003 -0500, Rodrigo wrote: Hi. When trying to see the properties of any table, pgAdmin crashes. I'm using the pgadmin3-20031228-Win32.zip snapshot on Win2k. Thanks for your time. ---(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 --- Michael ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-support] PgAdmin 3 startup
Michael, *please* use the mailing list!!! Michael Shapiro wrote: The only clue that I might be able to offer you is that we have dropped and recreated the schemas in the database many many times without dropping and recreating the database. Might that cause this query to run slowly? Yes, that's why I mentioned VACUUMing. Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] PgAdmin 3 startup
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote: Michael, Michael Shapiro wrote: The only clue that I might be able to offer you is that we have dropped and recreated the schemas in the database many many times without dropping and recreating the database. Might that cause this query to run slowly? Yes, that's why I mentioned VACUUMing. Regards, Andreas However, vacuuming did not speed this up. So the question remains.. why so slow on the one database while al the others are fast. --- Michael ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
