Обсуждение: PgSQL postmaster.opts
Hi! I subsrcibed to this list again. :) I use the version7.0.3-8 of pgsql from RedHat rpm. I have a problem. The "/var/lib/pgsql/data/postmaster.opts" file contains this: /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data -B 64 -b /usr/bin/postgres -i -N 32 If I modify it (for examlpes, -N 16 ) then the postgres restore the previous file after the server restarting. Why???!! Bye! ----------------- Linux RedHat 7.1 -----------------
MG wrote: > > Hi! > > I subsrcibed to this list again. :) > I use the version7.0.3-8 of pgsql from RedHat rpm. > I have a problem. The "/var/lib/pgsql/data/postmaster.opts" file contains this: > > /usr/bin/postmaster > -p 5432 > -D /var/lib/pgsql/data > -B 64 > -b /usr/bin/postgres > -i > -N 32 > > If I modify it (for examlpes, -N 16 ) then the postgres restore the previous > file after the server restarting. > Why???!! > That file is not for user changes. It gets written on every postmaster restart. Either change these in postgresql.conf or on the command line. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On 29-Mar-2002 Bruce Momjian wrote: > > That file is not for user changes. It gets written on every postmaster > restart. Either change these in postgresql.conf or on the command line. > The "postgresql.conf" file doesn't exist in RedHat. :( But "/var/lib/pgsql/data/pg_options" file exists. It contains: verbose=2 query=2 syslog=0 Do I have to change the settings in this file? Bye! ----------------- Linux RedHat 7.1 -----------------
The version of postgresql you are running does not have the postgresql.conf file. If you were on postresql 7.1 or 7.2, you would have them regardless of your OS. For your version, you'll have to use the command-line switches. Look here for information on them: http://www.postgresql.org/idocs/index.php?runtime-config.html You should also consider the upgrade to a newer version of postgresql- the advantages are significant. -NickF -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of MG > Sent: Saturday, March 30, 2002 4:17 AM > To: PostgreSQL List > Subject: Re: [ADMIN] PgSQL postmaster.opts > > > > On 29-Mar-2002 Bruce Momjian wrote: > > > > That file is not for user changes. It gets written on every postmaster > > restart. Either change these in postgresql.conf or on the command line. > > > > The "postgresql.conf" file doesn't exist in RedHat. :( > But "/var/lib/pgsql/data/pg_options" file exists. It contains: > verbose=2 > query=2 > syslog=0 > > Do I have to change the settings in this file? > > Bye! > ----------------- > Linux RedHat 7.1 > ----------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >