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