Vivek Khera vivek
Thu Sep 16 20:29:51 PDT 2004
I was trying to get up the basic example working, but cut/paste failed 
me for the "create" commands since my personal ID is not a superuser.  
Below patch makes it work since REPLICATIONUSER must be a superuser.


Vivek Khera, Ph.D.
+1-301-869-4449 x806



diff -u -r1.15 slony-I-basic-mstr-slv.txt
--- slony-I-basic-mstr-slv.txt  27 Jul 2004 18:27:59 -0000      1.15
+++ slony-I-basic-mstr-slv.txt  16 Sep 2004 19:23:30 -0000
@@ -37,12 +37,12 @@

  Creating the pgbenchuser

-createuser -A -D $PGBENCHUSER
+createuser -U $REPLICATIONUSER -A -D $PGBENCHUSER

  Preparing the databases

-createdb -O $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME
-createdb -O $PGBENCHUSER -h $SLAVEHOST $SLAVEDBNAME
+createdb -U $REPLICATIONUSER -O $PGBENCHUSER -h $MASTERHOST 
$MASTERDBNAME
+createdb -U $REPLICATIONUSER -O $PGBENCHUSER -h $SLAVEHOST $SLAVEDBNAME

  pgbench -i -s 1 -U $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME

@@ -51,7 +51,7 @@
  installed pl/pgSQL into the template1 database in which case you can 
skip this
  step because it's already installed into the $MASTERDBNAME.

-createlang -h $MASTERHOST plpgsql $MASTERDBNAME
+createlang -U $REPLICATIONUSER -h $MASTERHOST plpgsql $MASTERDBNAME

  Slony-I does not yet automatically copy table definitions from a 
master when a
  slave subscribes to it, so we need to import this data.  We do this 
with
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2476 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20040916/f36e3be9/smime.bin


More information about the Slony1-general mailing list