Search Postgresql Archives

upgrade to 8.4 with new character set

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 

 


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

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux