How to make a copy of greenplum database without backup and restore

Post date: Jan 09, 2015 12:45:45 AM

Here is the quick way to make a duplicate copy of your database in Greenplum

[gpadmin@sachi ~]$ psql -d sachi

psql (8.2.15)

Type "help" for help.

sachi=# \l+

List of databases

-----------+---------+----------+------------------------+---------+------------+---------------------------

: gpadmin=CTc/gpadmin

: w8xpb=c/gpadmin

: bdacc_capsvc=c/gpadmin

: tev_bdasvc=c/gpadmin

: =c/gpadmin

: gpadmin=CTc/gpadmin

: sachi=CTc/gpadmin

: gpuser=CTc/gpadmin

: gpadmin=CTc/gpadmin

: gpadmin=CTc/gpadmin

(10 rows)

sachi=# create database copyofsachi template sachi;

ERROR: source database "sachi" is being accessed by other users

sachi=# \q

[gpadmin@sachi ~]$ psql -d template1

psql (8.2.15)

Type "help" for help.

template1=# create database copyofsachi template sachi;

CREATE DATABASE

template1=# sachi=# \l+

List of databases

-------------+---------+----------+------------------------+---------+------------+---------------------------

: gpadmin=CTc/gpadmin

: w8xpb=c/gpadmin

: bdacc_capsvc=c/gpadmin

: tev_bdasvc=c/gpadmin

: =c/gpadmin

: gpadmin=CTc/gpadmin

: sachi=CTc/gpadmin

: gpuser=CTc/gpadmin

: gpadmin=CTc/gpadmin

: gpadmin=CTc/gpadmin

(11 rows)

template1-#