pg-db-copy-maker

Tool for transfering data between postgresql databases. Useful when you cannot use pg_dump (e.g. because you have no grants on sequences).