I have been needing to upgrade the PostgreSQL servers at my work for awhile now and was finally forced to do so after needing some of the features available with PostgreSQL 8.4.X. Currently we are running PostgreSQL 8.3.10 which is super old but it is definitely not the latest stable release available. One thing I am looking forward to testing is the improvements to the vacuum process. Over the past two years I have become a lot more familiar with Postgres and one thing that has been disappointing is the downtime involved in reclaiming disk space via data removed from PSQL database tables. The full vacuum process, which is required to reclaim disk after deleting data from a table, in 8.3 requires a lock on tables which essentially causes downtime. When you are dealing with large tables over 10GB in size this can take days to complete. Follow the directions below to first backup all of your PostgreSQL data, remove the current PostgreSQL installation, and then install PostgreSQL 8.4 on a CentOS Linux server.8.3, 8.4, backup, CentOS, chkconfig, data, database, initdb, initialize, install, Linux, pgdg, pgsql, pg_dumpall, pg_hba.conf, postgres, PostgreSQL, postgresql-devel, postgresql.conf, psql, remove, restore, RPM, upgrade, yum
Posts Tagged “pgdg”
May 07 2010
Mar 02 2009
When installing packages via yum, with repository additions, on CentOS it is possible to get a warning stating a various package is not signed. There are numerous reasons a package may not be signed so verify the source of the package is legit and if so move forward using the below command.CentOS, error, gpg check, Linux, nogpgcheck, packages, pgdg, update, warning, yum
Feb 10 2009
Keeping PostgreSQL updated via yum should be done via the pgdg yum repository supplied by pgsqlrpms.org.
The latest CentOS PostgreSQL repo can be viewed here.
You will need to download the repo and then install using rpm as shown below.
wget http://yum.pgsqlrpms.org/reporpms/8.4/pgdg-centos-8.4-1.noarch.rpm rpm -Uhv pgdg-centos-8.4-1.noarch.rpm
Another helpful postgresql install and management link is located here.Tags: pgdg, postgres, PostgreSQL, repo, repository, yum