zach cruise <zachc1980(at)gmail(dot)com> writes:
> Thanks! I just created new database using old database as template,
> and everything got copied over without errors. is that recommended
> over pg_dump though when just recreating database for different
> encoding?
It's pretty much guaranteed not to work, since the data will just be
copied without any encoding conversion. You could possibly get away
with it if the database is empty of data.
regards, tom lane