Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 7.0-2 RPMset released.

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 (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-generalpgsql-hackerspgsql-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      
---------------------------------------------------------------------------



In response to

Responses

pgsql-ports by date

Next:From: Lamar OwenDate: 2000-05-22 02:26:54
Subject: Re: PostgreSQL 7.0-2 RPMset released.
Previous:From: Lamar OwenDate: 2000-05-21 03:07:36
Subject: PostgreSQL 7.0-2 RPMset released.

pgsql-hackers by date

Next:From: Robert B. EasterDate: 2000-05-21 14:11:31
Subject: Re: Thus spoke SQL3 (on OO)
Previous:From: Kaare RasmussenDate: 2000-05-21 09:34:00
Subject: Re: MySQL's "crashme" (was Re: Performance)

pgsql-announce by date

Next:From: Lamar OwenDate: 2000-05-22 02:26:54
Subject: Re: PostgreSQL 7.0-2 RPMset released.
Previous:From: Bruce MomjianDate: 2000-05-21 03:20:42
Subject: PostgreSQL 7.0 a success

pgsql-general by date

Next:From: Travis BauerDate: 2000-05-21 13:02:33
Subject: Re: RPM troubleshoot
Previous:From: Kaare RasmussenDate: 2000-05-21 09:34:00
Subject: Re: MySQL's "crashme" (was Re: Performance)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group