On MacOS, I do:
postmaster -D /usr/local/pgsql/data >& /usr/local/pgsql/data/server_log
&
This puts logging output in the server_log file in
/usr/local/pgsql/data. Since this directory belongs to the postgres
user, it seems convenient.
Sean
On Jan 20, 2005, at 11:00 AM, Kevin B. wrote:
> Hi,
>
> I am looking for the postgres log file on a stock install of fc2
> (postgres
> 7.4 was installed from the fc2 CDs.) I see that there is a file named
> pgsql in /var/log but it is 0 bytes. My guess is that I need to turn
> logging on. Does someone know if /var/log/pgsql on fc2 is used for
> logging or something else? In other words, can I start postgres with
> -l
> /var/log/pgsql for logging or should I log to a differnt file?
>
> Thanks,
> Kevin
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
> joining column's datatypes do not match
