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

Re: Backup questions

From: "Jason Tesser" <JTesser(at)nbbc(dot)edu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Backup questions
Date: 2004-07-30 18:07:36
Message-ID: 04875CB4331F0240A0AD66F970978651160AFE@paul (view raw or flat)
Thread:
Lists: pgsql-general
I am not sure how to be more specific.  Basically when I try to restore
a database that has been dumped in which the primary key to a table
has had its name changed the restore fails because it thinks a relation
is missing.  

> 
> 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)



Responses

pgsql-general by date

Next:From: Bruno Wolff IIIDate: 2004-07-30 18:08:12
Subject: Re: Shared Foreign Keys From Two Tables
Previous:From: Alvaro Herrera MunozDate: 2004-07-30 17:07:18
Subject: Re: Backup questions

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