On Thu, May 2, 2013 at 3:01 PM, Huan Ruan <huan.ruan...@gmail.com> wrote:
> create a new db using the current one as a template. Easy to do and speed > is acceptable. A bit downtime is ok, but it's only on the current server. > Is there a way to move it to anther server? FWIW, I recently set up a 160GB clone by simply piping from pg_dump over the network into psql, alleviating the need to dump to disk. In my case, the server did not have enough space to hold the pg_dump, so I had to stream it. pg_dump -Fp your_db | psql -h new_server -U postgres your_new_db You could also search the archives for caveats and other (and safer) ways to do this.