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.