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

Re: PostgreSQL 7.0-2 RPMset released.

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: Thomas Good <tomg(at)admin(dot)nrnet(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-22 02:26:54
Message-ID: 00052122482600.00745@lorc.wgcr.org (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-generalpgsql-hackerspgsql-ports
On Sun, 21 May 2000, Thomas Good wrote:
> 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.

Yes, I read the thread.  I didn't write the original initscript -- but
hopefully have changed it to more your liking (see below).
  
> 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.

The  7.0 RPM's /etc/rc.d/init.d/postgresql script uses pg_ctl, rather than
directly starting postmaster (and has since 7.0beta2, IIRC) -- and the
PGDATA/postmaster.opts.default (which, by default, only has '-i' -- no -S) file
is used for postmaster startup options, rather than passing them on the command
line.  The changelog notice for this was buried back in the beta cycle release
announcements -- I should have duplicated all notices for the 7.0-1 release
announcement.  

More documentation will be written as I have time (or input to README.rpm, or
patches to README.rpm).....

Look at the new initscript, then let me know about possible improvements (of
which I am sure improvements can be made!).  Currently stderr and stdout 
from pg_ctl are piped to /dev/null, but that is easy enough to change.  And, by
changing the PGDATA/pg_options file's contents, you can turn on syslog -- edit
/etc/syslog.conf to get syslogging working -- just watch out for long queries!

Logging is one of the hot issues in the RPMset right now, as the comments about
syslog in the -2 release announcement show.  The real problem with redirecting
the postmaster output is the issue of log rolling, which is impossible
to do in the 'classic' stderr/stdout redirect UNLESS you throw down postmaster
when rolling the log (unless you know a trick I don't).

I am trying to get _real_ logging, by way of syslog, rather than with redirects
-- however, the redhat syslog dies under long queries (such as the one issued
by psql in response to a \d directive).

Since some things were missed in the beta cycle's announcements (which only
were sent to pgsql-hackers), notice that the new 7.0 RPMset will create a new
PGDATA in /var/lib/pgsql/data instead of /var/lib/pgsql.  There are other
changes -- read /usr/doc/postgresql-7.0/README.rpm and the pgsql-hackers
archives on the subject.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Responses

pgsql-ports by date

Next:From: Tom LaneDate: 2000-05-22 04:19:45
Subject: Logging (was Re: PostgreSQL 7.0-2 RPMset released.)
Previous:From: Thomas GoodDate: 2000-05-21 11:55:07
Subject: Re: PostgreSQL 7.0-2 RPMset released.

pgsql-hackers by date

Next:From: Mikheev, VadimDate: 2000-05-22 03:00:01
Subject: RE: Berkeley DB...
Previous:From: Bruce MomjianDate: 2000-05-22 02:22:14
Subject: Re: Berkeley DB...

pgsql-announce by date

Next:From: Tom LaneDate: 2000-05-22 04:19:45
Subject: Logging (was Re: PostgreSQL 7.0-2 RPMset released.)
Previous:From: Thomas GoodDate: 2000-05-21 11:55:07
Subject: Re: PostgreSQL 7.0-2 RPMset released.

pgsql-general by date

Next:From: Tatsuo IshiiDate: 2000-05-22 02:45:20
Subject: Re: Re: Does Psql support Chinese?
Previous:From: cc21cnDate: 2000-05-22 02:22:32
Subject: Re: Re: Does Psql support Chinese?

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