Skip site navigation (1) Skip section navigation (2)

Re: Restore a backup into a new schema

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: timalou2(at)netcourrier(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restore a backup into a new schema
Date: 2008-06-17 02:34:39
Message-ID: dcc563d10806161934l5a61ad40l761705fabb31ffe3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Jun 13, 2008 at 3:33 AM,  <timalou2(at)netcourrier(dot)com> wrote:
> Hi,
>
> Is it possible to restore a backup schema to another schema ?
>
> For instance I create a backup of a database called "source" with its public schema with pg_backup
>
> I want to restore this backup in a database called "dest" into a new schema called public2

Easiest way is to edit the pg_dump file by hand or use sed / awk to
change it on the fly.

If there's a lot of data and that makes it tough to do that, look into
dumping the schema and data separately, but this doesn't always work
quite right for some complex schemas.

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-06-17 02:43:30
Subject: Re: Advice on running two database clusters on one server machine
Previous:From: Scott MarloweDate: 2008-06-17 02:32:58
Subject: Re: I: Purge Oid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group