Thread: PostgreSQL Linux Distro
Hi, I started using PostgreSQL on Ubunutu Linux. After a lots of struggles I got the latest version of Postres, pgAdmin and PostGIS installed. This was a testing phase to see if Postgres will be used in a new project. I decided to use Postgres over MySQL and would now like to know what is the best linux distro to install Postgres on. I want the ability to use a package manager (like ubuntu's) to get the latest versions of the above mentioned applications, as they become available. I installed all the above from source because the repositories for my Ubuntu does not have the latest releases. If there is a package repository (for Ubuntu) that does have the latest releases I can someone please help me get them added to my list of repositories. I also want Linux to notify me if updates are available and update the packages. I am willing to get a new Linux distro if there is advantages to another one, but wants to make an informed decision. What other distros should I consider. It looks like it must be between CentOS, Fedora and RedHat Enterprise. Does these have updated (to the latest release) repositories of the required software. Is my assumption correct that these have updated repositories and are the best supported by PostgreSQL. I do know there is a licensing fee associated with RHEL and is willing to obtain one if it is the better choice. I come from a Windows background and Linux and Postgres (any DB) is very new to me but I can find my way around with Linux. Please help me with this as full scale development must start, Carel This message and attachments are subject to a disclaimer. Please refer to www.it.up.ac.za/documentation/governance/disclaimer/ for full details. / Hierdie boodskap en aanhangsels is aan 'n vrywaringsklousule onderhewig. Volledige besonderhede is by www.it.up.ac.za/documentation/governance/disclaimer/ beskikbaar.
In response to Carel Combrink : > Hi, > > I started using PostgreSQL on Ubunutu Linux. After a lots of struggles > I got the latest version of Postres, pgAdmin and PostGIS installed. > This was a testing phase to see if Postgres will be used in a new > project. I decided to use Postgres over MySQL and would now like to > know what is the best linux distro to install Postgres on. > > I want the ability to use a package manager (like ubuntu's) to get the > latest versions of the above mentioned applications, as they become > available. I installed all the above from source because the > repositories for my Ubuntu does not have the latest releases. If there > is a package repository (for Ubuntu) that does have the latest > releases I can someone please help me get them added to my list of > repositories. I also want Linux to notify me if updates are available > and update the packages. You an use 8.4 on Ubuntu, no problem: 09:43 < pg_docbot_adz> http://www.ubuntulinux.org :: https://launchpad.net/~pitti/+archive/postgresql :: http://www.ubuntugeek.com/howto-setup-database-server-with-postgresql-and-pgadmin3.html:: http://andreas.scherbaum.la/blog/archives/272-locales-on-Ubuntu.html 09:43 < pg_docbot_adz> http://packages.ubuntu.com/karmic/postgresql-8.4 :: http://postgis.refractions.net/pipermail/postgis-users/2005-December/010338.html:: http://pwet.fr/man/linux/commandes/pg_wrapper > > I am willing to get a new Linux distro if there is advantages to > another one, but wants to make an informed decision. What other > distros should I consider. It looks like it must be between CentOS, > Fedora and RedHat Enterprise. Does these have updated (to the latest Use the distro you are familiar with. Regards -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
On Wed, 2010-04-14 at 09:29 +0200, Carel Combrink wrote: > What other distros should I consider. It looks like it must be > between CentOS, Fedora and RedHat Enterprise. Fedora is not a good option, unless you are willing to update your server once a year. RHEL or CentOS is better in terms of long term support. > Does these have updated (to the latest release) repositories of the > required software. Yes. RHEL 5.5 ships with PostgreSQL 8.4 (it was only 8.1 until that release). Also, there are RPMs for RHEL/CentOS: http://yum.pgrpms.org -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
On 2010-04-14, Carel Combrink <s25291930@tuks.co.za> wrote: > Hi, > > I started using PostgreSQL on Ubunutu Linux. After a lots of struggles > I got the latest version of Postres, pgAdmin and PostGIS installed. > This was a testing phase to see if Postgres will be used in a new > project. I decided to use Postgres over MySQL and would now like to > know what is the best linux distro to install Postgres on. Whichever well maintained distro is your favourite. If you like ubuntu use it, > I want the ability to use a package manager (like ubuntu's) to get the > latest versions of the above mentioned applications, as they become > available. > I installed all the above from source because the > repositories for my Ubuntu does not have the latest releases. If there > is a package repository (for Ubuntu) that does have the latest > releases I can someone please help me get them added to my list of > repositories. 8.4 is in "squeeze" (current debian testing) or do you need 9.0 ? > I also want Linux to notify me if updates are available > and update the packages. > > I am willing to get a new Linux distro if there is advantages to > another one, but wants to make an informed decision. If you need 8.4 can you use "lucid lynx" ubuntu 10.04 , beta available now. full release due out real soon now.