scott.marlowe wrote:
> On Fri, 12 Sep 2003, pginfo wrote:
>
> > Hi,
> > I am runing linux red hat 7.3 (standart install)
> > on dual athlon box , 1 GB ram and pg 7.3.4.
> >
> > If I try to access with pgAdmin one from my tables (i contains ~ 1 M
> > records)
> > the linux box crashes.
>
> WAIT. Do you mean you get a kernel panic? Or the box locks up tight? Or
> the box reboots?
>
> Or does Postgresql crash?
>
> Or does the linux box complain about a bad hard drive and stop running
> postgresql?
>
> If linux is crashing, that is NOT postgresql's fault. An app can't crash
> an OS without root level access, and Postgresql ain't got that.
>
It is crashing the linux box. Not rebooting, not kernel panic, but only stop
to respond.On the console if I type reboot it will not to reboot and so on.
But it crash only if I start intensive operations on pg.
And also my problem are this messages into the log.
At hte weekend I will make some detailed tests on OS and hardware
to see if it is the problem.
It will be the best case for me if the problem is not in pg.
> > In my pg log I can find:
> > ERROR: Invalid page header in block 5604 of a_acc
> >
> > before this error I see also :
> > FATAL: Database "template0" is not currently accepting connections
> > ERROR: Relation "pg_relcheck" does not exist
> >
> > and
> >
> > ERROR: 'ksqo' is not a valid option name
>
> This sounds like you are using an older pgaccess on a newer postgresql
> database. Once upon a time, apps could connect to template0. That is no
> longer the case.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
regards,
ivan.