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 <[EMAIL PROTECTED]> wrote: From: Achilleas Mantzios <[EMAIL PROTECTED]> Subject: Re: [ADMIN] log_statement at postgres.conf To: pgsql-admin@postgresql.org, "System/IJS - Joko" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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
