From: | Thomas Good <tomg(at)admin(dot)nrnet(dot)org> |
---|---|
To: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
Cc: | pgsql-ports(at)postgresql(dot)org, "PostgreSQL::General List" <pgsql-general(at)postgresql(dot)org>, teg(at)redhat(dot)com, Richard Smith <ozric(at)tampabay(dot)rr(dot)com> |
Subject: | Re: PostgreSQL 7.0-2 RPMset released. |
Date: | 2000-05-21 11:55:07 |
Message-ID: | Pine.LNX.4.05.10005210738040.16204-100000@admin.nrnet.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-general pgsql-hackers 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(at)postgresql(dot)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
---------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-05-22 02:26:54 | Re: PostgreSQL 7.0-2 RPMset released. |
Previous Message | Bruce Momjian | 2000-05-21 03:20:42 | PostgreSQL 7.0 a success |
From | Date | Subject | |
---|---|---|---|
Next Message | Travis Bauer | 2000-05-21 13:02:33 | Re: RPM troubleshoot |
Previous Message | Kaare Rasmussen | 2000-05-21 09:34:00 | Re: MySQL's "crashme" (was Re: Performance) |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert B. Easter | 2000-05-21 14:11:31 | Re: Thus spoke SQL3 (on OO) |
Previous Message | Kaare Rasmussen | 2000-05-21 09:34:00 | Re: MySQL's "crashme" (was Re: Performance) |
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-05-22 02:26:54 | Re: PostgreSQL 7.0-2 RPMset released. |
Previous Message | Lamar Owen | 2000-05-21 03:07:36 | PostgreSQL 7.0-2 RPMset released. |