Re: Clone database using rsync? - Mailing list pgsql-general

From matt@byrney.com
Subject Re: Clone database using rsync?
Date
Msg-id b8123b6f7fd256dc07f19d7c89890585.squirrel@mail.byrney.com
Whole thread Raw
In response to Clone database using rsync?  (sparikh <sparikh@ecotality.com>)
Responses Re: Clone database using rsync?
List pgsql-general
Copying the data folder should work as long as you stop the postgres
service on the production server before starting the copy and don't start
it up again until the copy finishes.  pg_dump and pg_restore (look them up
in the online docs) will get the job done without you having to take the
production server offline.

If you go with the folder copy and your installation has postgresql.conf,
pg_hba.conf and so on in your data folder, you'll probably want to edit
them after the copy - more logging, different security etc.

Matt


> I need to clone production database to development  server ? What is the
> best
> and simplest way to achieve that? Both my production and development
> postgres versions are same. Will copy over data folder using rsync work?
>
> Thanks in advance.
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Clone-database-using-rsync-tp5777141.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Clone database using rsync?
Next
From: Adrian Klaver
Date:
Subject: Re: Clone database using rsync?