Newbie questions

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:

Show quoted text

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

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.gsteiger@milprog.ch> wrote in message
news:3B29ECF7.5DA2EBA7@milprog.ch...

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.

Show quoted text

Thank you,
--
Rich Bowman
Bennett Supply Company
richb@bennettsupply.com