it's just that in your original example you only had 1 UUID in the query, so I didn't realise that you wanted to check all of them
2018-07-27 20839, 2018
kartikeyaSh
I'll test it. But here still we have some conversion to an array which will again cause the same problem that we have at present
2018-07-27 20823, 2018
Dr-Flay_ joined the channel
2018-07-27 20857, 2018
Dr-Flay has quit
2018-07-27 20841, 2018
D4RK-PH0ENiX joined the channel
2018-07-27 20813, 2018
rsh7 has quit
2018-07-27 20834, 2018
rsh7 joined the channel
2018-07-27 20813, 2018
reosarevok
yvanzo, bitmap: did we disable Gravatar yet? Someone is asking about how to get a user image, I suspect for now the best suggestion is "don't, the existing ones are going away soon anyway"? :p
2018-07-27 20821, 2018
yvanzo
reosarevok: not yet
2018-07-27 20833, 2018
Darkloke has quit
2018-07-27 20854, 2018
Dr-Flay_ has quit
2018-07-27 20804, 2018
iliekcomputers
alastairp: just an update, dump still running
2018-07-27 20817, 2018
iliekcomputers
file is 55GB now and it's dumping highlevel_model
2018-07-27 20823, 2018
alastairp
right
2018-07-27 20826, 2018
alastairp
mm, one sec
2018-07-27 20840, 2018
iliekcomputers
this is the new one I started today
2018-07-27 20850, 2018
iliekcomputers
around 3:30 hrs ago
2018-07-27 20838, 2018
alastairp
I do pg_dump | bzip2, and the files were ~180GB, but I can't remember how long they took to dump
2018-07-27 20844, 2018
alastairp
I'm not sure what the uncompressed size is, either
2018-07-27 20801, 2018
alastairp
keep an eye on the disk space too - only 400gb free
2018-07-27 20807, 2018
iliekcomputers
hmm, i should have done a bzip2 too
2018-07-27 20831, 2018
alastairp
given the time that even this dump has done, I'd be much happier if we can look at doing this partial dump that I was suggesting
2018-07-27 20845, 2018
alastairp
when do you have some time to sit down and come up with a plan/list of commands?
2018-07-27 20800, 2018
alastairp
Monday?
2018-07-27 20830, 2018
iliekcomputers
i'll do it today.
2018-07-27 20855, 2018
alastairp
I'm happy to help, but I don't think I'll have time today
2018-07-27 20855, 2018
iliekcomputers
a bash script, I guess.
2018-07-27 20801, 2018
iliekcomputers
alastairp: ah
2018-07-27 20829, 2018
iliekcomputers
I'll try to come up with something, if I get stuck, we can co-ordinate when you get the time.
2018-07-27 20831, 2018
iliekcomputers
?
2018-07-27 20859, 2018
alastairp
absolutely
2018-07-27 20828, 2018
iliekcomputers
will you be around tomorrow? I know it's the weekend, so no rush.
2018-07-27 20852, 2018
alastairp
I might be around on-and-off, but I have visitors at home
2018-07-27 20822, 2018
UmkaDK has quit
2018-07-27 20846, 2018
iliekcomputers
alastairp: okay, on and off would work for me :P
2018-07-27 20859, 2018
UmkaDK joined the channel
2018-07-27 20851, 2018
Dr-Flay joined the channel
2018-07-27 20822, 2018
Dr-Flay has quit
2018-07-27 20829, 2018
iliekcomputers
dumping lowlevel now
2018-07-27 20810, 2018
UmkaDK_ joined the channel
2018-07-27 20855, 2018
UmkaDK has quit
2018-07-27 20814, 2018
alastairp
(btw, lowlevel is easy, it's lowlevel_json which is the big one :)
2018-07-27 20829, 2018
alastairp
but seriously, keep an eye on free disk space. I'm not sure you'll fit the whole thing uncompressed
2018-07-27 20827, 2018
Dr-Flay joined the channel
2018-07-27 20814, 2018
UmkaDK joined the channel
2018-07-27 20810, 2018
UmkaDK_ has quit
2018-07-27 20845, 2018
UmkaDK has quit
2018-07-27 20824, 2018
Dr-Flay has quit
2018-07-27 20859, 2018
UmkaDK joined the channel
2018-07-27 20810, 2018
iliekcomputers
alastairp: going to be afk for like two hours, should I just stop the dump? It might explode
2018-07-27 20807, 2018
iliekcomputers
Okay, hopefully it won't fill up 480GB in the next hour. I'm gonna let it run.
2018-07-27 20833, 2018
iliekcomputers
It's running on spike in screen on the param user btw
2018-07-27 20858, 2018
Dr-Flay joined the channel
2018-07-27 20801, 2018
alastairp
OK, I'll keep an eye on it for the next hour, it'll probably be OK
2018-07-27 20801, 2018
iliekcomputers
Thanks
2018-07-27 20819, 2018
Dr-Flay_ joined the channel
2018-07-27 20853, 2018
Dr-Flay has quit
2018-07-27 20801, 2018
Dr-Flay_ has quit
2018-07-27 20840, 2018
Dr-Flay joined the channel
2018-07-27 20822, 2018
Dr-Flay_ joined the channel
2018-07-27 20824, 2018
Dr-Flay has quit
2018-07-27 20850, 2018
antfoo has quit
2018-07-27 20853, 2018
UmkaDK has quit
2018-07-27 20820, 2018
UmkaDK joined the channel
2018-07-27 20803, 2018
bukwurm joined the channel
2018-07-27 20806, 2018
yokel has quit
2018-07-27 20833, 2018
yokel joined the channel
2018-07-27 20801, 2018
iliekcomputers
alastairp: still dumping lowlevel_json, upto 259GB now
that url(snail? what's it called again) was totally misleading
2018-07-27 20823, 2018
samj1912
slug :P
2018-07-27 20835, 2018
CatQuest
loi
2018-07-27 20848, 2018
CatQuest
slurl
2018-07-27 20802, 2018
CatQuest
but srsly, a slug of "chrome-http-not-secure" would have been much better
2018-07-27 20824, 2018
CatQuest
also ugh all these sites with +14 pt fontsizes
2018-07-27 20822, 2018
CatQuest
hmm
2018-07-27 20824, 2018
CatQuest
"Besides this, with the release of Google Chrome 69 in September this year, the company is also planning to remove the "Secure" label on HTTPS web pages, giving users the idea that the web is a safe place by default. "
2018-07-27 20837, 2018
CatQuest
i'm sorry, my brian is boling. cna someone explain this to me?
2018-07-27 20842, 2018
CatQuest
brain*
2018-07-27 20850, 2018
samj1912
CatQuest: basically a push to make https the norm
2018-07-27 20829, 2018
samj1912
bad rep if your site says not secure on top
2018-07-27 20833, 2018
CatQuest
yea but remove the "Secure" label which was users the idea that the web is a safe place by default
