The following bug has been logged on the website:
Bug reference: 14580
Logged by: Stepan Pesternikov
Email address: spesternikov@gmail.com
PostgreSQL version: 9.6.2
Operating system: Linux
Description:
Bug in pgbench with option --builtin
Environment:
RDBMS
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-11), 64-bit
Operating system
[root@kiselev ~]# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)
After start pgbench
-bash-4.2$ /usr/pgsql-9.6/bin/pgbench --host=localhost --username=postgres
--transactions=1000 --client=100 --jobs=10 -b tpcb-like@0
--builtin=select-only@0 --no-vacuum
--file=/var/lib/pgsql/9.6/pgbench_test.sql postgres
occur error:
/usr/pgsql-9.6/bin/pgbench: unrecognized option '--builtin=select-only@0'
If use option '-b select-only@0', error doesn't occur.
Solution:
Preparing:
$ git clone git://git.postgresql.org/git/postgresql.git
$ git checkout remotes/origin/REL9_6_STABLE
In file 'src/bin/pgbench/pgbench.c' replace string
{"tpc-b", no_argument, NULL, 'b'}
the string
{"builtin", required_argument, NULL, 'b'}
Then './configure', 'make', 'make check', 'make install'
Option '--builtin=select-only@0' works correctly.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs