tutorial , installation....help pl.

[ITphile]

Hi All,

Me a Newbie in Database and interested in Postgre.

I've sucessfully downloaded the PostgreSQL. I need help on how to install it!

Documents and tutorial web links are also welcome

TIA

ITphile

 

[rycamor]

See thread699-52163 for my install routine. Other than that. just spend some time at

http://www.postgresql.org

reading through the documentation. If you actually take the time to read it, you'll see everything spelled out for you.

I take it you are using Linux? My install was on FreeBSD but the basic methods are the same.

If you are using Linux, you might be able to just install a standard prepackaged installer for PostgreSQL, instead of downloading and compiling from source. -------------------------------------------

"Calculus is just the meaningless manipulation of higher symbols"
                          -unknown F student

 

[ITphile]

Hi rycamor

Thanks for the reply.

I'm a 'rookie' to the Open source and trying (learning) to switch over to linux from the MS platform.

But the postgre I want it on MS, now. Will the same procedure work?

Do let me know

TIA

 

[rycamor]

Well, PostgreSQL is written mainly for Unix systems. You can get PostgreSQL on Windows, if you follow a lengthy procedure requiring the Cygwin library (

http://www.cygwin.com),

that help Windows emulate Unix. Even then, it won't compile at all on "consumer" Windows (95,98,ME), only Windows NT, 2000 or XP.

The truth is, you will probably have a much harder time getting PG to work on Windows than just installing a fresh copy of Mandrake Linux, and using it's built-in install of Postgres. Honestly, if you are new at this, that will go much better for you. You can get a copy of Mandrake Linux for $5.49, if you don't need the book, at

http://cart.cheapbytes.com/cgi-bin/cart/0070010716

You will be amazed at how easy it is. This operating system actually installs easier than Windows. Just put the bootable CD in, and within half an hour, to an hour, you can have a full Linux system, with software, graphical X-window environment, etc... If you want some more help in this area, just post a message in the Linux forum, and I will be glad to help.

If you still really want to try and get postgreSQL working in Windows 2000, read this:

http://www.ca.postgresql.org/docs/faq-mswin.html

and maybe

http://people.freebsd.org/~kevlo/postgres/portNT.html

(I just noticed that the first reference claims that a basic pre-built binary of PostgreSQL comes standard with the Cygwin toolkit, so if that's the case, you might be in luck.)

Note: don't expect PostgreSQL on Windows to be anywhere near as powerful or stable as it is in Unix/Linux. Sorry, but that's just the case. -------------------------------------------

"Calculus is just the meaningless manipulation of higher symbols"
                          -unknown F student