Kevin Bailey <kbailey@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
