Re: [GENERAL] PostgreSQL 7.0-2 RPMset released.

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