pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: cesar <cesarkrall@gmail.com>
To: pgsql-performance@postgresql.org
Subject: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist
Date: Tue, 30 Dec 2014 13:42:15 -0700 (MST)
Message-ID: <1419972135188-5832477.post@n5.nabble.com> (raw)
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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



view thread (3+ messages)  latest in thread

Message-ID: <1419972135188-5832477.post@n5.nabble.com>
Permalink:  ../1419972135188-5832477.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1419972135188-5832477.post@n5.nabble.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: cesarkrall@gmail.com
  Subject: Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist
  In-Reply-To: <1419972135188-5832477.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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