Ok, I understand this difference now. Knowing that, what is the standard way to copy a single database to another server?
- can I use pg_dumpall to dump a single db? - or - I have to use pg_dump and there is a procedure to ensure that old and new dbs are the same, like 1. create new db 2. check or create user 3. run pg_restore 4. do alter db and is there a way to automate this? If there is could you point me there? If there isn't: Do you think that automating the complete backup and restore of a single database would be database specific or it could work with different databases? Don't you think that this is something that would be generally useful? Thank you for the help. Balázs ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
