Nicholas Barr writes:
It is much much safer to use pg_dump/pg_restore and know that your data is consistent. http://www.postgresql.org/docs/8.2/static/backup-dump.html
In particular look at the section 23.1.2. Using pg_dumpall
That will copy your entire data set including users.
