7.0.3 -> 7.1.2; pg_setlocale error

From: "pgsql-admin" <pgsql-admin(at)fc(dot)emc(dot)com(dot)ph>
To: pgsql-admin(at)postgresql(dot)org
Subject: 7.0.3 -> 7.1.2; pg_setlocale error
Date: 2001-06-14 15:34:06
Message-ID: fc.000f567200c3c870000f567200c3c870.c3c908@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am trying to migrate from 7.0.3 to 7.1.2. I just got the
rpms from rawhide of redhat.

While loading the 7.0.3 dump_file to 7.1.2, I got these errors...

ERROR: stat failed on file '/usr/lib/pgsql/plpgsql.so': No such file or
directory
ERROR: PL handler function plpgsql_call_handler() doesn't exist
You are now connected as new user postgres.
NOTICE: copy: line 1, pg_setlocale(): 'LC_COLLATE=Ȁ' cannot be honored.
NOTICE: copy: line 1, pg_setlocale(): 'LC_CTYPE=°T0(at)X' cannot be honored.
NOTICE: copy: line 1, pg_setlocale(): 'LC_MONETARY=X˜' cannot be honored.

and these showed in /var/log/postgresql

Jun 14 15:53:28 hype postgres[13306]: [68] DEBUG: query: COPY
"pp_payment" FROM stdin;
Jun 14 15:53:28 hype postgres[13306]: [69] DEBUG: ProcessUtility: COPY
"pp_payment" FROM stdin;
Jun 14 15:53:28 hype postgres[13306]: [70] NOTICE: copy: line 1,
pg_setlocale(): 'LC_COLLATE=ÈÏ^]^H\200Ð^]^H^P' cannot be honored.
Jun 14 15:53:28 hype postgres[13306]: [71] NOTICE: copy: line 1,
pg_setlocale(): 'LC_CTYPE=°T0(at)XÞ^]^H^P' cannot be honored.
Jun 14 15:53:28 hype postgres[13306]: [72] NOTICE: copy: line 1,
pg_setlocale(): 'LC_MONETARY=XÞ^]^H\230à^]^H^P' cannot be honored.

I fixed the error on plpgsql.so by 'perl -pi.bak -e
's|/usr/lib/pgsql/plpgsql.so|/usr/lib/plpgsql.so|g' dump_file'
but I'm still confuse with notice on pg_setlocale.

Will it do harm to the data?

Thanks.

sherwin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lamar Owen 2001-06-14 15:45:23 Re: 7.0.3 -> 7.1.2; pg_setlocale error
Previous Message DHSC Webmaster 2001-06-14 14:49:44 Re: performance issues