| *** nowen_phone (~AndChat72@99-174-92-191.lightspeed.tukrga.sbcglobal.net) has joined #wikid | 00:08 | |
| *** Troy__ has quit (Ping timeout: 272 seconds) | 00:25 | |
| *** nowen has quit (Quit: Leaving.) | 01:06 | |
| *** nowen_phone has quit (Quit: Bye) | 01:41 | |
| *** rfxn has quit (Ping timeout: 276 seconds) | 07:05 | |
| *** Teck7 (~teck7@MTRLPQ5401W-LP140-01-2925087393.dsl.bell.ca) has joined #wikid | 07:06 | |
| *** KORG|2 (~kvirc@crytek.dream.net.ua) has joined #wikid | 07:17 | |
| *** KORG has quit (Read error: Connection reset by peer) | 07:17 | |
| *** rudy6 (~rudy6@213.132.115.194) has joined #wikid | 12:47 | |
| *** nowen (~nowen@50-194-249-125-static.hfc.comcastbusiness.net) has joined #wikid | 13:33 | |
| *** rudy6 has quit (Ping timeout: 264 seconds) | 14:16 | |
| *** rudy6 (~rudy6@213.132.115.194) has joined #wikid | 14:17 | |
| *** Troy__ (329b98a8@gateway/web/freenode/ip.50.155.152.168) has joined #wikid | 15:02 | |
| nowen | morning Troy__ | 15:02 |
|---|---|---|
| Troy__ | morning Nick.. how did the basketball game go? | 15:03 |
| nowen | good, we won. my son scored on a free throw too. | 15:04 |
| nowen | he's 11. ;-) | 15:04 |
| Troy__ | good deal.. my kids are a bit younger.. but it's coming soon | 15:04 |
| nowen | mixed bag in some ways. if you're not careful activities will take over and actual family time can suffer | 15:05 |
| Troy__ | Vince is wanting to move the db from the default /var/lib/pgsql/ to /data | 15:05 |
| nowen | hmm, why? is it a special partition with extra space? | 15:05 |
| Troy__ | is that an easy thing to do or is it more pain than it's worth? | 15:05 |
| Troy__ | brb | 15:06 |
| Troy__ | back.. yes.. i guess it's a special partition with extra space | 15:16 |
| Troy__ | i think I convinced Vince to keep it on the default location for now and move it later(if possible) | 15:19 |
| nowen | It looks like a simple change, but any rpm update would overwrite it | 15:22 |
| Troy__ | ok.. so we'd have to modify the conf each time we update? | 15:26 |
| nowen | I think it is only in postgresql.conf, so only when that file changes | 15:26 |
| nowen | which isn't often | 15:26 |
| nowen | why does he want to change it? | 15:27 |
| Troy__ | i think it's just how they have other dbs in the company setup.. separate partitions where it's easy to modify, backup, etc | 15:29 |
| nowen | well, that may outweigh the risks. | 15:32 |
| Troy__ | ok.. we'll see about switching in the lab once we have it running in the default location first | 15:35 |
| nowen | makes sense | 15:35 |
| Troy__ | so the SJ db is around 700MB right now | 15:35 |
| nowen | what's the status in the lab? | 15:35 |
| Troy__ | my plan is to backup this DB, run a log archive, vacuum, then see if I can sync the db to the old primary again | 15:36 |
| nowen | sounds good. should be a lot easier with a smaller db. | 15:37 |
| Troy__ | the lab is still down.. I guess Vince is still working on getting the pgsql conf worked out | 15:37 |
| nowen | maybe he should just start fresh. seems like a worm hole | 15:38 |
| Troy__ | yea. i agree | 15:38 |
| Troy__ | another question I thought about for upgrading wikid | 15:39 |
| nowen | ok | 15:39 |
| Troy__ | when we get the lab up and running.. can I re-create all the certificates in the lab with the upgraded WiKID, then transfer them over to the production box (after upgrading) ? | 15:40 |
| Troy__ | I hope that made sense | 15:40 |
| Troy__ | i can't have the production down for more than a few minutes.. so I was thinking about creating them over on the lab side with the upgraded version | 15:41 |
| nowen | hmm, it might be better to just copy them from production to the lab. | 15:42 |
| nowen | oh wait | 15:42 |
| nowen | I'm with you now. | 15:42 |
| Troy__ | i'm just talking about upgraded WiKID | 15:42 |
| nowen | let me double check | 15:42 |
| *** rudy6 has quit (Quit: Nettalk6 - www.ntalk.de) | 15:42 | |
| Troy__ | for each network client ( and I have 7 or 8), I need to create a cert and copy over to each of my SAML boxes | 15:43 |
| Troy__ | now that I think about it.. I don't think that would save me much time.. because I would still have to delete and re-add the network certificates one at a time in production | 15:46 |
| nowen | it should work - create the network clients in the lab | 15:47 |
| nowen | you think if you get the lab setup, you'll be able to do upgrades more frequently? | 15:48 |
| Troy__ | yes. i sure hope so | 15:52 |
| nowen | like to update postgresql | 15:52 |
| Troy__ | the main thing that's holding me back from upgrading to the latest version is the new inter certification and replication | 15:53 |
| Troy__ | upgrading in replication mode is more complicated | 15:53 |
| Troy__ | because you have to upgrade both servers before you can resume replication | 15:54 |
| nowen | yeah | 15:55 |
| nowen | does Vince have a preferred version of pgsql? we can test it | 15:56 |
| Troy__ | I'll ask him | 15:58 |
| Troy__ | one feature I think would be nice to add in a future revision is the ability to clean up devices from the WiKID admin panel | 15:59 |
| nowen | we've got lab capability to test everything you're doing too, so we can guide you to minimize downtime | 15:59 |
| Troy__ | such as remove devices with no activity greater than 1 year | 16:00 |
| Troy__ | ok | 16:00 |
| nowen | good one | 16:00 |
| Troy__ | maybe a bit dangerous | 16:00 |
| nowen | could be, but also could add security | 16:01 |
| nowen | remove from db or just display? | 16:01 |
| Troy__ | Vince says they are using 9.3 .. but he said the latest version of 8 would work but doesn't know if it's supported much anymore | 16:03 |
| nowen | ok | 16:03 |
| Troy__ | i think having a button that the admin could choose either remove from db or disable (and hide from view) | 16:04 |
| Troy__ | we have almost 16,000 devices right now and it's getting hard to manage | 16:05 |
| Troy__ | we don't have any easy way to sort or clean this up easily | 16:05 |
| nowen | yeah | 16:05 |
| nowen | I think we could do a filtered page more like the logs. | 16:05 |
| Troy__ | we need to upgrade before the sorting works :( | 16:05 |
| Troy__ | yea.. that would be awesome | 16:05 |
| nowen | oh - you're pre that fix? | 16:06 |
| Troy__ | yea.. i brought that to you about a year back i think | 16:06 |
| Troy__ | we haven't upgraded since | 16:06 |
| nowen | yeah - looking at the change log | 16:07 |
| Troy__ | i remember you fixed in the next version | 16:07 |
| Troy__ | Vince is saying we should just go to the latest PGSQL 9 if we're going through the trouble of upgrading anyway | 16:08 |
| nowen | ok - going to test it | 16:08 |
| Troy__ | You probably just saw the latest dbsize email | 17:49 |
| Troy__ | it was after we archived and ran a vacuum | 17:50 |
| nowen | much better | 17:50 |
| Troy__ | i may try and sync the db back over to the old primary later this afternoon | 17:52 |
| nowen | ok | 17:52 |
| *** Troy__ has quit (Ping timeout: 272 seconds) | 19:44 | |
| *** Troy__ (329b98a8@gateway/web/freenode/ip.50.155.152.168) has joined #wikid | 20:05 | |
| Troy__ | finally got our lab back online again | 20:07 |
| Troy__ | we are actually running a newer build in the lab than what we are running in production | 20:08 |
| Troy__ | not sure how that happened | 20:08 |
| Troy__ | lab = 3.5.0-b1411 / production = 3.4.87-b1216 | 20:10 |
| Troy__ | any difference in db schema with those 2 revisions? | 20:10 |
| nowen | let me see | 20:16 |
| nowen | yes | 20:29 |
| nowen | you can see yourself by running " more /opt/WiKID/conf/database/migrations/cumulative.sql" on both machines | 20:29 |
| nowen | 18 is the latest rev | 20:30 |
| nowen | Troy__: I also have it working on postgresql 9.3 | 21:22 |
| Troy__ | good deal | 21:23 |
| nowen | you have to do a dump and restore | 21:23 |
| nowen | I installed it beside 8.1 and then upgraded | 21:23 |
| nowen | I can document how I did it, but Vince might have his own preferences or corp standards | 21:30 |
| Troy__ | ok. that sounds good.. we plan to fail back over to our old primary server tomorrow afternoon | 21:45 |
| Troy__ | we can test the postgresql upgrade in the lab now that it's up and running | 21:45 |
| *** nowen has quit (Quit: Leaving.) | 23:17 | |
| *** Troy__ has quit (Ping timeout: 272 seconds) | 23:54 | |
Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!