trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist

From: cesar <cesarkrall(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist
Date: 2014-12-30 20:42:15
Message-ID: 1419972135188-5832477.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-does-not-exist-tp5832477.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Paquier 2015-01-01 07:17:35 Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist
Previous Message Tom Lane 2014-12-23 20:27:41 Re: Excessive memory used for INSERT