pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
log_statement at postgres.conf 3+ messages / 3 participants [nested] [flat]
* log_statement at postgres.conf @ 2008-07-17 08:43 System/IJS - Joko <system@ijs.co.id> 2008-07-17 09:51 ` Re: log_statement at postgres.conf Achilleas Mantzios <achill@matrix.gatewaynet.com> 0 siblings, 1 reply; 3+ messages in thread From: System/IJS - Joko @ 2008-07-17 08:43 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: log_statement at postgres.conf 2008-07-17 08:43 log_statement at postgres.conf System/IJS - Joko <system@ijs.co.id> @ 2008-07-17 09:51 ` Achilleas Mantzios <achill@matrix.gatewaynet.com> 2008-07-17 13:33 ` Re: log_statement at postgres.conf Rex Mabry <rexmabry@yahoo.com> 0 siblings, 1 reply; 3+ messages in thread From: Achilleas Mantzios @ 2008-07-17 09:51 UTC (permalink / raw) To: pgsql-admin@postgresql.org, "System/IJS - Joko" <system@ijs.co.id> Στις 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: log_statement at postgres.conf 2008-07-17 08:43 log_statement at postgres.conf System/IJS - Joko <system@ijs.co.id> 2008-07-17 09:51 ` Re: log_statement at postgres.conf Achilleas Mantzios <achill@matrix.gatewaynet.com> @ 2008-07-17 13:33 ` Rex Mabry <rexmabry@yahoo.com> 0 siblings, 0 replies; 3+ messages in thread From: Rex Mabry @ 2008-07-17 13:33 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-07-17 13:33 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-07-17 08:43 log_statement at postgres.conf System/IJS - Joko <system@ijs.co.id> 2008-07-17 09:51 ` Achilleas Mantzios <achill@matrix.gatewaynet.com> 2008-07-17 13:33 ` Rex Mabry <rexmabry@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox