|
|
| Marcin Mañk 2006-04-07, 8:26 pm |
| Hello.
The general policy for slony is 'no ddl should be performed on replicated
databases'. Does this apply to temporary tables too? Can I safely create
temporary tables on the master/on the slaves ?
Cheers
Marcin
| |
| Scott Marlowe 2006-04-07, 8:26 pm |
| T24gRnJpLCAyMDA2LTA0
LTA3IGF0IDA4OjMzLCBN
YXJjaW4gTWHFhGsgd3Jv
dGU6Cj4gSGVsbG8u
Cj4gVGhlIGdlbmVyYWwg
cG9saWN5IGZvciBzbG9u
eSBpcyAnbm8gZGRsIHNo
b3VsZCBiZSBwZXJm
b3JtZWQgb24gcmVwbGlj
YXRlZAo+IGRhdGFiYXNl
cycuIERvZXMgdGhpcyBh
cHBseSB0byB0ZW1w
b3JhcnkgdGFibGVzIHRv
bz8gQ2FuIEkgc2FmZWx5
IGNyZWF0ZQo+IHRlbXBv
cmFyeSB0YWJsZXMg
b24gdGhlIG1hc3Rlci9v
biB0aGUgc2xhdmVzID8K
ClNsb255IGRvZXNuJ3Qg
cmVwbGljYXRlIGRh
dGFiYXNlcy4gIEl0IHJl
cGxpY2F0ZXMgZGF0YSBz
ZXRzIG9uCmRhdGFiYXNl
cy4gIFNvLCBhcyBs
b25nIGFzIHdoYXQgeW91
J3JlIG11Y2tpbmcgYWJv
dXQgd2l0aCBpc24ndCBp
biB0aGUKcmVwbGlj
YXRpb24gc2V0LCB5b3Un
cmUgY29vbC4KCk5vdGUg
dGhhdCBzaW5jZSBpbmRl
eGVzIGxpdmUgb3V0
c2lkZSBvZiB0YWJsZXMs
IGl0J3MgcXVpdGUgcG9z
c2libGUgdG8KaGF2ZSBh
IHNvdXJjZSBzZXQg
d2l0aCB0aGUgYmFyZSBu
ZWVkZWQgaW5kZXhlcyBm
b3IgZGF0YSBjb2hlcmVu
Y3ksIGFuZCBhCnN1
YnNjcmliZXIgd2l0aCBl
eHRyYSBpbmRleGVzIG9u
IHRoaW5ncyBsaWtlIGZ1
bmN0aW9ucyBhbmQg
c3VjaCAoY2FyZWZ1bAp3
aXRoIHVuaXF1ZSBpbmRl
eGVzLCB5b3UgY2FuIG1h
a2UgYSBzdWJzY3Jp
YmVyIHRoYW4gY2FuJ3Qg
dXBkYXRlKSB0aGF0CmFs
bG93IGZvciBmYXN0IHJl
cG9ydGluZy4gIAoK
U28sIHRlbXAgdGFibGVz
IGFyZSB5b3VyIHRvIHBs
YXkgd2l0aCwgdW5sZXNz
IHlvdSdyZSBhY3R1
YWxseSBzb21laG93CnJl
cGxpY2F0aW5nIHRoZW0u
ICBXaGljaCB3b3VsZCBy
ZXF1aXJlIG1vcmUg
dGhhbiBhIGxpdHRsZSBl
ZmZvcnQgYW5kIGEKZmFp
ciBiaXQgb2YgdGhlIGNy
YXp5LiAgOikKX19f
X19fX19fX19fX19fX19f
X19fX19fX19fX19fX19f
X19fX19fX19fX19fX18K
U2xvbnkxLWdlbmVy
YWwgbWFpbGluZyBsaXN0
ClNsb255MS1nZW5lcmFs
QGdib3JnLnBvc3RncmVz
cWwub3JnCmh0dHA6
Ly9nYm9yZy5wb3N0Z3Jl
c3FsLm9yZy9tYWlsbWFu
L2xpc3RpbmZvL3Nsb255
MS1nZW5lcmFsCg==
| |
| Tim Goodaire 2006-04-07, 8:27 pm |
| T24gRnJpZGF5IDA3IEFw
cmlsIDIwMDYgOTozMyBh
bSwgTWFyY2luIE1hxYRr
IHdyb3RlOgo+IEhl
bGxvLgo+IFRoZSBnZW5l
cmFsIHBvbGljeSBmb3Ig
c2xvbnkgaXMgJ25vIGRk
bCBzaG91bGQgYmUg
cGVyZm9ybWVkIG9uIHJl
cGxpY2F0ZWQKPiBkYXRh
YmFzZXMnLiBEb2VzIHRo
aXMgYXBwbHkgdG8g
dGVtcG9yYXJ5IHRhYmxl
cyB0b28/ IENhbiBJIHNhZmVseSBj
cmVhdGUKPiB0ZW1wb3Jh
cnkgdGFi
bGVzIG9uIHRoZSBtYXN0
ZXIvb24gdGhlIHNsYXZl
cyA/ CgpZZXMuIFRoYXQncyBz
YWZlLiBUaGUg
Z2VuZXJhbCBwb2xpY3kg
c2hvdWxkIG1vcmUgcHJv
cGVybHkgYmUgZGVmaW5l
ZCBhcyAiTm8gCmRk
bCBzaG91bGQgYmUgcGVy
Zm9ybWVkIG9uIHJlcGxp
Y2F0ZWQgb2JqZWN0cyIu
Cgo+Cj4gQ2hlZXJz
Cj4gTWFyY2luCj4KPiBf
X19fX19fX19fX19fX19f
X19fX19fX19fX19fX19f
X19fX19fX19fX19f
X19fXwo+IFNsb255MS1n
ZW5lcmFsIG1haWxpbmcg
bGlzdAo+IFNsb255MS1n
ZW5lcmFsQGdib3Jn
LnBvc3RncmVzcWwub3Jn
Cj4gaHR0cDovL2dib3Jn
LnBvc3RncmVzcWwub3Jn
L21haWxtYW4vbGlz
dGluZm8vc2xvbnkxLWdl
bmVyYWwKCi0tIApUaW0g
R29vZGFpcmUgICAgNDE2
LTY3My00MTI2ICAg
IHRnb29kYWlyQGNhLmFm
aWxpYXMuaW5mbwpEYXRh
YmFzZSBBZG1pbmlzdHJh
dG9yLCBBZmlsaWFz
IENhbmFkYSBDb3JwLgpf
X19fX19fX19fX19fX19f
X19fX19fX19fX19fX19f
X19fX19fX19fX19f
X19fXwpTbG9ueTEtZ2Vu
ZXJhbCBtYWlsaW5nIGxp
c3QKU2xvbnkxLWdlbmVy
YWxAZ2JvcmcucG9z
dGdyZXNxbC5vcmcKaHR0
cDovL2dib3JnLnBvc3Rn
cmVzcWwub3JnL21haWxt
YW4vbGlzdGluZm8v
c2xvbnkxLWdlbmVyYWwK
|
|
|
|