Hiroyuki Sato
null+****@clear*****
Wed Dec 23 20:39:03 JST 2015
Hiroyuki Sato 2015-12-23 20:39:03 +0900 (Wed, 23 Dec 2015) New Revision: 22867bc4f56eeabaf9f666ae6157b87b2524cc81 https://github.com/pgroonga/pgroonga.github.io/commit/22867bc4f56eeabaf9f666ae6157b87b2524cc81 Merged baeebc9: Merge pull request #8 from hiroyuki-sato/doc Message: Add setting parameters in English Added files: reference/parameters/lock_timeout.md reference/parameters/log_level.md reference/parameters/log_path.md reference/parameters/log_type.md Modified files: reference/index.md Modified: reference/index.md (+9 -0) =================================================================== --- reference/index.md 2015-12-18 17:18:17 +0900 (dd25a0c) +++ reference/index.md 2015-12-23 20:39:03 +0900 (9f94e71) @@ -39,3 +39,12 @@ This document describes about all features. [Tutorial](../tutorial/) focuses on * [`pgroonga.table_name` function](functions/pgroonga-table-name.html) +## Setting Parameters + + * [`pgroonga.log_type`](parameters/log_type.html) + + * [`pgroonga.log_path`](parameters/log_path.html) + + * [`pgroonga.log_level`](parameters/log_level.html) + + * [`pgroonga.lock_timeout`](parameters/lock_timeout.html) Added: reference/parameters/lock_timeout.md (+18 -0) 100644 =================================================================== --- /dev/null +++ reference/parameters/lock_timeout.md 2015-12-23 20:39:03 +0900 (55465cc) @@ -0,0 +1,18 @@ +--- +title: "pgroonga.lock_timeout" +layout: en +--- + +# `pgroonga.lock_timeout` parameter. + +## Description + +Set lock timeout value. A query will wait for ``timeout`` value until another query to release the lock. + +## Syntax + +```sql +set pgroonga.lock_timeout = timeout +``` + +`timeout` is lock timeout value。Unit is milliseconds。Default value is `10000000`. Added: reference/parameters/log_level.md (+29 -0) 100644 =================================================================== --- /dev/null +++ reference/parameters/log_level.md 2015-12-23 20:39:03 +0900 (31af1c4) @@ -0,0 +1,29 @@ +--- +title: "pgroonga.log_level" +layout: en +--- + +# `pgroonga.log_level` parameter. + +## Description + +Change logging level. + +## Syntax + +```sql +set pgroonga.log_level = level +``` + +`level` is logging level. Following levels are available. Log levels follow are listed in the order of increasing severity. Default log_level is `notice`. + +* none +* emergency +* alert +* critical +* error +* warning +* notice +* info +* debug +* dump Added: reference/parameters/log_path.md (+18 -0) 100644 =================================================================== --- /dev/null +++ reference/parameters/log_path.md 2015-12-23 20:39:03 +0900 (9248c02) @@ -0,0 +1,18 @@ +--- +title: "pgroonga.log_path" +layout: en +--- + +# `pgroonga.log_path` parameter + +## Description + +Change output log file path. This parameter is only effective if log_type is ``file``. + +## Syntax + +```sql +set pgroonga.log_path = path +``` + +`path` is log file path.Default value is ``$PGDATA/pgroonga.log`. Added: reference/parameters/log_type.md (+51 -0) 100644 =================================================================== --- /dev/null +++ reference/parameters/log_type.md 2015-12-23 20:39:03 +0900 (6e88fd7) @@ -0,0 +1,51 @@ +--- +title: "pgroonga.log_type" +layout: en +--- + +# `pgroonga.log_type` parameter + +## Description + +Change log output type. Effective type are File, Windows event log and PostgreSQL log. + +## Syntax + +```sql +set pgroonga.log_type = type +``` + +`type` is logging type. Following parameters are available. Default value is `file`. + +* file: File ouput +* windows_event_log: Windows event log +* postgresql: PostgreSQL logging. + +### About `windows_event_log` + +Following command change log output to Windows event log. + +``` +SET pgroonga.log_type = 'windows_event_log'; +``` + +You can change log_type to windows event with only this command, But it record many warnings, +so It is hard to check with Event viewer. + +If you create ``PGroonga`` event via command prompt, You can filter warning message. This is recommendation setting when you use Windows event logging. + +``` +> regsvr32 /n /i:PGroonga ${PostgreSQL install folder}\lib\pgevent.dll +``` + +This is same step when you regsiter PostgreSQL event log on Windows. Note: [Registering Event Log on Windows](http://www.postgresql.org/docs/9.3/static/event-log-registration.html) + +### postgresql.conf syntax + +If you set this value log_type permanently, you can write postgresql.conf as follows. + +``` +pgroonga.log_type = 'windows_event_log'; +``` + +You need reload PostgreSQL. -------------- next part -------------- HTML����������������������������... Download