Kevin Bailey <kbailey(at)freewayprojects(dot)com> writes:
> Tom Lane wrote:
>> What exactly is the scenario you are trying to have here? Is this
>> a poor man's substitute for replication?
> Yes. Poor man's replication is what we're after! :o)
>> Do you want the destination
>> server to include other stuff besides what is coming from the source?
> The destination server (we call the Secondary server) only needs to be a
> copy of the Primary (live) server.
Well, the easiest solution is just to re-initdb the secondary and load
pg_dumpall output into it. Is there anything you expect to gain by
re-inventing portions of pg_dumpall?
regards, tom lane