Re: autovacuum process (PID ...) was terminated by signal 11 - Mailing list pgsql-bugs

that's strange, because I'm running 8.1.1.

[root@pgdb01 root]# /usr/pg-8.1/bin/postmaster --version
postmaster (PostgreSQL) 8.1.1

Is there more information i can provide to help find the problem?

On Jan 4, 2006, at 10:04 AM, Tom Lane wrote:

> Brian Hirt <bhirt@mobygames.com> writes:
>> When I'm doing a database load of a 5gb database, autovacuum always
>> segfaults shortly after the load finishes.
>
> This sure looks like the same bug already fixed in 8.1.1:
>
> 2005-11-28 08:35  alvherre
>
>     * src/backend/postmaster/autovacuum.c: Set a snapshot before
>     running analyze on a single table, to avoid a crash when analyzing
>     tables with expressional indexes.
>
>     Per report from Frank van Vugt.
>
>             regards, tom lane

--------------------------------------------
MobyGames
http://www.mobygames.com
The world's largest and most comprehensive
gaming database project