Tag Archives: 8.4

You are here:

Home
Entries tagged with "8.4"

Upgrade PostgreSQL 8.3 To PostgreSQL 8.4 On A CentOS Server Using Yum

InsightsBy alex May 7, 2010 4 Comments

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…

ERROR: syntax error at or near “COLLATE”

ErrorsBy alex February 24, 2009 Leave a comment

You may get the following error when attempting to restore a postgreSQL database. The issue will be that you are attemping to restore a dump of a database using PostgreSQL version 8.4 and anove into a PostgreSQL database that is version 8.3 or below. ERROR: syntax error at or near “COLLATE” To resolve this issue manually edit…