Re: restoring database

From: Lucas Lain <lainl(at)aconectarse(dot)com>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: restoring database
Date: 2003-12-22 23:14:51
Message-ID: 200312222014.51637.lainl@aconectarse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> If it's a plain text dump, make a copy of the backup file. Edit the
> copy and delete everything that doesn't relate to the database to be
> restored.

it's quite large to do this ...

> If you dumped in tar or special format, I believe you can use
> pg_restore -d dbname
> but I haven't done that myself and am not sure if I'm interpreting the
> manpage correctly.

this database is only for connection ..

i like the split solution ... i will try

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Ayers 2003-12-22 23:24:52 Parser: parse error - please help...
Previous Message MT 2003-12-22 23:12:39 Normalization and regexp