Re: Logging Help Needed

Well, I did some *more* reading, and created the pg_options file which contains:

syslog=0
debug_level=0
log_connections=yes
log_timestamp=yes
showportnumber
port=5432

and restarted the thing with the command: (of course all on one line):

su postgres -c 'nohup /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -d 4 </dev/null >>/var/log/postgres.log 2>&1' &

and while I am doing this, I am running a tail -f on the postgres.log file... here is the results of logging in and running a query:

FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
binding ShmemCreate(key=52e2c1, size=1104896)
DEBUG: Data Base System is starting up at Mon Jul 17 12:33:27 2000
DEBUG: Data Base System was shut down at Mon Jul 17 12:33:06 2000
DEBUG: Data Base System is in production state at Mon Jul 17 12:33:27 2000
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 4
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 4
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 4
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing 5
/usr/local/pgsql/bin/postmaster: BackendStartup: environ dump:
-----------------------------------------
PWD=/usr/local/pgsql/data
HZ=100
HOSTNAME=skate
LD_LIBRARY_PATH=/usr/local/pgsql/lib
MANPATH=:/usr/local/pgsql/man
USER=root
MACHTYPE=i386-pc-linux-gnu
MAIL=/var/spool/mail/root
LANG=C
LOGNAME=root
SHLVL=3
SHELL=/bin/sh
HOSTTYPE=i386
OSTYPE=linux-gnu
TERM=vt100
HOME=/usr/local/pgsql
PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games
POSTPORT=5432
POSTID=2147483646
PGDATA=/usr/local/pgsql/data
IPC_KEY=5432000
PG_USER=oakley
-----------------------------------------
/usr/local/pgsql/bin/postmaster: BackendStartup: pid 12115 user oakley db oakley
socket 5
/usr/local/pgsql/bin/postmaster child[12115]: starting with (/usr/local/pgsql/bi
n/postgres -d4 -v131072 -p oakley )
invalid option: /usr/local/pgsql/bin/postmaster
invalid option: 5432invalid option: 64
invalid option: /usr/local/pgsql/bin/postgres
invalid option: 4
invalid option: 32
read_pg_options: /usr/local/pgsql/bin/postmaster,-p,5432,-D,/usr/local/pgsql/dat
a,-B,64,-b,/usr/local/pgsql/bin/postgres,-d,4,-N,32
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
started: host=localhost user=oakley database=oakley
InitPostgres
StartTransactionCommand
query: SELECT usesuper FROM pg_user WHERE usename = 'oakley'
parser outputs:

{ QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBi
nary false :isTemp false :unionall false :distinctClause <> :sortClause <> :rtab
le ({ RTE :relname pg_user :ref { ATTR :relname pg_user :attrs <>} :relid 17280
:inh false :inFromCl true :inJoinSet true :skipAcl false}) :targetlist ({ TARGET
ENTRY :resdom { RESDOM :resno 1 :restype 16 :restypmod -1 :resname usesuper :res
key 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :vara
ttno 5 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5}}) :qu
al { EXPR :typeOid 16 :opType op :oper { OPER :opno 93 :opid 0 :opresulttype 16
} :args ({ VAR :varno 1 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :
varnoold 1 :varoattno 1} { CONST :consttype 19 :constlen 32 :constisnull false : constvalue 32 [ 11
1 97 107 108 101 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ] :constbyval false })} :gr
oupClause <> :havingQual <> :hasAggs false :hasSubLinks false :unionClause <> :intersectClause <> :li
mitOffset <> :limit Count <> :rowMark <>}

plan:

{ SEQSCAN :startup_cost 0.00 :total_cost 1.01 :rows 1 :width 1 :state <> :qptarg etlist ({ TARGETENTR
Y :resdom { RESDOM :resno 1 :restype 16 :restypmod -1 :resname usesuper :reskey 0 :reskeyop 0 :ressor
tgroupref 0 :resjunk false } :expr { VAR :varno 4 :varattno 5 :vartype 16 :vartypmod -1 :varlevelsup
0 :varnoold 4 :va roattno 5}}) :qpqual ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 93 :opid 6
2 :opresulttype 16 } :args ({ VAR :varno 4 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :var
noold 4 :varoattno 1} { CONST :consttype 19 :constlen 32 :constisnull false :constvalue 32 [ 111 97
107 108 101 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ] :constbyval false })}) :lefttr
ee <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0 :scanrelid 4 }

ProcessQuery
CommitTransactionCommand
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading 4
proc_exit(0)
shmem_exit(0)
exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 12115 exited with status 0
invalid option: /usr/local/pgsql/data

*whimper* I am starting to wish I never even started this project :P

Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com