Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2

From: aromero(at)dia(dot)uned(dot)es
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2
Date: 2003-07-06 22:20:35
Message-ID: 200307062220.h66MKZ404236@hermes.uned.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have two system. The first system have RetHat 7.2 and Postgresql 7.2.3, my
other system (the second) have RedHat 7.2 and Postgresql 7.3.2.

I have expoted the data base of my first system (Postgresql 7.2.3)with command
pg_dump data_base name > export.dmp. I later import (the file export.dmp) in my
second system (with Postgresql 7.3.2) with command psql data_base name <
export.dmp.

Until here, everything seems well, but, when I am proving my second system with
the data base imported already, I have a serious error.

I verify after of several tests and this error happens when the system is
calling to function of but of 31 character.

In Postgresql 7.2.3 the name function it truncated them to 31 character. The
problem is what when I export the function name are exported truncated, however
in Postgres 7.3.2 it dont truncated to 31 character and my system it called
them without truncated.

Why the name function it truncates them in Postgresql 7.2.3 and Postgresql
7.3.2 no?
it depends some variable of configuation of Postgresql 7.3.2.

I dont understand this.

Everybody this has happened him.

Thank you for advance.

Angel

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Bertheau 2003-07-06 22:48:19 Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore
Previous Message Soeren Laursen 2003-07-06 22:01:04 Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error