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
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 |