i have 2 postgresql boxes, one live and one for dev.
the dev box has postgresql 7.2 compiled from source and ps auxf gets me a
postmaster process and then the db parameters (-i -B 512 etc).
the live box has 7.2 from deb packages and i have edited postgresql.conf to
give the same start parameters as the dev box but on ps auxf i don't get any
extra info ...
is there a way i check to see if postgresql started with the options i want
and not the defaults ?
performance seems ok but i'm worried that the live box may not have started
properly ....
live box:
postgres 320 0.0 0.3 16784 1780 ? S Jul15 0:13
/usr/lib/postgresql/bin/postmaster
postgres 322 0.0 0.5 17776 2748 ? S Jul15 0:02 \_ postgres:
stats buffer process
postgres 323 0.0 0.3 16856 1836 ? S Jul15 0:10 \_
postgres: stats collector process
thanks,
Steve Brett
p..s i totally agree with the previous thread that was extolling the virtues
of postgresql and especially the amazing support.
keep it up guys !