Обсуждение: postgresql log file on fc2

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

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