Thread: Windows version of PostgreSQL 8.x?
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
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.
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."
> 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
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.
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 > > >
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