Re: Clone database using rsync?

On 11/5/2013 3:11 PM, sparikh wrote:
> 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?

if the database isn't gigenormous, on the new ssytem, I use the
following, while logged on as postgres...

1. manually create any roles and tablespaces the database requires
2. manually create the new database owned by the proper role
3. pg_dump -h oldhost -d dbname -Fc | pg_restore -d newdb

copying the data folder only works if you either stop the postgres
server, or invoke pg_start_backup(), or use pg_basebackup [1]

[1] http://www.postgresql.org/docs/current/static/app-pgbasebackup.html

--
john r pierce 37N 122W
somewhere on the middle of the left coast