On 11/3/07, Abandoned <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq