From: | Hannu Krosing <hannu(at)trust(dot)ee> |
---|---|
To: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] pg_dump not dumping all tables |
Date: | 1999-07-28 22:49:55 |
Message-ID: | 379F8913.DCFE646E@trust.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"G. Anthony Reina" wrote:
>
> I just installed 6.5.1 on my RH 6.0 PII/400 MHz machine. I had
> previously been running the database on 6.4.2 and had several backups
> made through pgdump. When I tried to restore the database (i.e. psql -e
> db01 < db.backup) all of the tables were created, but only some of them
> had data. These tables are just real tables, not views or anything
> strange. Luckily, I also had a back up where I had pg_dump'ed each table
> separately (so I'm not in a total jam). But I can't figure out why the
> pg_dump didn't backup all of the data.
>
> -Tony Reina
If there is even one row dumped wrong the data for the whole table is
not
inserted ;(
I've had this for row's containing \n (or maybe \r) that got dumped as
real
newline that screwed the whole COPY xxx FROM stdin.
I resolved it by editing the dumpfile via visual inspection.
Another thing to try would be to dump as proper insert strings (pg_dump
-d)
instead of copy from. It will be slow to load though ...
---------------------------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | G. Anthony Reina | 1999-07-28 22:52:22 | Re: [HACKERS] pg_dump not dumping all tables |
Previous Message | Tom Lane | 1999-07-28 22:44:11 | Re: [HACKERS] pg_dump not dumping all tables |