Thread: Re: Require Assistance Solving Problem - erroneous pg_hba

Re: Require Assistance Solving Problem - erroneous pg_hba

From
Murthy Kambhampaty
Date:
Greg Kelley [mailto:gkelley@britannicaviation.com] writes:
[snip]
>... Postmaster starts with:
>
>su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
>/usr/bin/postmaster -o '-i -p ${PGPORT}' start  > /var/log/pgsql 2>&1" <
>/dev/null
you might want to change your start line to
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p \
    /usr/bin/postmaster -o '-i -p ${PGPORT}' start  >> /var/log/pgsql \
    2>&1" </dev/null

note the >> /var/log/pgsql, which appends to the file -- creating it if
necessary -- rather than replacing it each time you start the postmaster, as
it is now set to do. See, the Advanced Bash Scripting Guide, particularly
http://www.tldp.org/LDP/abs/html/io-redirection.html
on this.

(Server log rotation is a topic continually discussed on this list; you
might want to look into it.)