Обсуждение: 7.0.3 -> 7.1.2; pg_setlocale error

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

On Thursday 14 June 2001 11:34, pgsql-admin wrote:
> 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

The current rawhide RPM's put the PL's in /usr/lib instead of /usr/lib/pgsql.
The current PGDG RPM's put them in /usr/lib/pgsql, which is where the 7.0.3
RPMset put them.

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

Now these are interesting.

> Will it do harm to the data?

Does it appear to have harmed your data?
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11