Re: Can a whole server be restored over to another server in a single command? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Can a whole server be restored over to another server in a single command?
Date
Msg-id 16962.1239459234@sss.pgh.pa.us
Whole thread Raw
In response to Can a whole server be restored over to another server in a single command?  (Kevin Bailey <kbailey@freewayprojects.com>)
Responses Re: Can a whole server be restored over to another server in a single command?  (Kevin Bailey <kbailey@freewayprojects.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Kevin Bailey
Date:
Subject: How to completely clean out all databases from a PG server and reinitialise from scratch
Next
From: Péter Kovács
Date:
Subject: Re: Finding out on exactly what I am stuck