Cygwin? or paid version from SRA?

[David So]

Hi All



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



Any option for hot backup?



Thank you

[Bruce Momjian]

Re: Cygwin? or paid version from SRA?

David So wrote:[color=blue]
> Hi All
>
>
>
> For deploying PostgreSQL on Windoz platform, which one is a better
> option (performance, reliability) ? Thru Cygwin or Paid version from
> SRA?[/color]

I think SRA's version has better performance because it is a native
Windows version, rather than using Cygwin, and it does threading, rather
than CreateProcess() to start each database session.

Of course, I work for SRA.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Richard Huxton]

Re: Cygwin? or paid version from SRA?

On Wednesday 15 October 2003 05:34, David So wrote:[color=blue]
>
> For deploying PostgreSQL on Windoz platform, which one is a better
> option (performance, reliability) ? Thru Cygwin or Paid version from
> SRA?[/color]

I know one person who was quite happy with the windows version from
http://www.dbexperts.net/. He wanted a "spare" PG server but didn't have the
time/inclination to learn how to manage a Linux server.
[color=blue]
> Any option for hot backup?[/color]

The pg_dump utility guarantees a consistent snapshot of the database without
having to block updates - is that what you're after?
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Alvaro Herrera]

Re: Cygwin? or paid version from SRA?

On Wed, Oct 15, 2003 at 09:14:09AM -0400, Bruce Momjian wrote:
[color=blue]
> I think SRA's version has better performance because it is a native
> Windows version, rather than using Cygwin, and it does threading, rather
> than CreateProcess() to start each database session.[/color]

I asked SRA a month ago or so if they sold outside Japan, and was told
that "they were not ready yet". Are they getting ready?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La victoria es para quien se atreve a estar solo"

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[scott.marlowe]

Re: Cygwin? or paid version from SRA?

On Wed, 15 Oct 2003, David So wrote:
[color=blue]
> Hi All
>
>
>
> For deploying PostgreSQL on Windoz platform, which one is a better
> option (performance, reliability) ? Thru Cygwin or Paid version from
> SRA?[/color]

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.
[color=blue]
> Any option for hot backup?[/color]

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Bruce Momjian]

Re: Cygwin? or paid version from SRA?

Alvaro Herrera wrote:[color=blue]
> On Wed, Oct 15, 2003 at 09:14:09AM -0400, Bruce Momjian wrote:
>[color=green]
> > I think SRA's version has better performance because it is a native
> > Windows version, rather than using Cygwin, and it does threading, rather
> > than CreateProcess() to start each database session.[/color]
>
> I asked SRA a month ago or so if they sold outside Japan, and was told
> that "they were not ready yet". Are they getting ready?[/color]

No, I don't think so. The original poster had a .hk domain, so I assume
he is in Hong Kong, and they might sell there, but I am not 100% sure.

The big problem is that all the admin tools are only in Japanese, but I
am told they are working on that.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Jan Wieck]

Re: Cygwin? or paid version from SRA?

Richard Huxton wrote:[color=blue]
> On Wednesday 15 October 2003 05:34, David So wrote:[color=green]
>>
>> For deploying PostgreSQL on Windoz platform, which one is a better
>> option (performance, reliability) ? Thru Cygwin or Paid version from
>> SRA?[/color]
>
> I know one person who was quite happy with the windows version from
> http://www.dbexperts.net/. He wanted a "spare" PG server but didn't have the
> time/inclination to learn how to manage a Linux server.[/color]

Yeah, that dbexperts version. Copy their dbx.dll to a unix box and run
"strings -a dbx.dll" and you'll see that this is a modified cygwin.dll
without sourcecode. I would be very careful these days in advertising that.


Jan

--
#============== =============== =============== =============== ===========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#============== =============== =============== ====== JanWieck@Yahoo. com #


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html