Postgres Pro
Downloads
Home   >   mailing lists

[SQL] How to duplicate postgres 9.4 database - Mailing list pgsql-sql

From srilinux
Subject [SQL] How to duplicate postgres 9.4 database
Date
Msg-id 1500665335643-5972442.post@n3.nabble.com
Whole thread Raw
Responses Re: [SQL] How to duplicate postgres 9.4 database  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-sql
Tree view 
Hi All

I want to duplicate the existing database , after reading documentation I
used below command which just created database, but did not create data
CREATE DATABASE standby TEMPLATE template0;


my database is 35gb so dump and psql will take longer hours

is there an fastest way to copy database on same server , so that I can just
modify pointing to the database and connect to the stanby one to do any
testing ?



--
View this message in context: http://www.postgresql-archive.org/How-to-duplicate-postgres-9-4-database-tp5972442.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] commit not completing - how to investigate?
Next
From: Igor Neyman
Date:
Subject: Re: [SQL] How to duplicate postgres 9.4 database