Postgres Pro
Downloads
Home   >   mailing lists

upgrade to 8.4 with new character set - Mailing list pgsql-general

From Kevin Duffy
Subject upgrade to 8.4 with new character set
Date
Msg-id 56121B05583DAD418E8EC20B9FC70C1BF602@MAIL-01.WRCAPITAL.CORP
Whole thread Raw
Responses Re: upgrade to 8.4 with new character set  (Martijn van Oosterhout <kleptog@svana.org>)
Re: upgrade to 8.4 with new character set  (Howard Cole <howardnews@selestial.com>)
Re: upgrade to 8.4 with new character set  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
Tree view

 

 

From: Jonathan Schindler
Sent: Wednesday, November 11, 2009 9:58 AM
To: Kevin Duffy
Subject: upgrade to 8.4 with new character set

 

To those that know,

 

We originally built our database with a character set of SQL_ASCII.  We now know the error of our foolish ways.  We are trying to upgrade to 8.4 and the windows binaries would like us to use UTF8.  I would like to use a backup to restore onto the new installation, however I am getting warnings and errors about how I am trying to restore a SQL_ASCII character set to a UTF8 Database.  I need to have confidence that my data is intact before I can continue with the upgrade.  I was wondering what would be the best course of action.  I currently have the 8.4 database installed on a separate machine for testing. 

 

Thank you for all your help

 

Jonathan Schindler

 

 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.3.8 on AIX5.3 : compilation failed
Next
From: informatica
Date:
Subject: Re: Will PostgreSQL 8.4 allow having different encoding databases on a same PostgreSQL server ?