navap: dunno, but he got his itinerary changed to today (I've seen a pic of the boarding pass)
2012-11-08 31333, 2012
reosarevok
He just put Fri on the wiki... no idea why
2012-11-08 31323, 2012
adhawkins
Anyone know how much free space you need to import a data dump?
2012-11-08 31339, 2012
adhawkins
It appears to unzip all the data first...
2012-11-08 31352, 2012
navap
"a lot" :)
2012-11-08 31303, 2012
adhawkins
More than 15 Gig or so?
2012-11-08 31318, 2012
adhawkins
The new VM has a 20Gig root, and an 80 Gig partition for postgres
2012-11-08 31328, 2012
adhawkins
The dump files are in tmp, which is in the 20 Gig partition
2012-11-08 31310, 2012
navap
i think 20 is safe, i uavent measured a gull import in a while
2012-11-08 31329, 2012
navap
15 might not be
2012-11-08 31334, 2012
adhawkins
Does it extract all the files before it starts, or do one at a time?
2012-11-08 31340, 2012
navap
my plane just pulled up
2012-11-08 31353, 2012
adhawkins
Is it a pretty one? :)
2012-11-08 31335, 2012
navap
its white and has some writing on it
2012-11-08 31310, 2012
navap
I d0nt know what order it unzips in
2012-11-08 31337, 2012
alastairp
adhawkins: my database is 30gb. I just checked today
2012-11-08 31348, 2012
alastairp
I think you need ~the same to uncompress it into temp
2012-11-08 31351, 2012
alastairp
maybe a bit less
2012-11-08 31356, 2012
adhawkins
Bugger.
2012-11-08 31346, 2012
adhawkins
It's doing the edit dump first.
2012-11-08 31351, 2012
adhawkins
And that's the big one.
2012-11-08 31343, 2012
adhawkins
Looks like it's extracting all the files first.
2012-11-08 31306, 2012
navap
So where should i go after landing?
2012-11-08 31303, 2012
navap
The university or the apartment
2012-11-08 31354, 2012
adhawkins
Should I see a file or directory called musicbrainz_db under /var/lib/postegresql?
2012-11-08 31311, 2012
adhawkins
When it's created the database...
2012-11-08 31318, 2012
reosarevok
navap: the apartment
2012-11-08 31325, 2012
reosarevok
If you come at 10 or so
2012-11-08 31332, 2012
reosarevok
(we should move like at 3)
2012-11-08 31344, 2012
navap
Im schedulex tonarrive at 11
2012-11-08 31317, 2012
navap
Does the airport have wifi?
2012-11-08 31322, 2012
navap
Free wifi?
2012-11-08 31324, 2012
reosarevok
For 15 minutes
2012-11-08 31344, 2012
reosarevok
But, if you arrive at 11 go to the apartment
2012-11-08 31300, 2012
reosarevok
If you arrive after 12, maybe call Rob to make sure
2012-11-08 31300, 2012
adhawkins
Is ocharles travelling at the moment?
2012-11-08 31306, 2012
navap
What corner is the flat on?
2012-11-08 31356, 2012
reosarevok
adhawkins: he's sitting in front of me
2012-11-08 31309, 2012
adhawkins
Ah, ok :)
2012-11-08 31309, 2012
reosarevok
navap: I haven't been there yet
2012-11-08 31315, 2012
navap
the map links on the wiki dont look right tome. They show a different spot than when i looked at them on my pc
2012-11-08 31329, 2012
reosarevok
navap: dunno, it's the address Rob gave me
2012-11-08 31346, 2012
navap
Whats the address?
2012-11-08 31313, 2012
reosarevok
Bac de Roda 118, 12º 3ª
2012-11-08 31331, 2012
navap
What do the numbers mean?
2012-11-08 31346, 2012
reosarevok
adhawkins: he's just gone to Subway, so he is no longer in front of me
2012-11-08 31303, 2012
reosarevok
number on the street, floor, door
2012-11-08 31311, 2012
adhawkins
Ok. Might need to pick his brains about this VM stuff at some point.
2012-11-08 31312, 2012
reosarevok
(for navap)
2012-11-08 31315, 2012
adhawkins
I'm sure it can wait.
2012-11-08 31350, 2012
alastairp
navap:
2012-11-08 31359, 2012
alastairp
oh, you got the info about the numbers
2012-11-08 31309, 2012
alastairp
I'm at the university all day, anyway
2012-11-08 31301, 2012
alastairp
you need an access card to get in though, so maybe it's easiest to go to the apartment
2012-11-08 31305, 2012
reosarevok
We still need Rob so we can get into the apartment to begin with, but since he has to sleep somewhere I guess he'll make sure we get in :p
2012-11-08 31305, 2012
reosarevok
Rob just got to BCN
2012-11-08 31310, 2012
reosarevok
:)
2012-11-08 31303, 2012
navap
Great
2012-11-08 31319, 2012
navap
I think im boarding soon
2012-11-08 31338, 2012
navap
I thought wrong
2012-11-08 31334, 2012
reosarevok
hah
2012-11-08 31344, 2012
navap
They've had elderly and mobility challenged people lined up and ready to go for almost 30 min
2012-11-08 31320, 2012
navap
They're all just standing there, meanwhile us able bodied young folk are sitting comfortably
2012-11-08 31355, 2012
navap
arghh i keep getting disconnected evey 10-15 seconds
2012-11-08 31343, 2012
navap
The flight is supposed to leave in 23 min and no one's boarded yet
2012-11-08 31331, 2012
reosarevok
Sounds like a Ryanair flight :p
2012-11-08 31326, 2012
navap
30 min of screen time withwifi on and all i've lost is 5% battery life on the nexus 7. If only cell phones were that good
2012-11-08 31327, 2012
reosarevok
Ok, going to meet Rob now
2012-11-08 31333, 2012
reosarevok
Good luck with that boarding navap :)
2012-11-08 31345, 2012
kepstin-laptop joined the channel
2012-11-08 31331, 2012
kepstin-laptop is now in JFK, and has ½ hour before his final flight to BCN.
2012-11-08 31333, 2012
navap
Thanks. Give him an "eh?" from me
2012-11-08 31312, 2012
navap
kepstin-laptop: how's the weather?
2012-11-08 31336, 2012
kepstin-laptop
dull and cool.
2012-11-08 31346, 2012
kepstin-laptop
low clouds near the airport
2012-11-08 31332, 2012
kepstin-laptop finds it amusing that his first flight was from EST to CST, and now he's EST again
2012-11-08 31348, 2012
kepstin-laptop
oh well, the price of going for the cheapest flight :)
2012-11-08 31356, 2012
navap
Where did you connect?
2012-11-08 31303, 2012
kepstin-laptop
chicago o'hare
2012-11-08 31308, 2012
alastairp
when does Brewster arrive?
2012-11-08 31302, 2012
kepstin-laptop notes that this is mostly because ottawa intl airport is somewhat low traffic, and tends not to have convenient cheap direct flights to places :/
2012-11-08 31334, 2012
navap
Does it do non-us i18n flights?
2012-11-08 31348, 2012
alastairp
internationalisation flights
2012-11-08 31348, 2012
kepstin-laptop
yes, but they're somewhat limited.
2012-11-08 31302, 2012
alastairp
do porter fly out of ottawa?
2012-11-08 31346, 2012
kepstin-laptop
alastairp: I *think* so, but they primarily do ottawa-toronto, I think?
2012-11-08 31357, 2012
alastairp
yeah, maybe
2012-11-08 31313, 2012
kepstin-laptop checks
2012-11-08 31332, 2012
kepstin-laptop
I paid for a day of this boingo airport internet, might as well use it while I can.
2012-11-08 31336, 2012
alastairp
heh, yeah
2012-11-08 31330, 2012
navap
Toronto has free internet access including ssh :)
2012-11-08 31342, 2012
kepstin-laptop
fancy.
2012-11-08 31346, 2012
alastairp
so does montreal, I think
2012-11-08 31303, 2012
kepstin-laptop didn't spend long enough in ottawa to check
2012-11-08 31313, 2012
kepstin-laptop
literally just went through US customs and right onto the plane :)
2012-11-08 31353, 2012
navap
I did us customs in yesterday's attempt. Took almost 90 min from start to finish
2012-11-08 31326, 2012
kepstin-laptop
I got through in about 30-40 minutes, I think
2012-11-08 31328, 2012
navap
Today was regular security and it had absolutely no line
2012-11-08 31339, 2012
navap
we're boardinga!
2012-11-08 31344, 2012
kepstin-laptop
they had enough traffic that they had to open a second carry-on xray line :)
2012-11-08 31346, 2012
kepstin-laptop
have fun :)
2012-11-08 31306, 2012
kepstin-laptop
man, my ears are just recovering, and i'll be getting on another plane shortly...
2012-11-08 31312, 2012
kepstin-laptop
anyways, this is the long overnight one.. see everybody on the other side :)
2012-11-08 31332, 2012
Prophet5 joined the channel
2012-11-08 31333, 2012
adhawkins
Database and import data takes 35 Gig during the import (that's not including the download files themselves)
2012-11-08 31343, 2012
adhawkins
Once the import is complete it uses 18 Gig
2012-11-08 31354, 2012
adhawkins
So looks like you need 17 Gig just for the temporary extraction of the files.
2012-11-08 31357, 2012
navap
I.m in my seat, thatwassurprisingly fast
2012-11-08 31334, 2012
navap
adhawkins: We should document those numbers, somewhere
2012-11-08 31351, 2012
adhawkins
Well, they're in the chat logs now :)
2012-11-08 31314, 2012
uk
Summit WiFi available, yeah!
2012-11-08 31337, 2012
nikki_ joined the channel
2012-11-08 31353, 2012
alastairp
uk: where are you?
2012-11-08 31323, 2012
nikki_
alastairp: at the flat in barcelona with me and freso and rob
2012-11-08 31335, 2012
adhawkins
Ah, it's not finished importing yet. Still creating the indexes
