Thread: log_statement at postgres.conf

log_statement at postgres.conf

From
"System/IJS - Joko"
Date:
Dear all,
 
After setting log_statement='all' at postgres.conf,
then i'm rebooting OS [freeBSD or CentOS],
i can't find where log file created from log_statement='all' located...
FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
 
many thanks..
 
Regards,
Joko [SYSTEM]
PT. Indra Jaya Swastika
Phone: +62 31 7481388  Ext 201
http://www.ijs.co.id

--
If you have any problem with our services ,
please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388

Re: log_statement at postgres.conf

From
Achilleas Mantzios
Date:
Στις Thursday 17 July 2008 11:43:28 ο/η System/IJS - Joko έγραψε:
> Dear all,
>
> After setting log_statement='all' at postgres.conf,
> then i'm rebooting OS [freeBSD or CentOS],
> i can't find where log file created from log_statement='all' located...
> FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
>
it is the log_destination variable which dictates that.
> many thanks..
>
> Regards,
> Joko [SYSTEM]
> PT. Indra Jaya Swastika
> Phone: +62 31 7481388  Ext 201
> http://www.ijs.co.id
>
> --
> If you have any problem with our services ,
> please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
> PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388
>



--
Achilleas Mantzios

Re: log_statement at postgres.conf

From
Rex Mabry
Date:

Inside the database, you can query the pg_settings table.

 

select * from pg_catalog.pg_settings where name = 'log_directory';

 

To see other stuff you can get from that table, try:

 

select name from pg_catalog.pg_settings;

--- On Thu, 7/17/08, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:

From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Subject: Re: [ADMIN] log_statement at postgres.conf
To: pgsql-admin@postgresql.org, "System/IJS - Joko" <system@ijs.co.id>
Date: Thursday, July 17, 2008, 4:51 AM

Στις Thursday 17 July 2008 11:43:28 ο/η System/IJS - Joko έγραψε:
> Dear all,
> 
> After setting log_statement='all' at postgres.conf,
> then i'm rebooting OS [freeBSD or CentOS],
> i can't find where log file created from log_statement='all'
located...
> FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
> 
it is the log_destination variable which dictates that.
> many thanks..
> 
> Regards,
> Joko [SYSTEM]
> PT. Indra Jaya Swastika
> Phone: +62 31 7481388  Ext 201
> http://www.ijs.co.id
> 
> --
> If you have any problem with our services ,
> please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
> PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388
> 



-- 
Achilleas Mantzios

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin