Re: [HACKERS] Always include encoding of database in pg_dumpall

2012-10-19 Thread Jeremy Evans
On 10/19 06:55, Tom Lane wrote: > Jeremy Evans writes: > > I've have a PostgreSQL database cluster that I've continually upgraded > > from 7.1 to 9.1 without problems using pg_dumpall and psql. When > > migrating to 9.2, I decided to change the default encoding for the > > database cluster from S

Re: [HACKERS] Always include encoding of database in pg_dumpall

2012-10-19 Thread Tom Lane
Jeremy Evans writes: > I've have a PostgreSQL database cluster that I've continually upgraded > from 7.1 to 9.1 without problems using pg_dumpall and psql. When > migrating to 9.2, I decided to change the default encoding for the > database cluster from SQL_ASCII to UTF8. When I went to restore

[HACKERS] Always include encoding of database in pg_dumpall

2012-10-19 Thread Jeremy Evans
I've have a PostgreSQL database cluster that I've continually upgraded from 7.1 to 9.1 without problems using pg_dumpall and psql. When migrating to 9.2, I decided to change the default encoding for the database cluster from SQL_ASCII to UTF8. When I went to restore my database backup (created us