|
|
 | | From: | Kevin B. | | Subject: | postgresql log file on fc2 | | Date: | Thu, 20 Jan 2005 11:00:43 -0500 (EST) |
|
|
 | 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
|
|
| | From: | Sean Davis | | Subject: | Re: postgresql log file on fc2 | | Date: | Thu, 20 Jan 2005 11:18:31 -0500 |
|
|
| 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
|
