Skip site navigation (1) Skip section navigation (2)

Re: migration problem 8.1.17 --> 8.4.2

From: Lutz Steinborn <l(dot)steinborn(at)4c-ag(dot)de>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: migration problem 8.1.17 --> 8.4.2
Date: 2010-02-09 10:07:52
Message-ID: 20100209110752.1b21538f.l.steinborn@4c-ag.de (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, 9 Feb 2010 11:58:46 +0200
Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:

> Στις Tuesday 09 February 2010 11:54:38 ο/η Lutz Steinborn έγραψε:
> > On Tue, 9 Feb 2010 11:35:45 +0200
> > Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:
> > 
> > > Στις Tuesday 09 February 2010 10:48:31 ΞΏ/Ξ· Lutz Steinborn έγραψΡ:
> > > > Hi,
> > > > 
> > > > then importing an pg_dump result from a 8.1.17 to a 8.4.2 some varchar fields
> > > > are not imported and left blank. I've checked the dump file if the fields are
> > > > correct dumped and they are.
> > > > So it looks like the import is not working as expected.
> > > 
> > > Are you getting any messages during dump/restore?
> > No and dumping/importing only on table give me the same problem.
> 
> Could you post the table schema and some sample data which can reproduce the problem?
> 

\d cm_category
                                       Table "public.cm_category"
     Column     |            Type             |
Modifiers                         
----------------+-----------------------------+----------------------------------------------------------
 id             | integer                     | not null default nextval
('cm_category_id_seq'::regclass) modified_by    | character varying(200)      | 
 language       | character varying(10)       | 
 active         | boolean                     | 
 position       | integer                     | 
 created_at     | timestamp without time zone | 
 modified_at    | timestamp without time zone | 
 created_by     | character varying(200)      | 
 catalog_name   | character varying(500)      | 
 level          | integer                     | 
 name           | character varying(500)      | 
 description    | text                        | 
 thumbnail      | character varying(1000)     | 
 content_type   | character varying(50)       | 
 original_id    | character varying(100)      | 
 system_name    | character varying(100)      | 
 system_version | character varying(50)       | 
Indexes:
    "cm_category_pkey" PRIMARY KEY, btree (id) CLUSTER
    "idx_cm_category_active" btree (active)
    "idx_cm_category_catalog_name" btree (catalog_name)
    "idx_cm_category_content_type" btree (content_type)
    "idx_cm_category_language" btree ("language")
    "idx_cm_category_level" btree ("level")
    "idx_cm_category_original_id" btree (original_id)
    "idx_cm_category_system_name" btree (system_name)
    "idx_cm_category_system_version" btree (system_version)



Example from table dump:

894367  anonym  DE  t   0   2009-11-15 08:45:56.413266  2009-11-15
08:45:56.413266  anonym  pPool-5556070003-6556071008 1
Präzisions-Feinfilterregler|800 l/min*  Anwendung: Präzisions-Feinfilterregler
werden eingesetzt, um einen genauen Druck - unabhängig von Vordruck und
Durchflussleistung - einzustellen. Sie werden z.B. für Steuer- und Regelanlagen
in der Verfahrenstechnik eingesetzt, wo hohe Anforderungen   \N  category
D749284932A9462585B9404F7EEEF9CE


Example after import in the db:

select * from cm_category where id=894367;
   id   | modified_by | language | active | position |
created_at         |        modified_at         | created_by |
catalog_name         | level |                  name
|                                                                                                                        description                                                                                                                        | thumbnail | content_type |           original_id            | system_name | system_version 
--------+-------------+----------+--------+----------+----------------------------+----------------------------+------------+-----------------------------+-------+----------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+----------------------------------+-------------+----------------
 894367 | anonym      | DE       | t      |        0 | 2009-11-15
08:45:56.413266 | 2009-11-15 08:45:56.413266 | anonym     |
pPool-5556070003-6556071008 |     1 |  |  |           | category     |
D749284932A9462585B9404F7EEEF9CE |             | 


May be the \N in the description confusing the import ?



-- 
Lutz 

In response to

pgsql-admin by date

Next:From: Dimitri FontaineDate: 2010-02-09 10:39:08
Subject: Re: Best Replication Tool
Previous:From: Achilleas MantziosDate: 2010-02-09 09:58:46
Subject: Re: migration problem 8.1.17 --> 8.4.2

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