It'd require for the db to send replication packets for those tables too heh
2008-06-24 17619, 2008
nikkiphone
Exactly
2008-06-24 17608, 2008
nikkiphone
I'd like it, then i could search edits and notes
2008-06-24 17657, 2008
Muz
I'd like moderation and edit data to be accessible via the webservices
2008-06-24 17620, 2008
srotta
I suggested some changes on the system earlier today... :P
2008-06-24 17646, 2008
nikkiphone
I don't have much internet access right now...
2008-06-24 17655, 2008
Muz
GPRS? :D
2008-06-24 17618, 2008
nikkiphone
Probably
2008-06-24 17629, 2008
nikkiphone
And my phone's stupid inability to multitask :(
2008-06-24 17615, 2008
adamgolding has quit
2008-06-24 17619, 2008
adamgolding joined the channel
2008-06-24 17616, 2008
Kanmu joined the channel
2008-06-24 17603, 2008
adamgolding has quit
2008-06-24 17607, 2008
adamgolding joined the channel
2008-06-24 17615, 2008
Tykling has left the channel
2008-06-24 17628, 2008
Kerensky_test joined the channel
2008-06-24 17601, 2008
Kerensky98
Hi handsome.
2008-06-24 17608, 2008
adamgolding has quit
2008-06-24 17612, 2008
adamgolding joined the channel
2008-06-24 17614, 2008
Kerensky_test has quit
2008-06-24 17624, 2008
nikkiphone has quit
2008-06-24 17650, 2008
adamgolding has quit
2008-06-24 17654, 2008
adamgolding joined the channel
2008-06-24 17653, 2008
nikkiphone joined the channel
2008-06-24 17633, 2008
adamgolding has quit
2008-06-24 17637, 2008
adamgolding joined the channel
2008-06-24 17611, 2008
ruaok joined the channel
2008-06-24 17652, 2008
adamgolding has quit
2008-06-24 17655, 2008
adamgolding joined the channel
2008-06-24 17638, 2008
outsidecontext joined the channel
2008-06-24 17650, 2008
nikkiphone has quit
2008-06-24 17617, 2008
xlotlu
beautiful. the replication loads asins before albums
2008-06-24 17607, 2008
adamgolding has quit
2008-06-24 17611, 2008
adamgolding joined the channel
2008-06-24 17658, 2008
sonium joined the channel
2008-06-24 17651, 2008
adamgolding has quit
2008-06-24 17655, 2008
adamgolding joined the channel
2008-06-24 17647, 2008
adamgolding
does %people% not include the performers?
2008-06-24 17635, 2008
adamgolding
err nevermind
2008-06-24 17642, 2008
adamgolding
that's a local variable of mine, lol
2008-06-24 17600, 2008
dsfasdf joined the channel
2008-06-24 17631, 2008
dsfasdf
Hello. Est' russkie? (%
2008-06-24 17637, 2008
NikoM_ joined the channel
2008-06-24 17622, 2008
adamgolding has quit
2008-06-24 17626, 2008
adamgolding joined the channel
2008-06-24 17628, 2008
NikoM_
������
2008-06-24 17653, 2008
dsfasdf
dsfasdf is now known as NikoM
2008-06-24 17600, 2008
NikoM_ has left the channel
2008-06-24 17654, 2008
xlotlu
the replication should take care of loading data in proper order so it won't trigger FK errors... right?
2008-06-24 17616, 2008
ruaok
there should be no triggers on a replicated slave.
2008-06-24 17648, 2008
ruaok
or FKs.
2008-06-24 17650, 2008
xlotlu
oh...
2008-06-24 17620, 2008
ruaok
InitDb.pl handles that correctly when you import your DB for the first time. assuming the DB type is set to SLAVE
2008-06-24 17642, 2008
xlotlu
yeah, i made it SLAVE after the import
2008-06-24 17653, 2008
srotta
Hmm. I have both triggers and FKs.
2008-06-24 17659, 2008
ruaok
stop the replication if it hasn't borked.
2008-06-24 17620, 2008
ruaok
the execute DropFKConstraints.sql and DropTrggers.sql
2008-06-24 17624, 2008
ruaok
then resume
2008-06-24 17636, 2008
srotta
Back when I installed my db the documentation wasn't too specific, so I just put everything there and hoped for the best :P Everything's been working fine.
2008-06-24 17650, 2008
srotta
Although I have to admit, I'm not sure if I have the triggers from MB or just my own.
2008-06-24 17601, 2008
adamgolding has quit
2008-06-24 17605, 2008
adamgolding joined the channel
2008-06-24 17654, 2008
stochasticism joined the channel
2008-06-24 17641, 2008
xlotlu
though replication should play nicely with FKs, and temporarily disable triggers
2008-06-24 17619, 2008
xlotlu
so you could change data at your own risk..
2008-06-24 17633, 2008
ruaok
FKs make the data import slower
2008-06-24 17644, 2008
ruaok
you don't need them since the main DB has them.
2008-06-24 17628, 2008
xlotlu
i need them for understanding the db structure :P
2008-06-24 17608, 2008
srotta
That was the reason for my adding them as well 8)
2008-06-24 17613, 2008
xlotlu
true, i can set up another empty db.. but no fun
2008-06-24 17601, 2008
xlotlu
.. and tools that do db "introspection"
2008-06-24 17645, 2008
Muzzz
Moose.
2008-06-24 17601, 2008
Muzzz
Ah ruaok! Was meaning to ask, was there ever the idea to add ISRCs to MB?
2008-06-24 17617, 2008
srotta
I've been wondering the same thing.
2008-06-24 17610, 2008
Muzzz potters off to make dinner quickly
2008-06-24 17649, 2008
ruaok
yes, there is.
2008-06-24 17651, 2008
ruaok
MBChatLogger: off
2008-06-24 17651, 2008
MBChatLogger
is not logging
2008-06-24 17616, 2008
MBChatLogger
is logging
2008-06-24 17626, 2008
niklas
ruaok: when should Sql->Finish() be used?
2008-06-24 17645, 2008
ruaok
only after a Select() returns rows.
2008-06-24 17607, 2008
ruaok
if ($sql->Select(...) { foo(); $sql->Finish(); }
2008-06-24 17620, 2008
ruaok
brb
2008-06-24 17622, 2008
ruaok has quit
2008-06-24 17651, 2008
adamgolding has quit
2008-06-24 17655, 2008
adamgolding joined the channel
2008-06-24 17605, 2008
nikki joined the channel
2008-06-24 17638, 2008
ruaok joined the channel
2008-06-24 17657, 2008
ruaok applauds luks' new topic
2008-06-24 17601, 2008
ruaok
bold. so very bold.
2008-06-24 17633, 2008
adamgolding has quit
2008-06-24 17637, 2008
adamgolding joined the channel
2008-06-24 17610, 2008
jacknetgb joined the channel
2008-06-24 17601, 2008
jacknetgb
" Any idea what the problem is?
2008-06-24 17601, 2008
ruaok
which version of PG are you using? which version of the mb_server source are you using?
2008-06-24 17636, 2008
jacknetgb
How would i find this out?
2008-06-24 17659, 2008
ruaok
you just installed those two.
2008-06-24 17604, 2008
ruaok
which ones did you install?
2008-06-24 17600, 2008
jacknetgb
Oh Postgre is 7.4
2008-06-24 17615, 2008
ruaok
8.1 is required. that's problem #1.
2008-06-24 17635, 2008
ruaok
then I think you're using mb_server from trunk to install data that was generated by a branch.
2008-06-24 17648, 2008
ruaok
that will likely be the other problem.
2008-06-24 17659, 2008
Muzzz
MBChatLogger: off
2008-06-24 17659, 2008
MBChatLogger
is not logging
2008-06-24 17613, 2008
MBChatLogger
is logging
2008-06-24 17618, 2008
jacknetgb
Why does the DebianServerSetup tell me commands that have postgresql7.4 in?
2008-06-24 17621, 2008
ruaok
Muzzz: cool.
2008-06-24 17634, 2008
ruaok goes to delete that page
2008-06-24 17659, 2008
luks
\o/
2008-06-24 17607, 2008
luks
it's confusing so many people
2008-06-24 17647, 2008
ruaok
gone now. :)
2008-06-24 17633, 2008
jacknetgb
Installing postgresql 8.1 now ill tell you how it goes
2008-06-24 17604, 2008
jacknetgb
How do i make svn get the files from not the trunk (whatever the normal one is)
