View Single Post

   
  #3 (permalink)  
Old 04-09-2008, 07:13 AM
Jerry Sievers
 
Posts: n/a
Default Re: How to check options PostgreSQL was started with

frank church <pgsql@adontendev.net> writes:

> How do you check the options a PosgreSQL service was started with?


If you're wanting to know if postmaster was started with any command
line args, such as an admin might do on a ad hoc basis from pg_ctl
etc;

cat $PGDATA/postmaster.opts

If you do a simple 'pg_ctl start' all you'll get is the path to the
postmaster or postgres executable. OTOH, 'pg_ctl -o-F start' and the
path plus your -F option will show up there.

HTH

--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobile http://www.JerrySievers.com/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote