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 16:20:31
Message-ID: 04875CB4331F0240A0AD66F970978651011379FB@paul (view raw or flat)
Thread:
Lists: pgsql-general
Does anyone know what is going on with my 2nd question below?  

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Jason Tesser
> Sent: Thursday, July 29, 2004 11:09 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Backup questions
> 
> I have 2 questions.
> 
> 1. What is the best way to back up a production box running Postgres
> nightly?
> 
> 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?
> 
> Thank you
> Jason Tesser
> Software Development
> NMI 715-324-6900 x5273
> 
> 
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that
your
>       message can get through to the mailing list cleanly



Responses

pgsql-general by date

Next:From: Devrim GUNDUZDate: 2004-07-30 16:23:03
Subject: Re: 7.2 - 7.4.2 production server migration issue
Previous:From: MageDate: 2004-07-30 16:16:37
Subject: Re: 7.2 - 7.4.2 production server migration issue

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