|
Home > Archive > Slony1 PostgreSQL Replication > July 2005 > pgbench error : "branches" does not exist
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
pgbench error : "branches" does not exist
|
|
| Shashi Kanth Boddula 2005-07-28, 3:24 am |
| Hi,
I am using PostgreSQL 7.4.6 on SuSE Linux . I installed slony-1
successfully . I am going through the slony-1 documentation step-by-step
.. In the documentation , in the Replicating your first database section
, i am facing one problem . I followed all the steps , but when i
issued the given bellow command , i got an error .
postgres@postgresql1
:~> pgbench -s 1 -c 5 -t 1000 -U pgbench -h
localhost pgbench
ERROR: relation branches does
not exist
Please , anybody tell me what is the cause for this problem.
Thanks
Shashi Kanth
Consultant - Linux
RHCE , LPIC-2
Onward Novell - Bangalore
9886455567
| |
| Christopher Browne 2005-07-28, 9:25 am |
| Shashi Kanth Boddula wrote:
> Hi,
>
> I am using PostgreSQL 7.4.6 on SuSE Linux . I installed slony-1
> successfully . I am going through the slony-1 documentation
> step-by-step . In the documentation , in the "Replicating your first
> database " section , i am facing one problem . I followed all the
> steps , but when i issued the given bellow command , i got an error .
>
> *postgres@postgresql
1:~> pgbench -s 1 -c 5 -t 1000 -U pgbench -h
> localhost pgbench *
>
> * *
>
> * ERROR: relation "branches"
> does not exist *
>
> Please , anybody tell me what is the cause for this problem.
>
It seems to me that you probably didn't follow all of the steps.
One of the *earlier* steps involved running:
pgbench -i -s 1 -U $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME
That is required to set up the pgbench tables.
| |
| Shashi Kanth Boddula 2005-07-28, 9:25 am |
| Yes . I forgot to execute that command . Thank you Christopher .
<42E8ED9C.8070702-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org>, Christopher Browne
<cbbrowne-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org> wrote:
Shashi Kanth Boddula wrote:
[color=darkred]
> Hi,
>
> I am using PostgreSQL 7.4.6 on SuSE Linux . I installed slony-1
> successfully . I am going through the slony-1 documentation
> step-by-step . In the documentation , in the Replicating your first
> database section , i am facing one problem . I followed all the
> steps , but when i issued the given bellow command , i got an error .
>
> *postgres@postgresql
1:~> pgbench -s 1 -c 5 -t 1000 -U pgbench -h
> localhost pgbench *
>
> * *
>
> * ERROR: relation branches
> does not exist *
>
> Please , anybody tell me what is the cause for this problem.
>
It seems to me that you probably didn't follow all of the steps.
One of the *earlier* steps involved running:
pgbench -i -s 1 -U $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME
That is required to set up the pgbench tables.
|
|
|
|
|