postgresql startup script

[Andrew Perrin <aperrin@socrates.berkeley.edu>]

Could some kind soul help out with this? I built postgres from source
instead of using the .deb, and all works fine except for having it start
on bootup.  I'm stuck on trying to get the startup script to run as user
'postgres' instead of as root.  I tried to have it issue the command:

su postgres '/usr/local/pgsql/bin/pg_ctl -w -D/var/lib/postgres/data -o
"-i" start'

but no dice there.

Thanks for any help.

----------------------------------------------------------------------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology  
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
        aperrin@socrates.berkeley.edu - aperrin@igc.apc.org