pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist 3+ messages / 2 participants [nested] [flat]
* trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist @ 2014-12-30 20:42 cesar <cesarkrall@gmail.com> 2015-01-01 07:17 ` Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist Michael Paquier <michael.paquier@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: cesar @ 2014-12-30 20:42 UTC (permalink / raw) To: pgsql-performance Hello, I´ve installed postgresql 9.1 on ubuntu 12.04 with pgpoolII-3.3.3 and pgPoolAdmin. I´m trying to make a test with pgbench-tools to measure the performance of postgresql. So I move to the directory where is pgbench-tools and configure the config file. I try to execute this order: sudo -u postgres ./runset After this it appears a message "Removing old pgbench tables" First error message (seems not to be important) is: ERROR: table "accounts does not exist" After this it appears a message: VACUUM creating new pgbench tables After this creating tables 10000 tuples done 20000 tuples done ... 100000 tuples done ... vacuum...done. Run set #1 of 2 with 2 clients scale=1 Running tests using: psql -h localhost -U postgres -p 5432 pgbench Storing results using: psql -h localhost -U postgres -p 5432 pgbench And after this it comes "the crash": ERROR: relation "branches" does not exist LINE 1: select count(*) for branches ERROR: Attempt to determine database scale returned "", aborting it´s maybe and stupid issue and I´m not being able to solve it as i don´t have a high level of knowledge on those systems. Any idea about what to try? -- View this message in context: http://postgresql.nabble.com/trying-to-run-pgbench-tools-postgresql-ubuntu-ERROR-relation-branches-d... Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist 2014-12-30 20:42 trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist cesar <cesarkrall@gmail.com> @ 2015-01-01 07:17 ` Michael Paquier <michael.paquier@gmail.com> 2015-01-01 20:45 ` Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist cesar <cesarkrall@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: Michael Paquier @ 2015-01-01 07:17 UTC (permalink / raw) To: cesar <cesarkrall@gmail.com>; +Cc: pgsql-performance On Wed, Dec 31, 2014 at 5:42 AM, cesar <cesarkrall@gmail.com> wrote: > After this it appears a message "Removing old pgbench tables" > First error message (seems not to be important) is: ERROR: table "accounts > does not exist" > ERROR: relation "branches" does not exist > LINE 1: select count(*) for branches > ERROR: Attempt to determine database scale returned "", aborting The tables "accounts" and "branches" refer to the table names in pgbench shipped with Postgres 8.3 and older. It has been changed to pgbench_* after that. So it seems that you are facing a version mismatch if this script uses pgbench 9.1. > Any idea about what to try? Discussing this issue with the maintainers of pgbench-tools may be a good thing as well: https://github.com/gregs1104/pgbench-tools/ Regards, -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist 2014-12-30 20:42 trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist cesar <cesarkrall@gmail.com> 2015-01-01 07:17 ` Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist Michael Paquier <michael.paquier@gmail.com> @ 2015-01-01 20:45 ` cesar <cesarkrall@gmail.com> 0 siblings, 0 replies; 3+ messages in thread From: cesar @ 2015-01-01 20:45 UTC (permalink / raw) To: pgsql-performance You´ve been very helpful for me. Solved after downloading pgbench tools from github https://github.com/gregs1104/pgbench-tools, it seems like I was using an old version of pgbench-tools. Thanks for your help! -- View this message in context: http://postgresql.nabble.com/trying-to-run-pgbench-tools-postgresql-ubuntu-ERROR-relation-branches-d... Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-01-01 20:45 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-12-30 20:42 trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist cesar <cesarkrall@gmail.com> 2015-01-01 07:17 ` Michael Paquier <michael.paquier@gmail.com> 2015-01-01 20:45 ` cesar <cesarkrall@gmail.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