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