Thu Sep 16 20:29:51 PDT 2004
- Previous message: [Slony1-general] Slony-I: Table name is replicated and cannot be modified on a subscriber node .....Y this message appears ???
- Next message: [Slony1-general] Arguements for altperl scripts
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony-I: Table name is replicated and cannot be modified on a subscriber node .....Y this message appears ???
- Next message: [Slony1-general] Arguements for altperl scripts
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list