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.

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:

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