2007-03-31 15:28:30.291 PDT: 4659: DEBUG: postgres: PostmasterMain: initial environ dump: 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: ----------------------------------------- 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: SSH_AGENT_PID=3337 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: SHELL=/bin/bash 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: DESKTOP_STARTUP_ID= 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: TERM=xterm 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: GTK_RC_FILES=/etc/gtk/gtkrc:/home/jdavis/.gtkrc-1.2-gnome2 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: WINDOWID=44040665 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: USER=jdavis 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.flac=01;35:*.mp3=01;35:*.mpc=01;35:*.ogg=01;35:*.wav=01;35: 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: SSH_AUTH_SOCK=/tmp/ssh-YjUqbL3294/agent.3294 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: GNOME_KEYRING_SOCKET=/tmp/keyring-mdkvPw/socket 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: USERNAME=jdavis 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: SESSION_MANAGER=local/jdavis:/tmp/.ICE-unix/3294 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: DESKTOP_SESSION=default 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: _=/home/jdavis/wd/pgsql/bin/postgres 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: GDM_XSERVER_LOCATION=local 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: PWD=/home/jdavis/wd 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LANG=en_US.UTF-8 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: PGSYSCONFDIR=/home/jdavis/wd/pgsql/etc 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: GDMSESSION=default 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: HISTCONTROL=ignoredups 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: SHLVL=2 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: HOME=/home/jdavis 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: GNOME_DESKTOP_SESSION_ID=Default 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LOGNAME=jdavis 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-CiSn5FNBHF,guid=cb5e904149038dde39d78800460ed65c 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: PGDATA=data 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LESSOPEN=| /usr/bin/lesspipe %s 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: DISPLAY=:0.0 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LESSCLOSE=/usr/bin/lesspipe %s %s 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: XAUTHORITY=/home/jdavis/.Xauthority 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: COLORTERM=gnome-terminal 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LC_COLLATE=en_US.UTF-8 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LC_CTYPE=en_US.UTF-8 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LC_MESSAGES=en_US.UTF-8 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LC_MONETARY=C 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LC_NUMERIC=C 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: LC_TIME=C 2007-03-31 15:28:30.306 PDT: 4659: DEBUG: ----------------------------------------- 2007-03-31 15:28:30.729 PDT: 4659: DEBUG: invoking IpcMemoryCreate(size=278994944) 2007-03-31 15:28:30.736 PDT: 4659: DEBUG: max_safe_fds = 985, usable_fds = 1000, already_open = 5 2007-03-31 15:28:30.762 PDT: 4662: LOG: database system was shut down at 2007-03-31 15:27:10 PDT 2007-03-31 15:28:30.775 PDT: 4662: LOG: checkpoint record is at 4/37EA8CF8 2007-03-31 15:28:30.775 PDT: 4662: LOG: redo record is at 4/37EA8CF8; undo record is at 0/0; shutdown TRUE 2007-03-31 15:28:30.775 PDT: 4662: LOG: next transaction ID: 0/946; next OID: 16387 2007-03-31 15:28:30.775 PDT: 4662: LOG: next MultiXactId: 1; next MultiXactOffset: 0 2007-03-31 15:28:30.838 PDT: 4662: LOG: database system is ready 2007-03-31 15:28:30.877 PDT: 4662: DEBUG: transaction ID wrap limit is 2147484171, limited by database "postgres" 2007-03-31 15:28:30.887 PDT: 4662: DEBUG: proc_exit(0) 2007-03-31 15:28:30.887 PDT: 4662: DEBUG: shmem_exit(0) 2007-03-31 15:28:30.887 PDT: 4662: DEBUG: exit(0) 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: postgres child[4673]: starting with ( 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: postgres 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: -v196608 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: -y 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: test 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: ) 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: InitPostgres 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: StartTransaction 2007-03-31 15:28:47.991 PDT: 4673: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 946/1/0, nestlvl: 1, children: <> 2007-03-31 15:28:47.991 PDT: 4659: DEBUG: forked new backend, pid=4673 socket=6 2007-03-31 15:28:48.090 PDT: 4673: DEBUG: CommitTransaction 2007-03-31 15:28:48.090 PDT: 4673: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 946/1/0, nestlvl: 1, children: <> 2007-03-31 15:28:57.396 PDT: 4673: DEBUG: StartTransactionCommand 2007-03-31 15:28:57.396 PDT: 4673: DEBUG: StartTransaction 2007-03-31 15:28:57.396 PDT: 4673: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 947/1/0, nestlvl: 1, children: <> 2007-03-31 15:28:57.668 PDT: 4673: DEBUG: PortalRun 2007-03-31 15:28:57.669 PDT: 4673: LOG: EXECUTOR STATISTICS 2007-03-31 15:28:57.669 PDT: 4673: DETAIL: ! system usage stats: ! 0.001344 elapsed 0.004000 user 0.000000 system sec ! [0.008000 user 0.004000 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 0/60 [11/1291] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 2/0 [114/7] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 3 read, 0 written, buffer hit rate = 98.72% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:28:57.669 PDT: 4673: DEBUG: CommitTransactionCommand 2007-03-31 15:28:57.669 PDT: 4673: DEBUG: CommitTransaction 2007-03-31 15:28:57.669 PDT: 4673: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 947/1/0, nestlvl: 1, children: <> 2007-03-31 15:28:57.707 PDT: 4673: DEBUG: StartTransactionCommand 2007-03-31 15:28:57.707 PDT: 4673: DEBUG: StartTransaction 2007-03-31 15:28:57.707 PDT: 4673: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 948/1/0, nestlvl: 1, children: <> 2007-03-31 15:28:57.707 PDT: 4673: DEBUG: PortalRun 2007-03-31 15:28:57.708 PDT: 4673: LOG: EXECUTOR STATISTICS 2007-03-31 15:28:57.708 PDT: 4673: DETAIL: ! system usage stats: ! 0.000250 elapsed 0.000000 user 0.000000 system sec ! [0.008000 user 0.004000 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 0/9 [11/1336] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 0/0 [115/12] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 0 read, 0 written, buffer hit rate = 100.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:28:57.708 PDT: 4673: DEBUG: CommitTransactionCommand 2007-03-31 15:28:57.708 PDT: 4673: DEBUG: CommitTransaction 2007-03-31 15:28:57.708 PDT: 4673: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 948/1/0, nestlvl: 1, children: <> 2007-03-31 15:28:59.698 PDT: 4673: DEBUG: StartTransactionCommand 2007-03-31 15:28:59.698 PDT: 4673: DEBUG: StartTransaction 2007-03-31 15:28:59.698 PDT: 4673: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 949/1/0, nestlvl: 1, children: <> 2007-03-31 15:28:59.699 PDT: 4673: DEBUG: PortalRun 2007-03-31 15:28:59.699 PDT: 4673: LOG: EXECUTOR STATISTICS 2007-03-31 15:28:59.699 PDT: 4673: DETAIL: ! system usage stats: ! 0.000216 elapsed 0.000000 user 0.000000 system sec ! [0.008000 user 0.004000 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 0/7 [11/1362] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 0/0 [116/14] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 0 read, 0 written, buffer hit rate = 100.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:28:59.699 PDT: 4673: DEBUG: CommitTransactionCommand 2007-03-31 15:28:59.699 PDT: 4673: DEBUG: CommitTransaction 2007-03-31 15:28:59.699 PDT: 4673: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 949/1/0, nestlvl: 1, children: <> 2007-03-31 15:29:09.889 PDT: 4673: DEBUG: StartTransactionCommand 2007-03-31 15:29:09.890 PDT: 4673: DEBUG: StartTransaction 2007-03-31 15:29:09.890 PDT: 4673: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 950/1/0, nestlvl: 1, children: <> 2007-03-31 15:29:09.891 PDT: 4673: DEBUG: PortalRun 2007-03-31 15:31:54.436 PDT: 4673: LOG: EXECUTOR STATISTICS 2007-03-31 15:31:54.436 PDT: 4673: DETAIL: ! system usage stats: ! 164.545421 elapsed 26.593662 user 10.852678 system sec ! [26.601662 user 10.856678 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 0/66591 [11/67960] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 49205/3490 [49325/3504] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 1351352 read, 0 written, buffer hit rate = 0.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written 2007-03-31 15:31:54.454 PDT: 4673: DEBUG: CommitTransactionCommand 2007-03-31 15:31:54.454 PDT: 4673: DEBUG: CommitTransaction 2007-03-31 15:31:54.454 PDT: 4673: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 950/1/0, nestlvl: 1, children: <> 2007-03-31 15:31:54.454 PDT: 4673: LOG: duration: 164564.657 ms statement: select count(*) from test; 2007-03-31 15:33:43.228 PDT: 4673: DEBUG: proc_exit(0) 2007-03-31 15:33:43.228 PDT: 4673: DEBUG: shmem_exit(0) 2007-03-31 15:33:43.228 PDT: 4673: DEBUG: exit(0) 2007-03-31 15:33:43.247 PDT: 4659: DEBUG: server process (PID 4673) exited with exit code 0 2007-03-31 15:34:05.645 PDT: 4659: DEBUG: postmaster received signal 15 2007-03-31 15:34:05.645 PDT: 4659: LOG: received smart shutdown request 2007-03-31 15:34:05.645 PDT: 4663: LOG: shutting down 2007-03-31 15:34:06.042 PDT: 4663: LOG: database system is shut down 2007-03-31 15:34:06.057 PDT: 4663: DEBUG: proc_exit(0) 2007-03-31 15:34:06.057 PDT: 4663: DEBUG: shmem_exit(0) 2007-03-31 15:34:06.057 PDT: 4663: DEBUG: exit(0) 2007-03-31 15:34:06.058 PDT: 4659: DEBUG: proc_exit(0) 2007-03-31 15:34:06.058 PDT: 4659: DEBUG: shmem_exit(0) 2007-03-31 15:34:06.123 PDT: 4659: DEBUG: exit(0)