frank church <[EMAIL PROTECTED]> 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
