2007-03-31 16:05:42.740 PDT: 5681: DEBUG: postgres: PostmasterMain: initial environ dump: 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: ----------------------------------------- 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: SSH_AGENT_PID=3337 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: SHELL=/bin/bash 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: DESKTOP_STARTUP_ID= 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: TERM=xterm 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: GTK_RC_FILES=/etc/gtk/gtkrc:/home/jdavis/.gtkrc-1.2-gnome2 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: WINDOWID=44040665 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: USER=jdavis 2007-03-31 16:05:42.758 PDT: 5681: 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 16:05:42.758 PDT: 5681: DEBUG: SSH_AUTH_SOCK=/tmp/ssh-YjUqbL3294/agent.3294 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: GNOME_KEYRING_SOCKET=/tmp/keyring-mdkvPw/socket 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: USERNAME=jdavis 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: SESSION_MANAGER=local/jdavis:/tmp/.ICE-unix/3294 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: DESKTOP_SESSION=default 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: _=/home/jdavis/wd/pgsql-ss/bin/postgres 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: GDM_XSERVER_LOCATION=local 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: PWD=/home/jdavis/wd 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LANG=en_US.UTF-8 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: PGSYSCONFDIR=/home/jdavis/wd/pgsql-ss/etc 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: GDMSESSION=default 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: HISTCONTROL=ignoredups 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: SHLVL=2 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: HOME=/home/jdavis 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: GNOME_DESKTOP_SESSION_ID=Default 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LOGNAME=jdavis 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-CiSn5FNBHF,guid=cb5e904149038dde39d78800460ed65c 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: PGDATA=data 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LESSOPEN=| /usr/bin/lesspipe %s 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: DISPLAY=:0.0 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LESSCLOSE=/usr/bin/lesspipe %s %s 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: XAUTHORITY=/home/jdavis/.Xauthority 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: COLORTERM=gnome-terminal 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LC_COLLATE=en_US.UTF-8 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LC_CTYPE=en_US.UTF-8 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LC_MESSAGES=en_US.UTF-8 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LC_MONETARY=C 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LC_NUMERIC=C 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: LC_TIME=C 2007-03-31 16:05:42.758 PDT: 5681: DEBUG: ----------------------------------------- 2007-03-31 16:05:43.467 PDT: 5681: DEBUG: invoking IpcMemoryCreate(size=279003136) 2007-03-31 16:05:43.475 PDT: 5681: DEBUG: max_safe_fds = 985, usable_fds = 1000, already_open = 5 2007-03-31 16:05:43.485 PDT: 5682: LOG: database system was shut down at 2007-03-31 16:04:09 PDT 2007-03-31 16:05:43.494 PDT: 5682: LOG: checkpoint record is at 4/37EA8DE8 2007-03-31 16:05:43.494 PDT: 5682: LOG: redo record is at 4/37EA8DE8; undo record is at 0/0; shutdown TRUE 2007-03-31 16:05:43.494 PDT: 5682: LOG: next transaction ID: 0/967; next OID: 16387 2007-03-31 16:05:43.494 PDT: 5682: LOG: next MultiXactId: 1; next MultiXactOffset: 0 2007-03-31 16:05:43.566 PDT: 5682: LOG: database system is ready 2007-03-31 16:05:43.624 PDT: 5682: DEBUG: transaction ID wrap limit is 2147484171, limited by database "postgres" 2007-03-31 16:05:43.638 PDT: 5682: DEBUG: proc_exit(0) 2007-03-31 16:05:43.638 PDT: 5682: DEBUG: shmem_exit(0) 2007-03-31 16:05:43.639 PDT: 5682: DEBUG: exit(0) 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: postgres child[5688]: starting with ( 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: postgres 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: -v196608 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: -y 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: test 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: ) 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: InitPostgres 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: StartTransaction 2007-03-31 16:05:49.734 PDT: 5688: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 967/1/0, nestlvl: 1, children: <> 2007-03-31 16:05:49.734 PDT: 5681: DEBUG: forked new backend, pid=5688 socket=6 2007-03-31 16:05:49.839 PDT: 5688: DEBUG: CommitTransaction 2007-03-31 16:05:49.839 PDT: 5688: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 967/1/0, nestlvl: 1, children: <> 2007-03-31 16:05:54.163 PDT: 5688: DEBUG: StartTransactionCommand 2007-03-31 16:05:54.163 PDT: 5688: DEBUG: StartTransaction 2007-03-31 16:05:54.163 PDT: 5688: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 968/1/0, nestlvl: 1, children: <> 2007-03-31 16:05:54.266 PDT: 5688: DEBUG: PortalRun 2007-03-31 16:08:39.101 PDT: 5688: LOG: EXECUTOR STATISTICS 2007-03-31 16:08:39.101 PDT: 5688: DETAIL: ! system usage stats: ! 164.835385 elapsed 27.517719 user 11.104694 system sec ! [27.517719 user 11.104694 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 1/66753 [9/67633] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 49489/2087 [49548/2095] 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 16:08:39.120 PDT: 5688: DEBUG: CommitTransactionCommand 2007-03-31 16:08:39.120 PDT: 5688: DEBUG: CommitTransaction 2007-03-31 16:08:39.120 PDT: 5688: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 968/1/0, nestlvl: 1, children: <> 2007-03-31 16:08:39.120 PDT: 5688: LOG: duration: 164957.533 ms statement: select count(*) from test; 2007-03-31 16:09:57.620 PDT: 5688: DEBUG: proc_exit(0) 2007-03-31 16:09:57.620 PDT: 5688: DEBUG: shmem_exit(0) 2007-03-31 16:09:57.621 PDT: 5688: DEBUG: exit(0) 2007-03-31 16:09:57.639 PDT: 5681: DEBUG: server process (PID 5688) exited with exit code 0 2007-03-31 16:10:03.347 PDT: 5681: DEBUG: postmaster received signal 15 2007-03-31 16:10:03.347 PDT: 5681: LOG: received smart shutdown request 2007-03-31 16:10:03.361 PDT: 5683: LOG: shutting down 2007-03-31 16:10:03.663 PDT: 5683: LOG: database system is shut down 2007-03-31 16:10:03.663 PDT: 5683: DEBUG: proc_exit(0) 2007-03-31 16:10:03.663 PDT: 5683: DEBUG: shmem_exit(0) 2007-03-31 16:10:03.663 PDT: 5683: DEBUG: exit(0) 2007-03-31 16:10:03.664 PDT: 5681: DEBUG: proc_exit(0) 2007-03-31 16:10:03.664 PDT: 5681: DEBUG: shmem_exit(0) 2007-03-31 16:10:03.734 PDT: 5681: DEBUG: exit(0)