Thread: Logging Help Needed
Being somewhat new to the databasing world, I have done quite a bit of research on the different DB's available and decidedto go with Postgres. I am working on a system that has to have 3rd level normalization.. As one might be able to tellsince I am emailing all of you for your help, I am having a problem... I cant get it to log anything other than whenthe DB comes up, or goes down... When I did the configure, I did it with --enable-syslog and with the --without-CXX options. I read the online docs and created a file in the /usr/local/pgsql/data directory called postgresql.conf, and put in the options I wanted, those being: # -------- syslog = 2 debug_level = 2 log_connections = yes log_timestamp = yes port = 5432 # -------- (I have seen notes in the mailing list archives that logging to syslog is bad - opinions/insight on this?) As you might be able to tell from the options above, I am wanting to keep track of connections and the time that people connect up to the DB and what they execute, etc... Can anyone help? I would greatly appreciate it! Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
"Oakley " <oakerz@eudoramail.com> writes: > When I did the configure, I did it with > --enable-syslog and with the --without-CXX > options. I read the online docs and created a > file in the /usr/local/pgsql/data directory > called postgresql.conf, and put in the options > I wanted, those being: Sigh. We've *really* got to rearrange the website so that the most visible set of docs are for the latest release, not for the development tip version. You're trying to use configuration features that will be in 7.1, but they're not there now. See the docs that came with 7.0.* instead. regards, tom lane
> "Oakley " <oakerz@eudoramail.com> writes: > > When I did the configure, I did it with > > --enable-syslog and with the --without-CXX > > options. I read the online docs and created a > > file in the /usr/local/pgsql/data directory > > called postgresql.conf, and put in the options > > I wanted, those being: > > Sigh. We've *really* got to rearrange the website so that the most > visible set of docs are for the latest release, not for the development > tip version. You're trying to use configuration features that will be > in 7.1, but they're not there now. See the docs that came with 7.0.* > instead. > > regards, tom lane > Hee ... I was caught by that one... http://www.postgresql.org/mhonarc/pgsql-general/2000-06/msg00687.html So many programs apologize for not having the docs updated with the software... Postgres must be the only one having docs on line that apply to a future version :-)))) Regards Hernan
-- On Mon, 17 Jul 2000 13:19:33 leonbloy wrote: >> "Oakley " <oakerz@eudoramail.com> writes: >> > When I did the configure, I did it with >> > --enable-syslog and with the --without-CXX >> > options. I read the online docs and created a >> > file in the /usr/local/pgsql/data directory >> > called postgresql.conf, and put in the options >> > I wanted, those being: >> >> Sigh. We've *really* got to rearrange the website so that the most >> visible set of docs are for the latest release, not for the development >> tip version. You're trying to use configuration features that will be >> in 7.1, but they're not there now. See the docs that came with 7.0.* >> instead. >> >> regards, tom lane >> > >Hee ... I was caught by that one... >http://www.postgresql.org/mhonarc/pgsql-general/2000-06/msg00687.html > >So many programs apologize for not having the docs >updated with the software... >Postgres must be the only one having docs on line that >apply to a future version :-)))) > >Regards > >Hernan > First off, lemme say thanks to everyone... now I have one more thing... where are the docs that go along with the current version? I have browsed and rebrowsed the site and everything seems tostick right with the forthcoming version... oak Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
On Mon, 17 Jul 2000, Oakley wrote: > > -- > > On Mon, 17 Jul 2000 13:19:33 leonbloy wrote: > >> "Oakley " <oakerz@eudoramail.com> writes: > >> > When I did the configure, I did it with > >> > --enable-syslog and with the --without-CXX > >> > options. I read the online docs and created a > >> > file in the /usr/local/pgsql/data directory > >> > called postgresql.conf, and put in the options > >> > I wanted, those being: > >> > >> Sigh. We've *really* got to rearrange the website so that the most > >> visible set of docs are for the latest release, not for the development > >> tip version. You're trying to use configuration features that will be > >> in 7.1, but they're not there now. See the docs that came with 7.0.* > >> instead. > >> > >> regards, tom lane > >> > > > >Hee ... I was caught by that one... > >http://www.postgresql.org/mhonarc/pgsql-general/2000-06/msg00687.html > > > >So many programs apologize for not having the docs > >updated with the software... > >Postgres must be the only one having docs on line that > >apply to a future version :-)))) > > > >Regards > > > >Hernan > > > > First off, lemme say thanks to everyone... now I have one more thing... > > where are the docs that go along with the current version? I have browsed and rebrowsed the site and everything seems tostick right with the forthcoming version... It's not yet ready for prime time, but you can find the docs here: http://www.Postgresql.org/users-lounge/index.html Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
leonbloy@sinectis.com.ar writes: > So many programs apologize for not having the docs > updated with the software... > Postgres must be the only one having docs on line that > apply to a future version :-)))) Yup ;-). It's nice having the devel docs up there, but seems like they ought to be labeled or segregated or something. I have the following bookmarks: <A HREF="http://www.postgresql.org/docs/postgres/index.html">PostgreSQL manual</A> (development version at hub.org). <A HREF="http://www.postgresql.org/users-lounge/docs/7.0/postgres/postgres.htm">PostgreSQL manual</A> (7.0 release at hub.org). regards, tom lane
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
On Mon, 17 Jul 2000, Tom Lane wrote: > leonbloy@sinectis.com.ar writes: > > So many programs apologize for not having the docs > > updated with the software... > > Postgres must be the only one having docs on line that > > apply to a future version :-)))) > > Yup ;-). It's nice having the devel docs up there, but seems like they > ought to be labeled or segregated or something. > > I have the following bookmarks: > > <A HREF="http://www.postgresql.org/docs/postgres/index.html">PostgreSQL > manual</A> (development version at hub.org). > > <A HREF="http://www.postgresql.org/users-lounge/docs/7.0/postgres/postgres.htm">PostgreSQL manual</A> (7.0 release at hub.org). It changed from that one, and I don't know how. Originally it was users-lounge/7.0/docs/... Then it became users-lounge/docs/7.0/... I checked it earlier when it didn't work and now it's: users-lounge/docs/v7.0/... I just can't wait to see what it'll become in August! so the corrected link is: http://www.postgresql.org/users-lounge/docs/v7.0/postgres/postgres.htm Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
> > Yup ;-). It's nice having the devel docs up there, but seems like they > > ought to be labeled or segregated or something. Vince, can we re-target the most-visible docs references to point at the 7.0 release docs? I would assume it is just a matter of making or changing a soft link or two... - Thomas
On Tue, 18 Jul 2000, Thomas Lockhart wrote: > > > Yup ;-). It's nice having the devel docs up there, but seems like they > > > ought to be labeled or segregated or something. > > Vince, can we re-target the most-visible docs references to point at the > 7.0 release docs? I would assume it is just a matter of making or > changing a soft link or two... Should be able to make it happen in the next few days. I'm about to freeze the website. The tool is finally working that will maintain and create the site (haven't finished the cvs stuff yet, I'll hafta do them manually). The only thing that'll be in a frame is the docs, for all versions. There is a major problem tho. When I first started with the user's lounge I created two directories, 6.5 and 7.0. Under those were docs directories. I remember them being changed to docs/6.5 and docs/7.0 but don't remember why - but that's not the problem. Last month I updated the user's lounge even tho it's not ready for consumption so it'd point to the new locations. Today I find that they're now v6.5 and v7.0. I'm not sure what's going on, but for now I just symlinked it, but it can't keep playing musical chairs. Is this in a script somewhere for generating the older docs? Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
> .... Today I find that they're now v6.5 and v7.0. I know I was working in there a bit to post the 6.5 and 7.0 docs, and to get the auto-updating development docs to work. But I can't recall changing directory structure (though I *may* have done so). Should I feel guilty, or have you identified another culprit? Can anyone speak up who had an opinion (or who has dirty hands ;) on this so Vince can get back to being right-side-up and oriented? - Thomas
On Tue, 18 Jul 2000, Thomas Lockhart wrote: > > .... Today I find that they're now v6.5 and v7.0. > > I know I was working in there a bit to post the 6.5 and 7.0 docs, and to > get the auto-updating development docs to work. But I can't recall > changing directory structure (though I *may* have done so). Should I > feel guilty, or have you identified another culprit? You may have done the original 6.5/docs to docs/6.5, no complaint there. But docs/6.5 to docs/v6.5 was a surprise. We need to make sure it's not going to change again unannounced. > Can anyone speak up who had an opinion (or who has dirty hands ;) on > this so Vince can get back to being right-side-up and oriented? Not necessary unless it happens again. Then I'm gonna be looking for a big stick! :) Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================