Re: [GENERAL] Windows version of PostgreSQL 8?
Hello Bjørn, we are running a handfull of PostgreSQL installations on Windows Server 2000 and 2003 for web-mapping applications and they are running well for the last 8 months. Bjørn T Johansen wrote: How stable is the windows version of pgsql 8? Is it as stable as the Linux version or should I look elsewehere after a good sql srv for Windows? Regards. BTJ Regards Frank -- Frank Rittinger TERRAPLAN Geographische Informationssysteme Gewerbestr. 33 79227 Schallstadt Germany Tel.: 07664-505315 Fax.: 07664-505321 http://www.terraplan.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Windows version of PostgreSQL 8?
It seems like the conclusion should be that PGSQL 8 works very well under Windows but maybe for Windows NT something else should be used; it seems like too much hazzle to get it to work BTJ Frank Rittinger wrote: Hello Bjørn, we are running a handfull of PostgreSQL installations on Windows Server 2000 and 2003 for web-mapping applications and they are running well for the last 8 months. Bjørn T Johansen wrote: How stable is the windows version of pgsql 8? Is it as stable as the Linux version or should I look elsewehere after a good sql srv for Windows? Regards. BTJ RegardsFrank ---(end of broadcast)--- TIP 6: explain analyze is your friend
Fw: Re: [GENERAL] Windows version of PostgreSQL 8?
pgsql-general, 您好！ postgreSQL version is Redhat 9.0 + postgresql 8.0.3 下面是转发邮件 原邮件发件人名字: Bj�rn_T_Johansen [EMAIL PROTECTED] 原邮件收件人名字：Frank Rittinger [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] It seems like the conclusion should be that PGSQL 8 works very well under Windows but maybe for Windows NT something else should be used; it seems like too much hazzle to get it to work BTJ Frank Rittinger wrote: Hello Bj�rn, we are running a handfull of PostgreSQL installations on Windows Server 2000 and 2003 for web-mapping applications and they are running well for the last 8 months. Bj�rn T Johansen wrote: How stable is the windows version of pgsql 8? Is it as stable as the Linux version or should I look elsewehere after a good sql srv for Windows? Regards. BTJ RegardsFrank ---(end of broadcast)--- TIP 6: explain analyze is your friend = = = = = = = = = = = = = = = = = = = = 致 礼！ Nee.mem(倪明) [EMAIL PROTECTED] 2005-07-13 ---(end of broadcast)--- TIP 1: 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: [GENERAL] Windows version of PostgreSQL 8.x?
On Tue, 2005-07-12 at 11:29, Bjørn T Johansen wrote: How stable is the Windows version of PGSQL 8? Is it as stable as the Linux version or should I be looking for something else? For certain values of stable, yes, it is. However, if for no other reason than the fact the the port is fairly new, I wouldn't run it in production myself just yet. If you have no choice but to run Windows where you are, then I'd say PostgreSQL is about as stable as most other databases running on Windows. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Windows version of PostgreSQL 8.x?
On Tue, 2005-07-12 at 18:29 +0200, Bjørn T Johansen wrote: Is it as stable as the Linux version From http://www.postgresql.org/docs/whatsnew: Although tested throughout our release cycle, the Windows port does not have the benefit of years of use in production environments that PostgreSQL has on Unix platforms and therefore should be treated with the same level of caution as you would a new product. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Windows version of PostgreSQL 8.x?
On Tue, 2005-07-12 at 11:29, Bjørn T Johansen wrote: How stable is the Windows version of PGSQL 8? Is it as stable as the Linux version or should I be looking for something else? For certain values of stable, yes, it is. However, if for no other reason than the fact the the port is fairly new, I wouldn't run it in production myself just yet. If you have no choice but to run Windows where you are, then I'd say PostgreSQL is about as stable as most other databases running on Windows. Well, I have an uncle that is still using Windows NT and I don't think that I can persuade him to change to Linux, sadly... I am writing him a small app, that need a reliable database that can handle some data and is fast... BTW, is PGSQL 8 supported on Windows NT 4? BTJ ---(end of broadcast)--- TIP 1: 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: [GENERAL] Windows version of PostgreSQL 8.x?
On Tue, 2005-07-12 at 12:15, Bjørn T Johansen wrote: On Tue, 2005-07-12 at 11:29, Bjørn T Johansen wrote: How stable is the Windows version of PGSQL 8? Is it as stable as the Linux version or should I be looking for something else? For certain values of stable, yes, it is. However, if for no other reason than the fact the the port is fairly new, I wouldn't run it in production myself just yet. If you have no choice but to run Windows where you are, then I'd say PostgreSQL is about as stable as most other databases running on Windows. Well, I have an uncle that is still using Windows NT and I don't think that I can persuade him to change to Linux, sadly... I am writing him a small app, that need a reliable database that can handle some data and is fast... BTW, is PGSQL 8 supported on Windows NT 4? I believe it is. I know it works on win2k and above. For what you're talking about doing postgresql should be fine. It's the 250,000 transaction a day monster servers i wouldn't try to put on postgresql on windows. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Windows version of PostgreSQL 8.x?
It's very stable, I have been using it for a Apache DSO application since the first beta (July/Aug 2004) and It just runs and runs and runs. The app is not super busy, but I have never had a issue with the database. I replaced a old MS SQL server 7 install with Postgresql win32 and never looked back :-) Tony Caduto http://www.amsoftwaredesign.com home of PG Lightning Admin for Postgresql 8.x Bjørn T Johansen wrote: How stable is the Windows version of PGSQL 8? Is it as stable as the Linux version or should I be looking for something else? Regards, BTJ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 1: 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: [GENERAL] Windows version of PostgreSQL 8?
Bjørn T Johansen wrote: How stable is the windows version of pgsql 8? Is it as stable as the Linux version or should I look elsewehere after a good sql srv for Windows? This is a tough question to answer and you will probably get a wide range or responses. Many people on these lists believe that PostgreSQL on Windows will never good enough because Windows itself is not good enough. That said, from the noises I have heard the Windows port works well. It's still the 1st release so only time will truly tell just how solid it is, but we haven't heard of to many problems. What are you looking todo? I might not be willing to run a bank on the windows port, but I would surely run a simple web app. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Windows version of PostgreSQL 8.x?
On Jul 12, 2005, at 1:15 PM, Bjørn T Johansen wrote: BTW, is PGSQL 8 supported on Windows NT 4? It may work, but is not supported: 1.2) I heard that NT4 is supported. Is that true? Although not officially supported, PostgreSQL will run on Windows NT4 with a few minor issues including: The installer will not work correctly, thus you will need to compile and install the code manually. PostgreSQL uses a feature in the NTFS filesystem called 'reparse points' to implement tablespaces. Reparse points are not available in NT4, hence tablespaces cannot be used. There is no 'runas.exe' included in Windows NT4 as standard, making it difficult to start PostgreSQL from an administrative account. It should also be noted that very little testing has been done on NT4. from http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
