Try to EXPLAIN SELECT ..., if it crash you most likely have to recompile
postgres with
that strxfrm fix and it's have nothing to do with your data.
Basically in my case, SunOS 5.8 ( dunno what Solaris version is that,
probably 8 )
PG was crashing during cost calculation, long before any data acces
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 * fro
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 mon
Mail List
Subject: Re: [GENERAL] ODBC query problem
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 w
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 Sull
or DB cluster?
>
> -Original Message-
> From: Luis Magaña [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 16, 2003 10:37 AM
> To: Andrew Sullivan
> Cc: Postgresql General Mail List
> Subject: Re: [GENERAL] ODBC query problem
>
>
> I've compiled postgresql
Forgotten to ask, what is locale for DB cluster?
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:37 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
I've compiled postgresql in 32bit
On Wed, Jul 16, 2003 at 12:36:34PM -0500, Luis Maga?a wrote:
> 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 ?.
Doesn't sound like hardware, then. I think yo
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 ?.
It very much looks like a problem I had before
do you have back trace, I will say for sure.
-Original Message-
From: Luis Magaña [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:12 AM
To: Andrew Sullivan
Cc: Postgresql General Mail List
Subject: Re: [GENERAL] ODBC query problem
On Wed, Jul 16, 2003 at 12:04:25PM -0500, Luis Maga?a wrote:
> Thanks,
>
> yes, it's running solaris 8 on a SPARC with SCSI disk.
Hmm. 64 bit? There've been plenty of bugs in the 64 bit libraries,
AFAICT. We've even discovered some of 'em ourselves, and I got so
leery that we still use a 32-b
11 matches
Mail list logo
