Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dYdch-0007PJ-C3 for pgsql-sql@arkaria.postgresql.org; Fri, 21 Jul 2017 19:30:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dYdcg-0007DM-QL for pgsql-sql@arkaria.postgresql.org; Fri, 21 Jul 2017 19:30:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dYdbh-0005JK-3W for pgsql-sql@postgresql.org; Fri, 21 Jul 2017 19:29:01 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dYdbd-0005ka-2T for pgsql-sql@postgresql.org; Fri, 21 Jul 2017 19:29:00 +0000 Received: from mben.nabble.com (unknown [162.253.133.72]) by mwork.nabble.com (Postfix) with ESMTP id 9CF6254E93085 for ; Fri, 21 Jul 2017 12:28:55 -0700 (MST) Date: Fri, 21 Jul 2017 12:28:55 -0700 (MST) From: srilinux To: pgsql-sql@postgresql.org Message-ID: <1500665335643-5972442.post@n3.nabble.com> Subject: How to duplicate postgres 9.4 database MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql