Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Bugs > BUG #4128: The ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 3738 of 3896
Post > Topic >>

BUG #4128: The postmaster.opts.default file is begin ignored

by gary@[EMAIL PROTECTED] ("Gary Jay Peters") Apr 24, 2008 at 06:19 PM

The following bug has been logged online:

Bug reference:      4128
Logged by:          Gary Jay Peters
Email address:      gary@[EMAIL PROTECTED]
 version: 8.3.1
Operating system:   Linux/Debian
Description:        The postmaster.opts.default file is begin ignored
Details: 

1st, I already have a work-round, but I wanted to let someone know about
the
problem.

2nd, we are installing from source code and compiling the application
ourselves.

The problem --

As I understand it, the only the "pg_ctl" command uses the
"postmaster.opts.default" file; it uses the arguments
within "postmaster.opts.default" when spawning the "postmaster" process.

In older versions (such as "7.4.2"), the file
"postgresql-X.X.X/contrib/start-scripts/linux" uses
"pg_ctl" (see variable "DAEMON") to start the "postmaster" process. 
Because
of this, the arguments within the "postmaster.opts.default" file are use.

In newer version (I am using "8.2.5", but "8.3.1" appears to handle it the
same way), the file "postgresql-X.X.X/contrib/start-scripts/linux" does
not
use "pg_ctl" (see variable "PGCTL") to start the "postmaster" process. 
Because of this, the arguments within the "postmaster.opts.default" file
are
ignored.

Quickly looking through the source code, I found that the only file to
reference "postmaster.opts.default" is
"/postgresql-X.X.X/src/bin/pg_ctl/pg_ctl.c".

My work-around is to mutate the
"postgresql-X.X.X/contrib/start-scripts/linux" file adding a line
"DAEMON_START_ARGS=`[ -f $PGDATA/postmaster.opts.default ] && cat
$PGDATA/postmaster.opts.default`" and then changing each occurrence of
"$DAEMON -D '$PGDATA'" to
"$DAEMON $DAEMON_START_ARGS -D '$PGDATA'".

Lastly, to quote from the "postgresql-X.X.X/contrib/start-scripts/linux"
file, "What to use to start up the postmaster (we do NOT use pg_ctl for
this, as it adds no value and can cause the postmaster to misrecognize a
stale lock file)".

Gary Jay Peters
Database Management Services / HomeCU
(877) 670-2984 x 12
gary@[EMAIL PROTECTED]
 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs




 5 Posts in Topic:
BUG #4128: The postmaster.opts.default file is begin ignored
gary@[EMAIL PROTECTED] (  2008-04-24 18:19:44 
Re: BUG #4128: The postmaster.opts.default file is begin ignored
tgl@[EMAIL PROTECTED] (T  2008-04-24 15:17:31 
Re: BUG #4128: The postmaster.opts.default file is begin
alvherre@[EMAIL PROTECTED  2008-04-24 15:21:05 
Re: BUG #4128: The postmaster.opts.default file is begin ignored
peter_e@[EMAIL PROTECTED]  2008-04-24 21:52:37 
Re: BUG #4128: The postmaster.opts.default file is begin ignored
tgl@[EMAIL PROTECTED] (T  2008-04-24 16:14:53 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 14:49:12 CDT 2008.