How to Install PostGreSql in Windows 2

[sweth]

Hai all,
I had downloaded postgre and cygwin to install postgre in win2k. I had problem in unzipping the tar file and install.

Pls suggest me some reference where i can get information about installing postgre in win 2k

Thanks and Regrs
Sweth

 

[jeanpierre]

As far as I am aware, there is not a w2k version of PostgreSQL

 

[rycamor]

jeanpierre -- FYI, the Cygwin toolkit comes with a version of PostgreSQL for Windows included. But, it needs the Cygwin (Unix compatibility for Windows) toolkit, in order to run.

sweth -- could you be more specific? Exactly what problems did you have? Did you read the documentation at

http://www.cygwin.com?

And what about the Cygwin setup application at

http://www.cygwin.com/setup.exe?

Did you try that? -------------------------------------------

"Now, this might cause some discomfort..."
(

http://www.wired.com/news/politics/0,1283,51274,00.html)

 

[sweth]

Hai all,
In postgresql download itself, they have given installation documents. As per the document i had installed cygwin setup.

I need help from postgresql user who had downloaded and using postgresql in win2k.

Thanks and Reagrds,
Sweth

 

[rycamor]

OK, let me see if I have this straight: you downloaded PostgreSQL 7.2.1 from

http://www.postgresql.org,

and then you looked at the documentation, installed Cygwin, and now you want to uncompress the PostgreSQL tarfile to install it in Windows?

If this is the case, then you will have to actually compile the postgreSQL code from the tar file, because PostgreSQL is distributed in source code form, or as Linux RPM binary installs. In other words, you don't get a Windows executable from

http://www.postgresql.org.

But, I was under the impression that if you run a full install of Cygwin, that it includes a Windows build of PostgreSQL, without requireing you to unpack a tar file or compile th source. If not, then I suggest you browse through these newsgroups:

http://groups.google.com/groups?hl=en&group=comp.databases.postgresql.ports

Honestly, I don't think it is worth all the trouble to try to get PostgreSQL to run under Windows. It is a very Unix-centered application, and will never perform as well in Windows. If you just want to learn PostgreSQL, why not just get a cheap used computer, run Linux or FreeBSD and install PostgreSQL on that? Then you could use ODBC to connect from your Windows workstation. PostgreSQL will run great even on a very low-end system. I do all my PostgreSQL development on an AMD K6-350 with 128 MB RAM, running FreeBSD, and that is with many other server processes running, such as Apache, PHP, Java servlets, MySQL, sshd, Samba, etc... On a standalone machine, I would probably get the same performance with PostgreSQL alone on a Pentium 166 with 64 MB RAM. -------------------------------------------

"Now, this might cause some discomfort..."
(

http://www.wired.com/news/politics/0,1283,51274,00.html)