Re: Copy content from dbs

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Copy content from dbs
Date: 2006-06-14 13:06:25
Message-ID: 16929CD8-5365-4067-B1C6-378658C6AAC5@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 14.06.2006, at 14:12 Uhr, A. Kretschmer wrote:

>> Is there an easy way to copy the content including the table
>> structure,
>> indexes and so on from one db to another?
>
> Create the new db with the old db as template.

Thanks, but as far as I can see, I have to disconnect all clients
from the production db to do this and this wasn't an option.

I forgot to mention that. The pg_dump way is fine for me.

cug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-14 13:56:55 Re: Partitioning...
Previous Message Jan Behrens 2006-06-14 12:51:31 Re: COLLATE