pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: tony <tony@tgds.net>
To: John DeSoi <desoi@pgedit.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: bad dump
Date: Tue, 02 May 2006 15:47:24 +0200
Message-ID: <1146577645.2154.146.camel@hush.localdomain> (raw)
In-Reply-To: <0F67FFD0-E5D0-4E39-AE2F-2E665F972FC2@pgedit.com>
References: <1146567751.2154.119.camel@hush.localdomain>
	<0F67FFD0-E5D0-4E39-AE2F-2E665F972FC2@pgedit.com>

Le mardi 02 mai 2006 à 09:26 -0400, John DeSoi a écrit :

> > Still fighting with my database dump from 8.1.1 here.
> >
> > I can not use this dump to rebuild the database in 7.3.4 (RHEL 3) or
> > 8.0.1 (mac OS X)
> >
> > I am convinced that the dump has issues... looked in the doc and don't
> > seem to be missing anything. I have been dumping and rebuilding for  
> > the
> > last 6 years (pg version 7).
> 
> I would have concerns about going from a newer version to an older  
> version (the other way around is less problematic). But you gave no  
> clues about specific errors or the format of the dump you are trying  
> to load.

I tried inserts and got errors - the tables were not all rebuilt. Most
of the tables were rebuilt and data was inserted just fine but three
core tables are missing.

Reading through the dump file there are no clues to what is different in
these three (ownership, rights etc.). There are no blobs or complicated
procedures or anything else in the database, very basic, not too big (17
Mb dump file un compacted)...

So back to the good old fashioned way - export data as text, create
database and tables and copy back in from text file.

What really puzzles me is the partial restore. If it is broke it should
be broke everywhere...

Tony




view thread (6+ messages)  latest in thread

Message-ID: <1146577645.2154.146.camel@hush.localdomain>
Permalink:  ../1146577645.2154.146.camel@hush.localdomain/
Also on:    postgresql.org/message-id/1146577645.2154.146.camel@hush.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tony@tgds.net, desoi@pgedit.com
  Subject: Re: bad dump
  In-Reply-To: <1146577645.2154.146.camel@hush.localdomain>
  References: <1146567751.2154.119.camel@hush.localdomain> <0F67FFD0-E5D0-4E39-AE2F-2E665F972FC2@pgedit.com> <1146577645.2154.146.camel@hush.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox