that's strange, because I'm running 8.1.1.
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster