Thread: -F option again
I think I have been using -F option since but now I'm not sure. I either start with pg_ctl or postmaster directly. In any case man pages suggest that if you can pass optional parameters to postgres via -o switch from postmaster. I would think that if I do it correctly such options will show up on postgres backend processes. I do not see such options from top. Below I present to you relevant snippet of my top output. I've made sure there is no trailing command line being cut off due to screen size limitations. Why do not I see "postgres -F"? ------------------------- 4:44pm up 11 days, 9:12, 1 user, load average: 0.00, 0.00, 0.00 84 processes: 83 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 0.8% user, 1.7% system, 0.0% nice, 97.3% idle Mem: 385032K av, 339060K used, 45972K free, 0K shrd, 2152K buff Swap: 136512K av, 7640K used, 128872K free 100956K cached PID PRI SIZE RSS SHARE TIME COMMAND 1239 15 900 900 684 0:01 top 14287 15 740 624 548 5:55 /usr/local/pgsql/bin/postmaster -o -F -S 2048 20221 9 5048 4988 4516 0:06 /usr/local/pgsql/bin/postgres localhost httpd what idle
newsreader@mediaone.net wrote: > > I think I have been using -F option since > but now I'm not sure. I either start > with pg_ctl or postmaster directly. In any case > man pages suggest that if you can pass optional parameters > to postgres via -o switch from postmaster. I would > think that if I do it correctly such options will > show up on postgres backend processes. I do not > see such options from top. Below I present > to you relevant snippet of my top output. I've > made sure there is no trailing command line being > cut off due to screen size limitations. > > Why do not I see "postgres -F"? Because postgres modifies its arguments so you can tell what it is doing with ps. For example your postmaster is connected to a client on the localhost user httpd database what and is doing nothing at the moment. > > ------------------------- > 4:44pm up 11 days, 9:12, 1 user, load average: 0.00, 0.00, 0.00 > 84 processes: 83 sleeping, 1 running, 0 zombie, 0 stopped > CPU states: 0.8% user, 1.7% system, 0.0% nice, 97.3% idle > Mem: 385032K av, 339060K used, 45972K free, 0K shrd, 2152K buff > Swap: 136512K av, 7640K used, 128872K free 100956K cached > > PID PRI SIZE RSS SHARE TIME COMMAND > 1239 15 900 900 684 0:01 top > 14287 15 740 624 548 5:55 /usr/local/pgsql/bin/postmaster -o -F -S 2048 > 20221 9 5048 4988 4516 0:06 /usr/local/pgsql/bin/postgres localhost httpd what idle > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com