Hi,
After having moved all of the data to a new database initializaed with
es_MX as locale, the postmaster is dying and restarting every time a
program tries to read information on this tables:
pg_catalog.pg_class
pg_catalog.pg_namespace
it is important to note that if I do a simple select *
I've moved all data to a new location using pg_dum/pg_restore,
Things seems to be working properly so far, data seems to be where it
should be and complete, I did the initdb once again using es_MX as
locale.
This was the first time I face such a problem with this Solaris
installation after 14
I've compiled postgresql in 32bit mode, although I'm using the
--enable-integer-datetimes flag when configuring.
I've already moved database to a diferent partition nad got the same
results, I wonder, if it is a hardware problem, why can I access both
tables individually with no problem at all ?.
Locale is es_MX
and it seems that the hardware issue wil be the reason. I've moved it
to another partition and now is working fine. I'll do more testing.
Thanks for the help.
Regards.
On Wed, 2003-07-16 at 12:52, Maksim Likharev wrote:
Forgotten to ask, what is locale for DB cluster?
I've moved the database to a third location in the same disk using
pg_dumpall, the new location works with no errors, the initdb was made
without localization.
The production db was inited with es_MX locale, may that has something
to do with the problem ?.
On Wed, 2003-07-16 at 12:40, Andrew