Your name : A Wu
Your email address : sunwukong (AT) ieee (DOT) org


System Configuration
---------------------
Architecture (example: Intel Pentium) : AMD Opteron 242

Operating System (example: Linux 2.4.18) : Linux 2.6.7-gentoo-r13 x86_64

PostgreSQL version (example: PostgreSQL-8.0): PostgreSQL-8.0Beta1

Compiler used (example: gcc 2.95.2) : gcc-3.4.1


Please enter a FULL description of your problem:
------------------------------------------------
[Follow-up to bug report #1216] I recompiled with the additional flags:

--enable-debug --enable-depend --enable-cassert

I've also set

log_error_verbosity = verbose

Unfortunately neither the postgresql.log:

LOG: 00000: database system is ready
LOCATION: StartupXLOG, xlog.c:4461
ERROR: 42704: group "regressgroup1" does not exist
LOCATION: DropGroup, user.c:1769
LOG: 00000: server process (PID 3758) was terminated by signal 11
LOCATION: LogChildExit, postmaster.c:2333
LOG: 00000: terminating any other active server processes
LOCATION: HandleChildCrash, postmaster.c:2226
LOG: 00000: all server processes terminated; reinitializing
LOCATION: reaper, postmaster.c:2126
LOG: 00000: database system was interrupted at 2004-08-12 11:09:01 MDT
LOCATION: StartupXLOG, xlog.c:4002
LOG: 00000: checkpoint record is at 0/B53588
LOCATION: StartupXLOG, xlog.c:4070
LOG: 00000: redo record is at 0/B53588; undo record is at 0/0; shutdown TRUE
LOCATION: StartupXLOG, xlog.c:4097
LOG: 00000: next transaction ID: 591; next OID: 41804
LOCATION: StartupXLOG, xlog.c:4100
LOG: 00000: database system was not properly shut down; automatic recovery in progress
LOCATION: StartupXLOG, xlog.c:4156
LOG: 00000: redo starts at 0/B535D0
LOCATION: StartupXLOG, xlog.c:4193
LOG: 00000: record with zero length at 0/B96E68
LOCATION: ReadRecord, xlog.c:2454
LOG: 00000: redo done at 0/B96E38
LOCATION: StartupXLOG, xlog.c:4250
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1556
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1556
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1556
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1556
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1556
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1556
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1556
LOG: 00000: database system is ready
LOCATION: StartupXLOG, xlog.c:4461

nor the system log are any more help than I've already reported:

Aug 12 11:09:13 postmaster[3758]: segfault at 0000000000000020 rip 0000002a9594d565 rsp 0000007fbfffd9e8 error 4

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
see bug report #1216



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings