Am Freitag, 1. Oktober 2004 10:56 schrieb Richard Huxton:
> Janning Vygen wrote:
> > tonight my database got corruppted. before it worked fine.
> > in the morning some sql queries failed. it seems only one table was
> > affected. i stopped all web access and tried to backup the current
> > database
Janning Vygen wrote:
Hi Richard,
i feared all db gurus are asleep at the moment.
They are, that's why you've got me :-)
Am Freitag, 1. Oktober 2004 10:56 schrieb Richard Huxton:
PS - your next mail mentions sig11 which usually implies hardware
problems, so don't forget to test the machine thorough
Hi Richard,
i feared all db gurus are asleep at the moment.
Am Freitag, 1. Oktober 2004 10:56 schrieb Richard Huxton:
> PS - your next mail mentions sig11 which usually implies hardware
> problems, so don't forget to test the machine thoroughly once this is over.
You saved my life!! Nothing les
Janning Vygen wrote:
Hi,
tonight my database got corruppted. before it worked fine.
since two days i do the following tasks every night
psql -c 'CLUSTER;' $DBNAME
psql -c 'VACUUM FULL ANALYZE;' $DBNAME
before these opertaions i stop all web access. The last months i only did a
"VACUUM ANALYZE" eac
Am Freitag, 1. Oktober 2004 09:49 schrieben Sie:
> Hi,
>
> tonight my database got corruppted. before it worked fine.
>
> since two days i do the following tasks every night
>
> psql -c 'CLUSTER;' $DBNAME
> psql -c 'VACUUM FULL ANALYZE;' $DBNAME
>
> before these opertaions i stop all web access. Th
Hi,
tonight my database got corruppted. before it worked fine.
since two days i do the following tasks every night
psql -c 'CLUSTER;' $DBNAME
psql -c 'VACUUM FULL ANALYZE;' $DBNAME
before these opertaions i stop all web access. The last months i only did a
"VACUUM ANALYZE" each night and didn'