Re: Newbie questions

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(at)bennettsupply(dot)com

Rich Bowman wrote:
>
> 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?

I run PostgreSQL on a SuSe Linux 6.4 system without any problems. But I
suspect that it will run excelent on all other UNIX'es. Especially the
*BSD family (PostgreSQL has a BSD style license).

> 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?

I use the Win32 ODBC driver, again without problems on a Win95 system.

> 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 you want to make use of the RPM's, you must use Linux Red Hat or
SuSe. Personally I prefer compiling from source though.

HTH,

Nils

--
Alles van waarde is weerloos
Lucebert

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(at)bennettsupply(dot)com

I have 2 or 3 years of Xenix experience, but that was 12 years ago, so, I'm
aaproaching this with a considerable amount of caution.

Thank you for your thoughtful responses. Your input is most helpful.

Rich Bowman

"Marcel Gsteiger" <marcel(dot)gsteiger(at)milprog(dot)ch> wrote in message
news:3B29ECF7(dot)5DA2EBA7(at)milprog(dot)ch(dot)(dot)(dot)
> 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(at)bennettsupply(dot)com
>