Re: Logging Help Needed - Mailing list pgsql-general

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
runninga 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