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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux