Re: Cygwin? or paid version from SRA?

On Wed, 15 Oct 2003, David So wrote:

> Hi All
>
>
>
> For deploying PostgreSQL on Windoz platform, which one is a better
> option (performance, reliability) ? Thru Cygwin or Paid version from
> SRA?

If you need performance either get a copy of BSD or Linux and run it on
that, or get the native version (there are a few different native flavors
floating around, not all cost money, not all are supported anymore, you
can find them in this mailing list's archive by searching for native
windows or something similar.

If you just need it to get started, and you'll move your database over to
heavier iron later, then you can likely use the cygwin version fine.  It's
not the fastest, but it works fairly well, it's free, it's used a lot so
there's plenty of folks to ask about it.

> Any option for hot backup?

Postgresql, in all flavors, has had hot backup as far back as I can
remember, via pg_dump / pg_dumpall.