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

Re: Backup questions

From: Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl>
To: Jason Tesser <JTesser(at)nbbc(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup questions
Date: 2004-07-30 17:07:18
Message-ID: 20040730170718.GA22690@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Jul 30, 2004 at 11:20:31AM -0500, Jason Tesser wrote:
> Does anyone know what is going on with my 2nd question below?  

I think you'd have to show a specific example.

> > 2.  I thought the best way was to create a script that would use pg_dump to
> > create a dump every night and then use restore if I need to.  I did this
> > but I am having a problem.  Apparently there were a few Primary key Big
> > Serial fields that had the name changed on them after they were created.
> > The backup works fine but during the restore it fails because it thinks a
> > relation is missing.  Before restoring the database with the changed fields
> > works fine, I just cannot get it to restore.  Is there something in the
> > background that Postgres is hanging on to after I renamed the fields that
> > is preventing me from restoring?  How can I work around this?

-- 
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Linux transformó mi computadora, de una `máquina para hacer cosas',
en un aparato realmente entretenido, sobre el cual cada día aprendo
algo nuevo" (Jaime Salinas)

In response to

pgsql-general by date

Next:From: Jason TesserDate: 2004-07-30 18:07:36
Subject: Re: Backup questions
Previous:From: Thomas T. ThaiDate: 2004-07-30 17:01:44
Subject: Shared Foreign Keys From Two Tables

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