Skip to content

Instantly share code, notes, and snippets.

@wyukawa
Last active August 29, 2015 14:10
Show Gist options
  • Select an option

  • Save wyukawa/c320b6c12189a2df2166 to your computer and use it in GitHub Desktop.

Select an option

Save wyukawa/c320b6c12189a2df2166 to your computer and use it in GitHub Desktop.
prestogres 5.5 + postgresql 9.2 + cognos 10.2.2(32bit)
$ sudo prestogres-ctl pgpool
/usr/local/bin/prestogres-pgpool -n
...
2014-12-04 14:37:34: pid 106236: LOG: perhaps failed to create INET domain socket
2014-12-04 14:37:34: pid 106236: DETAIL: socket(::) failed: "Address family not supported by protocol"
2014-12-04 14:37:34: pid 106236: LOG: prestogres successfully started. version 0.5.5 (tataraboshi)
2014-12-04 14:53:47: pid 106262: LOG: statement: set datestyle = 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end
2014-12-04 14:53:49: pid 106262: LOG: statement: begin; set autocommit = on; set client_encoding = 'UTF8'; SET extra_float_digits=3; commit
2014-12-04 14:53:49: pid 106262: LOG: statement: select current_setting('standard_conforming_strings')
2014-12-04 14:53:49: pid 106262: LOG: statement: BEGIN;SELECT t.typlen FROM pg_catalog.pg_type t, pg_catalog.pg_namespace n WHERE t.typnamespace=n.oid AND t.typname='name' AND n.nspname='pg_catalog'
2014-12-04 14:53:49: pid 106262: ERROR: unable to read data from frontend
2014-12-04 14:53:49: pid 106262: DETAIL: EOF read on socket
2014-12-04 14:53:49: pid 106262: LOG: child exiting, 1 connections reached
2014-12-04 14:54:40: pid 106254: LOG: statement: set datestyle = 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end
2014-12-04 14:54:42: pid 106254: LOG: statement: begin; set autocommit = on; set client_encoding = 'UTF8'; SET extra_float_digits=3; commit
2014-12-04 14:54:42: pid 106254: LOG: statement: select current_setting('standard_conforming_strings')
2014-12-04 14:54:42: pid 106270: LOG: statement: set datestyle = 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end
2014-12-04 14:54:43: pid 106270: LOG: statement: begin; set autocommit = on; set client_encoding = 'UTF8'; SET extra_float_digits=3; commit
2014-12-04 14:54:43: pid 106270: LOG: statement: select current_setting('standard_conforming_strings')
2014-12-04 14:54:43: pid 106270: LOG: statement: BEGIN;SELECT nspname AS TABLE_SCHEM , NULL AS TABLE_CATALOG FROM pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~ '^pg_temp_' OR nspname = (pg_catalog.current_schemas(true))[1]) AND (nspname !~ '^pg_toast_temp_' OR nspname = replace((pg_catalog.current_schemas(true))[1], 'pg_temp_', 'pg_toast_temp_')) ORDER BY TABLE_SCHEM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment