Simply dump the database with pg_dump, copy the dump to the other machine and restore the dump there.
See the man pages of pg_dump how to use the tool. If you're database contains foreign keys or similar, make sure to include OIDs into the database dump.
-- Matthias
Hi,
I have a database (table, stored procedures, accounts,..) on 1 computer.
for some reason i need to move this database to another computer but not in the same folder name or on the same HDD.
how can i export (and after import) all relative structure and data ?
or maybe a backup of DB is enough ?
thanks a lot,
Alain