Kevin Bailey <kbailey@freewayprojects.com> writes:
> Can a whole server be restored over to another server in a single command?
The output of pg_dumpall is really meant to be loaded into an empty
server. Although it has a "--clean" switch, that's got serious
limitations and I wouldn't recommend bothering with it.
What exactly is the scenario you are trying to have here? Is this
a poor man's substitute for replication? Do you want the destination
server to include other stuff besides what is coming from the source?
regards, tom lane