Re: How to copy database - Mailing list pgsql-novice

From Aarni Ruuhimäki
Subject Re: How to copy database
Date
Msg-id 200302171024.47546.aarni.ruuhimaki@kymi.com
Whole thread Raw
In response to How to copy database  (Sudheesh Krishnankutty <sudheesh@softjin.com>)
Responses Re: How to copy database
List pgsql-novice
Hi !

One way is to:

#pg_dump -c employee_db > employee_dump_c

then

#createdb employee_release

and

#cat employee_dump_c | psql employee_release

BR,

aarni

On Monday 17 February 2003 10:20 am, you wrote:
> Dear Admins,
>
> I want to make a copy of an existing database.
> How should I go about doing that. (Say I have an employee database
> and I want to copy it to employee-release and employee-test.)
>
> regards
>
> Sudheesh


pgsql-novice by date:

Previous
From: Sudheesh Krishnankutty
Date:
Subject: How to copy database
Next
From: David C.Oshel
Date:
Subject: Re: How to copy database