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. Everything works fine till the creation of a replica database 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. Notably, if you have nodes which are reached via different DSNs from different locations, then the conn_info value may not be correct. In addition, this script will happily create .conf files for nodes which it found missing. If you wanted nodes to be controlled from some other host, this could draw them in to the local host, which would not be what you wanted. In most cases, this would only cause minor inconvenience; if you are running log shipping against a particular remote subscriber, this could cause you some real heartburn... --------------------------------------------------------------------- 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. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
