Prachi Pandey prachip at cdacb.ernet.in
Wed Mar 10 03:19:09 PST 2010
Hi,

I am using PostgreSQL 8.3.1 and I want to create a replica of my database.
For doing this I have installed slony1-2.0.2 and am trying to replicate the
pgbench database following the instructions given in the Slony-I 2.0.3_RC2
Documentation.
A replica database is created successfully along with the tables , but for
copying the data and synchronizing it with the replica, when i run the shell
script meant for generating a set of slon.conf files, it gives an error as
below:


bash-3.1$ ./mkslonconf.sh 
building slon config files in /usr/local/slony-I/pgbench
Make sure /usr/local/slony-I/pgbench/conf, /usr/local/slony-I/pgbench/pid
exist
ERROR:  schema "_pgbench" does not exist
---------------------------------------------------------------------
Be sure to review .conf files created in
/usr/local/slony-I/pgbench/conf to ensure they are reasonable
before starting up slons against them.  Customize as needed.

...........................................
...........................................



Can anyone please tell me what the problem is and how can i go about
configuring the database for replication.


Thanks,
Prachi
-- 
View this message in context: http://old.nabble.com/Error-while-configuring-pgbench-database-for-replication-using-slony1-2.0.2-tp27847706p27847706.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.



More information about the Slony1-general mailing list