Re: How to copy database

From: Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: Sudheesh Krishnankutty <sudheesh(at)softjin(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to copy database
Date: 2003-02-17 08:24:47
Message-ID: 200302171024.47546.aarni.ruuhimaki@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Härdeman 2003-02-17 14:04:19 Ordering rows in a table
Previous Message Sudheesh Krishnankutty 2003-02-17 08:20:27 How to copy database