Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy the database.. - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Copy the database..
Date
Msg-id dcc563d10711060709j69e4fe9ah33eaa4f5b7b3a741@mail.gmail.com
Whole thread Raw
In response to Re: Copy the database..  (Abandoned <besturk@gmail.com>)
List pgsql-general
Tree view 
On 11/3/07, Abandoned <besturk@gmail.com> wrote:
>
> I tryed pg_dump but it is very slowly. Are there any faster way to
> copy database?

Assuming it's all happening on the same db server, yes:

psql template1
create database newdb template olddb

pgsql-general by date:

Previous
From: Christian Schröder
Date:
Subject: Re: (Never?) Kill Postmaster?
Next
From: "Eric Johnson"
Date:
Subject: How to find non-unique indexes in system tables