pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
bad dump
6+ messages / 2 participants
[nested] [flat]

* bad dump
@ 2006-05-02 11:02 tony <tony@tgds.net>
  2006-05-02 13:26 ` Re: bad dump John DeSoi <desoi@pgedit.com>
  0 siblings, 1 reply; 6+ messages in thread

From: tony @ 2006-05-02 11:02 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

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

Tony




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: bad dump
  2006-05-02 11:02 bad dump tony <tony@tgds.net>
@ 2006-05-02 13:26 ` John DeSoi <desoi@pgedit.com>
  2006-05-02 13:47   ` Re: bad dump tony <tony@tgds.net>
  2006-05-02 14:07   ` Re: bad dump tony <tony@tgds.net>
  0 siblings, 2 replies; 6+ messages in thread

From: John DeSoi @ 2006-05-02 13:26 UTC (permalink / raw)
  To: tony <tony@tgds.net>; +Cc: pgsql-admin


On May 2, 2006, at 7:02 AM, tony wrote:

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

John



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: bad dump
  2006-05-02 11:02 bad dump tony <tony@tgds.net>
  2006-05-02 13:26 ` Re: bad dump John DeSoi <desoi@pgedit.com>
@ 2006-05-02 13:47   ` tony <tony@tgds.net>
  1 sibling, 0 replies; 6+ messages in thread

From: tony @ 2006-05-02 13:47 UTC (permalink / raw)
  To: John DeSoi <desoi@pgedit.com>; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: bad dump
  2006-05-02 11:02 bad dump tony <tony@tgds.net>
  2006-05-02 13:26 ` Re: bad dump John DeSoi <desoi@pgedit.com>
@ 2006-05-02 14:07   ` tony <tony@tgds.net>
  2006-05-02 14:26     ` Re: bad dump John DeSoi <desoi@pgedit.com>
  1 sibling, 1 reply; 6+ messages in thread

From: tony @ 2006-05-02 14:07 UTC (permalink / raw)
  To: John DeSoi <desoi@pgedit.com>; +Cc: pgsql-admin

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

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

Reading through in a text editor (nedit) rather than with pico or nano
in a terminal the sql colour coding gives me a clue:

	- the data contains non escaped ' as in "d'Anjou"

Is this my issue? 

Tony




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: bad dump
  2006-05-02 11:02 bad dump tony <tony@tgds.net>
  2006-05-02 13:26 ` Re: bad dump John DeSoi <desoi@pgedit.com>
  2006-05-02 14:07   ` Re: bad dump tony <tony@tgds.net>
@ 2006-05-02 14:26     ` John DeSoi <desoi@pgedit.com>
  2006-05-02 14:44       ` Re: bad dump tony <tony@tgds.net>
  0 siblings, 1 reply; 6+ messages in thread

From: John DeSoi @ 2006-05-02 14:26 UTC (permalink / raw)
  To: tony <tony@tgds.net>; +Cc: pgsql-admin


On May 2, 2006, at 10:07 AM, tony wrote:

> Reading through in a text editor (nedit) rather than with pico or nano
> in a terminal the sql colour coding gives me a clue:
>
> 	- the data contains non escaped ' as in "d'Anjou"
>
> Is this my issue?

Again, you have not posted exactly what the error is. Show the  
commands you used to dump and restore and include the exact error  
output from the restore operation.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: bad dump
  2006-05-02 11:02 bad dump tony <tony@tgds.net>
  2006-05-02 13:26 ` Re: bad dump John DeSoi <desoi@pgedit.com>
  2006-05-02 14:07   ` Re: bad dump tony <tony@tgds.net>
  2006-05-02 14:26     ` Re: bad dump John DeSoi <desoi@pgedit.com>
@ 2006-05-02 14:44       ` tony <tony@tgds.net>
  0 siblings, 0 replies; 6+ messages in thread

From: tony @ 2006-05-02 14:44 UTC (permalink / raw)
  To: John DeSoi <desoi@pgedit.com>; +Cc: pgsql-admin

Le mardi 02 mai 2006 à 10:26 -0400, John DeSoi a écrit :
> On May 2, 2006, at 10:07 AM, tony wrote:
> 
> > Reading through in a text editor (nedit) rather than with pico or nano
> > in a terminal the sql colour coding gives me a clue:
> >
> > 	- the data contains non escaped ' as in "d'Anjou"
> >
> > Is this my issue?
> 
> Again, you have not posted exactly what the error is. Show the  
> commands you used to dump and restore and include the exact error  
> output from the restore operation.

pg_dump with -d option and psql as per the doc

lots of errors fly by during the restore the most remarkable being
"illegal command \N" and "relation does not exist" for the non restored
tables

In the end the database exists I can connect to it and browse the data
that is there.

But like I said I am going back to the manual way that I used in the
good old days.

Thanks

Tony




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2006-05-02 14:44 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-02 11:02 bad dump tony <tony@tgds.net>
2006-05-02 13:26 ` John DeSoi <desoi@pgedit.com>
2006-05-02 13:47   ` tony <tony@tgds.net>
2006-05-02 14:07   ` tony <tony@tgds.net>
2006-05-02 14:26     ` John DeSoi <desoi@pgedit.com>
2006-05-02 14:44       ` tony <tony@tgds.net>

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