Re: [GENERAL] PostgreSQL 7.0-2 RPMset released. - Mailing list pgsql-ports
From | Thomas Good |
---|---|
Subject | Re: [GENERAL] PostgreSQL 7.0-2 RPMset released. |
Date | |
Msg-id | Pine.LNX.4.05.10005210738040.16204-100000@admin.nrnet.org Whole thread Raw |
In response to | PostgreSQL 7.0-2 RPMset released. (Lamar Owen <lamar.owen@wgcr.org>) |
Responses |
Re: [GENERAL] PostgreSQL 7.0-2 RPMset released.
|
List | pgsql-ports |
On Sat, 20 May 2000, Lamar Owen wrote: > The 7.0-2 RPMset fixes the following: > 1.) SPI headers are now the 7.0 set, and not the 6.5.3 set; > 2.) pg_options default to NOT enable syslog, or extended query logging, as > syslogd has some issues with long queries (such as issued by psql's \d > command!); > 3.) Alpha patches have returned! > > As usual, read '/usr/doc/postgresql-7.0/README.rpm' for more information. Lamar, On the GENERAL list the issue of firing up a server, and the silent flag used by the default redhatter 'postgresql' script in init.d came up. I redirect output to /var/lib/pgsql/postlog after I rm the -S from the call to the server...not having pg complain when I screw up my CGI scripts is no good to me. If I were to have a vote, I'd urge whomever to add a comment to 'postgresql the script' to offer logging in the manner described above. I do this on BSD, UnixWare and Linux (a few flavours) and have never had a problem. Other than with my own code! To be a bit clearer (tough this early): I rm the -S muzzle, >> stdout and stderr to /var/lib/pgsql/postlog, then run the whole enchilada in the background ( 2>&1 &' ). This works well. I call the script from rc.local and I still get the [OK] in brilliant green followed by the pid. Nothing appears broken *and* I get a log full of insensitive complaints about my programming skills. Who could ask for more? Here is what I do: su -l postgres -c '/usr/bin/postmaster -i -D/var/lib/pgsql >> /var/lib/pgsql/postlog 2>&1 &' Cheers, Tom > ******initdb required for those still running releases prior to 7.0RC5!******* > > Users running 6.5.x (or earlier!) need to thoroughly read and understand the > README.rpm before installing (it is available on the ftp site as README in the > RPM distribution directory, as well as in the 'unpacked' subdirectory). > > The spec file for this release, as well as all patches and supplemental > programs are available in the 'unpacked' subdirectory. > > RPMset's are available at: > ftp://ftp.postgresql.org/pub/binary/v7.0/redhat-RPM > > Further information available at http://www.ramifordistat.net/postgres, as > usual; or by e-mail at pgsql-ports@postgresql.org (i prefer RPM questions to go > to the list instead of directly to me....). > > -- > Lamar Owen > WGCR Internet Radio > 1 Peter 4:11 > --------------------------------------------------------------------------- North Richmond Community Mental Health Center --------------------------------------------------------------------------- Thomas Good, MIS Coordinator tomg@ { admin | q8 } .nrnet.org Phone: 718-354-5528 Fax: 718-354-5056 --------------------------------------------------------------------------- North Richmond Systems PostgreSQL s l a c k w a r e Are Powered By: RDBMS |---------- linux ---------------------------------------------------------------------------
pgsql-ports by date: