Hi Rich,
I'm a CNE-5 and now work with *nix systems for about a year. Here are some tips:
I use PostgreSQL 7.1.2 now on two systems:
- a compaq proliant 330 (pentium III/733) with plenty of RAM and a disk array,
running RH linux 6.2
- a hp netserver E30 (pentium I/166) with 80 MB of RAM and a 9gig SCSI disk,
running FreeBSD 4.3
both work very well (even the small one, I installed this just to see if it
works).
For both platforms, I downloaded the tarballs and built everything on that
machine. This worked without any problems. However, be prepared to spend some
time getting acquainted with installations. Usually you will need to
download/make/make install several packages to get a system that meets your
needs without containing unnecessary components. First of all, leave out X
windows and all GUIs.
For my personal experience, I installed webmin (www.webmin.com) just after the
base install of the OS. This way, I could browse the file system and administer
everything without having to learn all the *nix commands in the first place.
Also, the site www.greatbridge.org was very helpful for my productivity.
Especially phppgadmin and pgadmin are really nice products. For the ODBC
drivers, try to find the .msi versions (these are particularly easy to install).
HTH
--Marcel
Rich Bowman schrieb:
> I'm considering replacing my NetWare server running Pervasive SQL with a
> server running PostgreSQL.
>
> 1. Most people seem to run on some flavor of Unix / Linux. Is one flavor of
> Unix / Linux more PostgreSQL "friendly" than another?
>
> 2. My user apps run on NT 4.0 Terminal Server Edition with Citrix MetaFrame
> 1.8. Anybody had any experience using the PostgreSQL ODBC driver in this
> environment?
>
> 3. If I download PostgreSQL and the ODBC driver must I compile it for the
> flavor of Unix / Linux I choose or are there pre-compiled versions?
>
> If I've posted this to the wrong place, please forgive me and set me
> straight. I've read some about PostgreSQL and I'm impressed with what I see.
>
> Thank you,
> --
> Rich Bowman
> Bennett Supply Company
> richb@bennettsupply.com
