chris=# select * from pupil where number=127;
-[ RECORD 1 ]-+-----------
number        | 127
first_name    | Savannah
last_name     | Palme
date_of_birth | 1991-10-17
mother_name   | Lesley
mother_phone  | 384-5151
father_name   | Philip
father_phone  | 338-1857
home_phone    | 366-3588
doctor_name   | Carl Denny
doctor_phone  | 377-6014
class_number  |
lessons       | {0,0}

chris=# select first_name, last_name from pupil;
FATAL 2:  XLogFlush: request is not satisfied
FATAL 2:  XLogFlush: request is not satisfied
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Server process (pid 10700) exited with status 512 at Fri Mar 16 15:38:49 2001
Terminating any active server processes...
Server processes were terminated at Fri Mar 16 15:38:49 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
Failed.
!# DEBUG:  database system was interrupted at 2001-03-16 15:10:46 NZDT
DEBUG:  CheckPoint record at (0, 108)
DEBUG:  Redo record at (0, 108); Undo record at (0, 0); Shutdown FALSE
DEBUG:  NextTransactionId: 117853; NextOid: 201268
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (0, 172)
DEBUG:  ReadRecord: record with zero len at (0, 376)
DEBUG:  redo done at (0, 340)
FATAL 2:  XLogFlush: request is not satisfied
./bin/postmaster: Startup proc 10797 exited with status 512 - abort

!#
!#
!# \q
15:39:44 postgres@berty:~ $ ./bin/pg_ctl -o -i start
postmaster successfully started
15:40:18 postgres@berty:~ $ DEBUG:  database system shutdown was interrupted at 2001-03-16 15:38:49 NZDT
DEBUG:  CheckPoint record at (0, 108)
DEBUG:  Redo record at (0, 108); Undo record at (0, 0); Shutdown FALSE
DEBUG:  NextTransactionId: 117853; NextOid: 201268
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (0, 172)
DEBUG:  ReadRecord: record with zero len at (0, 376)
DEBUG:  redo done at (0, 340)
FATAL 2:  XLogFlush: request is not satisfied
./bin/postmaster: Startup proc 10808 exited with status 512 - abort

15:40:20 postgres@berty:~ $