Re: Resolved: Setting postmaster "-i" on RH7.1, Pg7.1, Used postgresql.conf

[Wayne B. <wb...@co...>]

Jeff,

I had to add the -i flag to postmaster.opts.default to get it to work. I
looked at pg_ctl and found the following:

# if we are in start mode, then look for postmaster.opts.default

# if we are in restart mode, then look for postmaster.opts

My postmaster.opts files look like this:

root@oldhome:/usr/local/pgsql/data# more postmaster.opts*
::::::::::::::
postmaster.opts
::::::::::::::
/usr/local/pgsql/bin/postmaster '-D' '/usr/local/pgsql/data' '-i' '-D'
'/usr/local/pgsql/data'
::::::::::::::
postmaster.opts.default
::::::::::::::
/usr/local/pgsql/bin/postmaster '-i' '-D' '/usr/local/pgsql/data'

Maybe this is worth a try.
Wayne

Jeff Kowalczyk wrote:
> 
> First, off thanks to everyone who helped me hash out my PostgreSQL '-i'
> problems. The various postmaster.opts methods would not work under any
> number of syntaxes.
> 
> It turned out that the way (and a simple one at that) to get postmaster
> listening on 5432 with my RH7.1/Pg7.1 combination was to use the
> postgresql.conf option "tcpip_socket=true". That accomplished the same
> thing as '-i'. I don't know if the .conf file is a relatively new idiom
> to postgres, as most of the docs don't refer to it.
> 
> One for the FAQ, I guess.