By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,663 Members | 1,375 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,663 IT Pros & Developers. It's quick & easy.

windows distribution

P: n/a
Is there windows distribution of PostgreSQL? I recieve contradictory
information :-) Some people say there is, some there isn't. So, is
there? I've been browsing www.postresql.org
(http://www.postgresql.org/mirrors-ftp.html), but I don't seem to find a
windows binary distribution... If there is one, where can I download it?

--
Pozdrav/Regards, Nikola [Nick] Skoric.
"...Usne, tice-rugalice - a u oku tajac
Da sam kaput sa dva lica, da sam Gospo'n Propalica..."
http://newusers.cjb.net/ - site o Usenetu na hrvatskom!
Nov 12 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a

--- Nikola Skoric <ni*******@net4u.hr> wrote:
Is there windows distribution of PostgreSQL? I
recieve contradictory
information :-) Some people say there is, some there
isn't. So, is
there? I've been browsing www.postresql.org
(http://www.postgresql.org/mirrors-ftp.html), but I
don't seem to find a
windows binary distribution... If there is one,
where can I download it?

There is no native Windows version of PostgreSQL, yet.
Plenty of people use Cygwin emulation to run
PostgreSQL on Windows. Reports are that it runs well
enough, but doesn't scale too well. There also exists
a beta (proof of concept?) port of PostgreSQL 7.2 by
PeerDirect. This is reported to work pretty well, but
is not supported by the PostgreSQL development group.
You can read more about these options at
http://techdocs.postgresql.org .

A native Windows port is being actively developed at
present. No-one knows when it will be completed, but
we hope it will be ready for the next release, maybe
another four to six months.
--
Pozdrav/Regards, Nikola [Nick] Skoric.
"...Usne, tice-rugalice - a u oku tajac
Da sam kaput sa dva lica, da sam Gospo'n
Propalica..."
http://newusers.cjb.net/ - site o Usenetu na
hrvatskom!

---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose
an index scan if your
joining column's datatypes do not match

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #2

P: n/a
On Fri, 19 Dec 2003 12:11:51 -0800 (PST), Jeff Eckermann
<je************@yahoo.com> wrote:

--- Nikola Skoric <ni*******@net4u.hr> wrote:
Is there windows distribution of PostgreSQL? I
recieve contradictory
information :-) Some people say there is, some there
isn't. So, is
there? I've been browsing www.postresql.org
(http://www.postgresql.org/mirrors-ftp.html), but I
don't seem to find a
windows binary distribution... If there is one,
where can I download it?


There is no native Windows version of PostgreSQL, yet.
Plenty of people use Cygwin emulation to run
PostgreSQL on Windows. Reports are that it runs well
enough, but doesn't scale too well. There also exists
a beta (proof of concept?) port of PostgreSQL 7.2 by
PeerDirect. This is reported to work pretty well, but
is not supported by the PostgreSQL development group.
You can read more about these options at
http://techdocs.postgresql.org .

A native Windows port is being actively developed at
present. No-one knows when it will be completed, but
we hope it will be ready for the next release, maybe
another four to six months.
--
Pozdrav/Regards, Nikola [Nick] Skoric.
"...Usne, tice-rugalice - a u oku tajac
Da sam kaput sa dva lica, da sam Gospo'n
Propalica..."
http://newusers.cjb.net/ - site o Usenetu na
hrvatskom!

---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose
an index scan if your
joining column's datatypes do not match

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match


This question appears to have been posted to the lists pretty much every
other day lately. Perhaps this information needs to be more prominently
displayed on the front page of the site: perhaps a box containing logos
for all major platforms linking either directly to the Downloads page or
to more information on using PostgreSQL on that platform. I reckon that
would do the trick.

--

Russell Brown

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

Nov 12 '05 #3

P: n/a
A good indicator of the demand that there is for a native Win32 port. I
know it's already in the works, but I think that the upswing in
popularity of PG will be huge once the port is complete.

Whether you love or loath Windows, it's hard to ignore the potential
market share for a project like PG. IMHO it's one of the keys to the
success of MySQL, but I won't dredge up that ol' chestnut.

Cheers

T.

'Opinions Are Like Navels, Everybody Has One!'
Russ Brown wrote:
On Fri, 19 Dec 2003 12:11:51 -0800 (PST), Jeff Eckermann
<je************@yahoo.com> wrote:

--- Nikola Skoric <ni*******@net4u.hr> wrote:
Is there windows distribution of PostgreSQL? I
recieve contradictory
information :-) Some people say there is, some there
isn't. So, is
there? I've been browsing www.postresql.org
(http://www.postgresql.org/mirrors-ftp.html), but I
don't seem to find a
windows binary distribution... If there is one,
where can I download it?


There is no native Windows version of PostgreSQL, yet.
Plenty of people use Cygwin emulation to run
PostgreSQL on Windows. Reports are that it runs well
enough, but doesn't scale too well. There also exists
a beta (proof of concept?) port of PostgreSQL 7.2 by
PeerDirect. This is reported to work pretty well, but
is not supported by the PostgreSQL development group.
You can read more about these options at
http://techdocs.postgresql.org .

A native Windows port is being actively developed at
present. No-one knows when it will be completed, but
we hope it will be ready for the next release, maybe
another four to six months.
--
Pozdrav/Regards, Nikola [Nick] Skoric.
"...Usne, tice-rugalice - a u oku tajac
Da sam kaput sa dva lica, da sam Gospo'n
Propalica..."
http://newusers.cjb.net/ - site o Usenetu na
hrvatskom!

---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose
an index scan if your
joining column's datatypes do not match


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match

This question appears to have been posted to the lists pretty much
every other day lately. Perhaps this information needs to be more
prominently displayed on the front page of the site: perhaps a box
containing logos for all major platforms linking either directly to
the Downloads page or to more information on using PostgreSQL on that
platform. I reckon that would do the trick.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #4

P: n/a
Quoting "Tony (Unihost)" <to**@unihost.net>:
A good indicator of the demand that there is for a native Win32 port. I
know it's already in the works, but I think that the upswing in
popularity of PG will be huge once the port is complete.

Whether you love or loath Windows, it's hard to ignore the potential
market share for a project like PG. IMHO it's one of the keys to the
success of MySQL, but I won't dredge up that ol' chestnut.

Cheers

T.

'Opinions Are Like Navels, Everybody Has One!'
Russ Brown wrote:
On Fri, 19 Dec 2003 12:11:51 -0800 (PST), Jeff Eckermann
<je************@yahoo.com> wrote:

--- Nikola Skoric <ni*******@net4u.hr> wrote:

Is there windows distribution of PostgreSQL? I
recieve contradictory
information :-) Some people say there is, some there
isn't. So, is
there? I've been browsing www.postresql.org
(http://www.postgresql.org/mirrors-ftp.html), but I
don't seem to find a
windows binary distribution... If there is one,
where can I download it?
There is no native Windows version of PostgreSQL, yet.
Plenty of people use Cygwin emulation to run
PostgreSQL on Windows. Reports are that it runs well
enough, but doesn't scale too well. There also exists
a beta (proof of concept?) port of PostgreSQL 7.2 by
PeerDirect. This is reported to work pretty well, but
is not supported by the PostgreSQL development group.
You can read more about these options at
http://techdocs.postgresql.org .

A native Windows port is being actively developed at
present. No-one knows when it will be completed, but
we hope it will be ready for the next release, maybe
another four to six months.

--
Pozdrav/Regards, Nikola [Nick] Skoric.
"...Usne, tice-rugalice - a u oku tajac
Da sam kaput sa dva lica, da sam Gospo'n
Propalica..."
http://newusers.cjb.net/ - site o Usenetu na
hrvatskom!

---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose
an index scan if your
joining column's datatypes do not match

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match

This question appears to have been posted to the lists pretty much
every other day lately. Perhaps this information needs to be more
prominently displayed on the front page of the site: perhaps a box
containing logos for all major platforms linking either directly to
the Downloads page or to more information on using PostgreSQL on that
platform. I reckon that would do the trick.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)


I'm not familiar with the cygwin environment but is there something about that
is turning off users to using it to run PG?

It seems to me we should be seeing *more* ports about how PG is performing on
cygwin instead of questions about a native port- especially from new users.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

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

Nov 12 '05 #5

P: n/a
On Monday 22 December 2003 08:16 am, Keith C. Perry wrote:
I'm not familiar with the cygwin environment but is there something about
that is turning off users to using it to run PG?

It seems to me we should be seeing *more* ports about how PG is performing
on cygwin instead of questions about a native port- especially from new
users.


The problem is not so much Cygwin as the platform it runs on. It is Unix
emulation on Windows and therefore is only as stable as the version of
Windows you are using. I have run Postgres using Cygwin on various Win9x
versions. The Cygwin installer makes the process easy to do. The problem is
that it doesn't take much to load down the system. Also, given the frequency
with which Win9X versions crash you spend alot of time waiting for the
database to come up again. All in all it was more productive to move Postgres
to a dedicated Linux server.
--
Adrian Klaver
ak*****@comcast.net

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #6

P: n/a
On Monday 22 December 2003 08:16 am, Keith C. Perry wrote:
I'm not familiar with the cygwin environment but is there something about
that is turning off users to using it to run PG?

It seems to me we should be seeing *more* ports about how PG is performing
on cygwin instead of questions about a native port- especially from new
users.


The problem is not so much Cygwin as the platform it runs on. It is Unix
emulation on Windows and therefore is only as stable as the version of
Windows you are using. I have run Postgres using Cygwin on various Win9x
versions. The Cygwin installer makes the process easy to do. The problem is
that it doesn't take much to load down the system. Also, given the frequency
with which Win9X versions crash you spend alot of time waiting for the
database to come up again. All in all it was more productive to move Postgres
to a dedicated Linux server.
--
Adrian Klaver
ak*****@comcast.net

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #7

P: n/a
On Mon, 22 Dec 2003, Adrian Klaver wrote:
On Monday 22 December 2003 08:16 am, Keith C. Perry wrote:
I'm not familiar with the cygwin environment but is there something about
that is turning off users to using it to run PG?

It seems to me we should be seeing *more* ports about how PG is performing
on cygwin instead of questions about a native port- especially from new
users.


The problem is not so much Cygwin as the platform it runs on. It is Unix
emulation on Windows and therefore is only as stable as the version of
Windows you are using. I have run Postgres using Cygwin on various Win9x
versions. The Cygwin installer makes the process easy to do. The problem is
that it doesn't take much to load down the system. Also, given the frequency
with which Win9X versions crash you spend alot of time waiting for the
database to come up again. All in all it was more productive to move Postgres
to a dedicated Linux server.


But please note that if one had a reliable winxp/2k class box that would
probably be much more reliable. But it would still be much slower than
linux on the same hardware.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #8

P: n/a
Quoting "scott.marlowe" <sc***********@ihs.com>:
On Mon, 22 Dec 2003, Adrian Klaver wrote:
On Monday 22 December 2003 08:16 am, Keith C. Perry wrote:
I'm not familiar with the cygwin environment but is there something about that is turning off users to using it to run PG?

It seems to me we should be seeing *more* ports about how PG is performing on cygwin instead of questions about a native port- especially from new
users.


The problem is not so much Cygwin as the platform it runs on. It is Unix
emulation on Windows and therefore is only as stable as the version of
Windows you are using. I have run Postgres using Cygwin on various Win9x
versions. The Cygwin installer makes the process easy to do. The problem is

that it doesn't take much to load down the system. Also, given the

frequency
with which Win9X versions crash you spend alot of time waiting for the
database to come up again. All in all it was more productive to move

Postgres
to a dedicated Linux server.


But please note that if one had a reliable winxp/2k class box that would
probably be much more reliable. But it would still be much slower than
linux on the same hardware.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Personally, I think the only real reason to port PG to windows **is** for
marketing/advocacy reason. I don't use windows for anything major in my
company- just the accounting box *grin* (actually, that IS pretty major so I
guess I'm a liar *laff*).

The thing I was trying to get at (since as someone pointed out this question
about a windows port comes up about 3 times a month) is whether people are using
cygwin to run and then asking for a port or are people simply asking for a port.

We all know how much people hate to read but Russell hit it on the head.
Speaking strickly from an ad & m (advocacy and marketing) point of view we
should probably have something on the main web site and on the FTP mirrors that
point people over to the relevant documentation. Some user comments might be in
order too.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

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

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

Nov 12 '05 #9

P: n/a
On Mon, 22 Dec 2003, Adrian Klaver wrote:
On Monday 22 December 2003 08:16 am, Keith C. Perry wrote:
I'm not familiar with the cygwin environment but is there something about
that is turning off users to using it to run PG?

It seems to me we should be seeing *more* ports about how PG is performing
on cygwin instead of questions about a native port- especially from new
users.


The problem is not so much Cygwin as the platform it runs on. It is Unix
emulation on Windows and therefore is only as stable as the version of
Windows you are using. I have run Postgres using Cygwin on various Win9x
versions. The Cygwin installer makes the process easy to do. The problem is
that it doesn't take much to load down the system. Also, given the frequency
with which Win9X versions crash you spend alot of time waiting for the
database to come up again. All in all it was more productive to move Postgres
to a dedicated Linux server.


But please note that if one had a reliable winxp/2k class box that would
probably be much more reliable. But it would still be much slower than
linux on the same hardware.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #10

P: n/a
Quoting "scott.marlowe" <sc***********@ihs.com>:
On Mon, 22 Dec 2003, Adrian Klaver wrote:
On Monday 22 December 2003 08:16 am, Keith C. Perry wrote:
I'm not familiar with the cygwin environment but is there something about that is turning off users to using it to run PG?

It seems to me we should be seeing *more* ports about how PG is performing on cygwin instead of questions about a native port- especially from new
users.


The problem is not so much Cygwin as the platform it runs on. It is Unix
emulation on Windows and therefore is only as stable as the version of
Windows you are using. I have run Postgres using Cygwin on various Win9x
versions. The Cygwin installer makes the process easy to do. The problem is

that it doesn't take much to load down the system. Also, given the

frequency
with which Win9X versions crash you spend alot of time waiting for the
database to come up again. All in all it was more productive to move

Postgres
to a dedicated Linux server.


But please note that if one had a reliable winxp/2k class box that would
probably be much more reliable. But it would still be much slower than
linux on the same hardware.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Personally, I think the only real reason to port PG to windows **is** for
marketing/advocacy reason. I don't use windows for anything major in my
company- just the accounting box *grin* (actually, that IS pretty major so I
guess I'm a liar *laff*).

The thing I was trying to get at (since as someone pointed out this question
about a windows port comes up about 3 times a month) is whether people are using
cygwin to run and then asking for a port or are people simply asking for a port.

We all know how much people hate to read but Russell hit it on the head.
Speaking strickly from an ad & m (advocacy and marketing) point of view we
should probably have something on the main web site and on the FTP mirrors that
point people over to the relevant documentation. Some user comments might be in
order too.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

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

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

Nov 12 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.