pf@xxxxxxxxxxx writes: > encodings for database "template1" do not match: old "UTF8", new > "SQL_ASCII" Failure, exiting So you need to do the initdb under the same locale setting you used for the old DB. Looking into its LC_XXX settings should refresh your memory on what that was. regards, tom lane