Обсуждение: Pls. help me to clarify my doubts.

hi,

Sir, i follow your procedure of Postgres installation (version 7.1.3) on linux 2.4.7-10.

I want to know how to enable syslog and mention the log information will store in /var/postgreslog directory path..

Then, give me the complete information & steps for installtion of postgres 7.1.3 and enable logs.

I need this logs will contains the all errors will stores. This logs just like a alertlog in oracle.

Kindly, give me this details as soonly,

Regards,
arumugam.

> hi,
>
> Sir, i follow your procedure of Postgres installation (version 7.1.3)
> on linux 2.4.7-10.
>
> I want to know how to enable syslog and mention the log information
> will store in /var/postgreslog directory path..

not sure abt 7.1.3 , but  in 7.3.3 u can do the following.

In postgresql.conf file

#
#       Syslog
#
syslog = 2                     # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'


in /etc/syslog.conf file
local0.*   /var/postgreslog

note that this will put *all* the messages from all applications
using local0 facility to /var/postgreslog

regds
mallah.



>
> Then, give me the complete information & steps for installtion of
> postgres 7.1.3 and enable logs.
>
> I need this logs will contains the all errors will stores. This logs
> just like a alertlog in oracle.
>
> Kindly, give me this details as soonly,
>
> Regards,
> arumugam.



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/

<mallah@trade-india.com> wrote:
> > hi,
> >
> > Sir, i follow your procedure of Postgres installation (version 7.1.3)
> > on linux 2.4.7-10.
> >
> > I want to know how to enable syslog and mention the log information
> > will store in /var/postgreslog directory path..
>
> not sure abt 7.1.3 , but  in 7.3.3 u can do the following.
>
> In postgresql.conf file
>
> #
> #       Syslog
> #
> syslog = 2                     # range 0-2
> syslog_facility = 'LOCAL0'
> syslog_ident = 'postgres'
>
>
> in /etc/syslog.conf file
> local0.*   /var/postgreslog

I remember you also that you can turn off the syslog to fsync each
log to the file putting a "-" before the filename:

local0.*   -/var/postgreslog

this should increase the log performances



Regards
Gaetano Mendola

Gaetano Mendola wrote:

><mallah@trade-india.com> wrote:
>
>
>>>hi,
>>>
>>>Sir, i follow your procedure of Postgres installation (version 7.1.3)
>>>on linux 2.4.7-10.
>>>
>>>I want to know how to enable syslog and mention the log information
>>>will store in /var/postgreslog directory path..
>>>
>>>
>>not sure abt 7.1.3 , but  in 7.3.3 u can do the following.
>>
>>In postgresql.conf file
>>
>>#
>>#       Syslog
>>#
>>syslog = 2                     # range 0-2
>>syslog_facility = 'LOCAL0'
>>syslog_ident = 'postgres'
>>
>>
>>in /etc/syslog.conf file
>>local0.*   /var/postgreslog
>>
>>
>
>I remember you also that you can turn off the syslog to fsync each
>log to the file putting a "-" before the filename:
>
>local0.*   -/var/postgreslog
>
>this should increase the log performances
>
>
>
But doesnt this mean that you could loose log data in case of a power
failure?