[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: how to clone a dataset?



On Sun, Sep 28, 2008 at 1:16 AM, david <..hidden..> wrote:
> I want to create a clone of a dataset except with a different dataset name and
> different users. Both versions need to be "live" simultaneously.

>From the command line:

createdb -U postgres new_dbname
pg_dump -U postgres -d old_dbname | psql -U postgres new_db_name

This command largely automates the steps in your post.

Best Wishes
Chris Travers