Re: Require Assistance Solving Problem - erroneous pg_hba - Mailing list pgsql-admin

From Murthy Kambhampaty
Subject Re: Require Assistance Solving Problem - erroneous pg_hba
Date
Msg-id 2D92FEBFD3BE1346A6C397223A8DD3FC0921ED@THOR.goeci.com
Whole thread Raw
List pgsql-admin
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.)


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Require Assistance Solving Problem - erroneous pg_hba.conf
Next
From: Tom Lane
Date:
Subject: Re: Require Assistance Solving Problem - erroneous pg_hba.conf