A problem during restoring database from PostgreSql 6.5.3/7.1.3 to 7.4

From: "Wind Wood" <windwood(at)jingxian(dot)xmu(dot)edu(dot)cn>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: A problem during restoring database from PostgreSql 6.5.3/7.1.3 to 7.4
Date: 2003-12-09 06:23:56
Message-ID: 200312090629.hB96Tv5r004863@staff.xmu.edu.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello !

I can dump data from old dababase(Postgresql 6.5.3), but new problem came out when I restore the data to postgresql 7.4.

It went out during the COPY command, if I do it in such command lines:
1. pg_dump news -f pgsql-database-news.sql #in old system with postgresql 6.5.3
2. su - postgres #in new system with postgresql 7.4
3. createdb -T template0 news
4. psql news < pgsql-database-news.sql
------
ERROR: missing data for column "user_id"
CONTEXT: COPY newses, line 1:
------

But if I do it in such command line, it works well :
1. pg_dump -d news -f pgsql-data-news.sql #in old system with postgresql 6.5.3
2. su - postgres #in new system with postgresql 7.4
3. createdb -T template0 news
4. psql news < pgsql-data-news.sql

The database looks fine but I'm not sure it is really good.
Then I try postgresql 7.1.3, and I found that it is very well from 6.5.3 to 7.1.3 in the two kind of
command line.
Later I also found that it likes the 6.5.3 when I dump/restore the data from 7.1.3 to 7.4.

Could Anybody explain it? Whether there is a version with big change between 7.1.3 and 7.4 or not?  

        

             Yours Wind Wood
              windwood(at)jingxian(dot)xmu(dot)edu(dot)cn
                 2003-12-09

Browse pgsql-general by date

  From Date Subject
Next Message Christian Fowler 2003-12-09 06:28:23 Re: Making a tree with "millions and millions" of dynamic nodes
Previous Message Wind Wood 2003-12-09 06:15:50 Re: query and pg_dump problem on my postgresql 6.5.3/Redhat 6.2