BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:DAYLIGHT DTSTART:20080309T020000 RDATE:20080309T020000 RDATE:20090308T020000 RDATE:20100314T020000 RDATE:20110313T020000 RDATE:20120311T020000 RDATE:20130310T020000 RDATE:20140309T020000 RDATE:20150308T020000 RDATE:20160313T020000 RDATE:20170312T020000 RDATE:20180311T020000 RDATE:20190310T020000 RDATE:20200308T020000 RDATE:20210314T020000 RDATE:20220313T020000 RDATE:20230312T020000 RDATE:20240310T020000 RDATE:20250309T020000 TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT END:DAYLIGHT BEGIN:STANDARD DTSTART:20081102T020000 RDATE:20081102T020000 RDATE:20091101T020000 RDATE:20101107T020000 RDATE:20111106T020000 RDATE:20121104T020000 RDATE:20131103T020000 RDATE:20141102T020000 RDATE:20151101T020000 RDATE:20161106T020000 RDATE:20171105T020000 RDATE:20181104T020000 RDATE:20191103T020000 RDATE:20201101T020000 RDATE:20211107T020000 RDATE:20221106T020000 RDATE:20231105T020000 RDATE:20241103T020000 RDATE:20251102T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20080325T124843Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20080720T170000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20080720T090000 DTSTAMP;VALUE=DATE-TIME:20080325T124843Z LAST-MODIFIED;VALUE=DATE-TIME:20080713T042912Z UID:http://calagator.org/events/1250453950 DESCRIPTION:What: All-day PostgreSQL one-track mini-conference \;\nWhe n: Sunday\, July 20th\, 9am to 5pm\, possible party afterwards \;\nWh o: PDXPUG will select speakers \;\nWhere: Portland Convention Center\ , Portland\, Oregon \;\n\n\nTags: postgresql\, database\n\nImported f rom: http://calagator.org/events/1250453950 URL:http://pugs.postgresql.org/node/374 SUMMARY:OSCON PostgreSQL Day SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20080828T035250Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20080918T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20080918T190000 DTSTAMP;VALUE=DATE-TIME:20080828T035250Z LAST-MODIFIED;VALUE=DATE-TIME:20080915T221918Z UID:http://calagator.org/events/1250455658 DESCRIPTION:PostgreSQL Users' Group monthly meeting. Followed by refresh ments at the Lucky Lab. \;\n \;\nTopic: Visual Planner \;\nPres enter: Tom Raney\, PSU \;\nWhere: FreeGeek\, 1731 SE 10th Avenue\, Po rtland\, OR \;\nWhen: 7pm\, September 18\, 2008 \;\n \;\nTom Ra ney will be presenting the Visual Planner\, a GUI tool written in Java t hat enables the user to peek inside the PostgreSQL planner's decision ma king process. The tool shows all plans that were evaluated including the plan that was picked for execution. Tom worked on this during Google Su mmer of Code\, and credits Dr. Len Shapiro\, a professor at Portland Sta te University and PDXPUG regular\, as a great help. \;\n \;\nTom s howed off his tool during OSCON and has gotten some feedback from commun ity members on it. He's working up a test example that should appeal to DBAs\, and I'll link directly to the source code once he's got it ready. \;\n \;\nThis work also involves a patch to PostgreSQL\, which sh ould be available soon! \;\n \;\nAfter the meeting\, retire to the Lucky Lab for refreshments! \;\n\n\nTags: postgresql\, postgres\, sq l\, database\n\nImported from: http://calagator.org/events/1250455658 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20080916T194632Z DTEND;VALUE=DATE:20081013 DTSTART;VALUE=DATE:20081010 DTSTAMP;VALUE=DATE-TIME:20080916T194632Z LAST-MODIFIED;VALUE=DATE-TIME:20080916T195310Z UID:http://calagator.org/events/1250455749 DESCRIPTION:This event runs from Friday\, October 10\, 2008 at 8am throug h Sunday\, October 12\, 2008 at 5pm.\n\nDescription:\nJoin us for the se cond annual PostgreSQL Conference West! Scheduled to begin October 10 an d go through the weekend\, West being held at Portland State University is going to be the destination for learning\, fun and general education about PostgreSQL. \n\nTags: postgresql\, postgres\, database\, pdxpug\n\ nImported from: http://calagator.org/events/1250455749 URL:http://www.postgresqlconference.org/ SUMMARY:PostgreSQL Conference West LOCATION:Portland State University Native American Student & Community Ce nter: 710 SW Jackson Street\, Portland Oregon 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20081119T210041Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20081120T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20081120T190000 DTSTAMP;VALUE=DATE-TIME:20081119T210041Z LAST-MODIFIED;VALUE=DATE-TIME:20081119T210041Z UID:http://calagator.org/events/1250456153 DESCRIPTION: \;\n \;\nWhile many people may know Randal Schwartz of Stonehenge Consulting (http://www.stonehenge.com/) from his talks and p apers on Perl\, he is also quite knowledgeable about Smalltalk and will be giving a talk on Smalltalk and Postgres integration. \;\n \;\nW e will be meeting Thursday\, November 20th\, at FreeGeek at 7:00pm - 173 1 SE 10th Avenue\, Portland\, OR. \;\n \;\nLooking forward to seei ng everyone there....and of course\, drinks at the Lucky Lab (http://www .luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards. \;\n\n\nTags: pdxpugs\, postgresql\, smalltalk\n\nImported from: http://calagator.org/ events/1250456153 URL:http://pugs.postgresql.org/node/480 SUMMARY:PostgreSQL: Randal + Smalltalk LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090108T011525Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090108T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090108T190000 DTSTAMP;VALUE=DATE-TIME:20090108T011525Z LAST-MODIFIED;VALUE=DATE-TIME:20090108T012514Z UID:http://calagator.org/events/1250456415 DESCRIPTION:PostgreSQL Portland Performance Practice Project (P5) \;\n \;\nSponsored by the Computer Science Department\, Portland State Un iversity \;\n \;\nThis series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics\, and the eff ects of some system tuning techniques. This involves studying the well k nown Online Transaction Processing (OLTP) benchmark called TPC-C ( www.t pc.org ). TPC-C was developed by a committee\, representing all major pl ayers in the database marketplace\, to be representative of typical onli ne enterprise databases. TPC-C consists of a precisely defined schema an d 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open sou rce package that the speaker has developed\, called DBT-2\, which many D BAs have found useful. \;\n \;\nMark Wong has an MS in Computer Sc ience from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are hi s years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source so ftware. He now works at HP StorageWorks on their NAS products. \;\n&# 13\;\n2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\, 7:00 PM \;\n PORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \;\nFOURTH AVENUE BU ILDING – ROOM 86-01\n\nTags: postgresql\n\nImported from: http://calagat or.org/events/1250456415 URL:http://web.cecs.pdx.edu/~len/P5.pdf SUMMARY:PostgreSQL Portland Performance Practice Project (P5) - Series Ov erview LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090202T172546Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090212T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090212T190000 DTSTAMP;VALUE=DATE-TIME:20090202T172546Z LAST-MODIFIED;VALUE=DATE-TIME:20090202T173520Z UID:http://calagator.org/events/1250456618 DESCRIPTION:2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\, 7:00 PM 3\;\nPORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \;\nFOURTH AVEN UE BUILDING – ROOM 86-01 \;\n \;\nSee website for more details.\n\ nTags: postgresql\, postgres\, pg\, pdxpug\n\nImported from: http://cala gator.org/events/1250456618 URL:http://pugs.postgresql.org/node/504 SUMMARY:PostgreSQL Portland Performance Practice Project (P5) LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090202T173912Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090219T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090219T190000 DTSTAMP;VALUE=DATE-TIME:20090202T173912Z LAST-MODIFIED;VALUE=DATE-TIME:20160621T232742Z UID:http://calagator.org/events/1250456619 DESCRIPTION:Monthly meeting of the Portland PostgreSQL Users' Group. \ ;\n \;\nEd Borasky will be speaking about Data Visualization. \;\n \;\nBeers after at the Lucky Lab on Hawthorne.\n\nTags: pdxpug\, pg\ , postgres\, postgresql\n\nImported from: http://calagator.org/events/12 50456619 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: PostgreSQL Data Visualization LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:6 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090223T165823Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090312T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090312T190000 DTSTAMP;VALUE=DATE-TIME:20090223T165823Z LAST-MODIFIED;VALUE=DATE-TIME:20090223T165823Z UID:http://calagator.org/events/1250456742 DESCRIPTION:Sponsored by the Computer Science Department\, Portland State University \;\n \;\nThis series will consist of 5 to 6 presentati ons aimed at PostgreSQL database users who wish to learn more about tuni ng their systems for performance. Attendees will learn how to generate a nd interpret operating system (Linux) and database statistics\, and the effects of some system tuning techniques. This involves studying the wel l known Online Transaction Processing (OLTP) benchmark called TPC-C ( ww w.tpc.org ). TPC-C was developed by a committee\, representing all major players in the database marketplace\, to be representative of typical o nline enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate h ow each tuning technique affects their performance. We will use an open source package that the speaker has developed\, called DBT-2\, which man y DBAs have found useful. \;\n \;\nPORTLAND STATE UNIVERSITY\, 19 00 SW 4th AVENUE\, \;\nFOURTH AVENUE BUILDING – ROOM 86-01\n\nTags: p ortland state university\, psu\, postgres\, postgresql\, dbt-2\, dbt2\n\ nImported from: http://calagator.org/events/1250456742 URL:http://pugs.postgresql.org/node/504 SUMMARY:PostgreSQL Portland Performance Practice Project (P5) LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090223T170233Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090319T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090319T190000 DTSTAMP;VALUE=DATE-TIME:20090223T170233Z LAST-MODIFIED;VALUE=DATE-TIME:20090223T170233Z UID:http://calagator.org/events/1250456743 DESCRIPTION:Monthly meeting of the Portland PostgreSQL Users' Group. \ ;\n \;\nKristin Tufte will be speaking about the Portland Transportat ion Archive Listing (PORTAL) database schema. \;\n \;\nBeers after at the Lucky Lab on Hawthorne. \;\n\n\nTags: postgres\, postgresql\, pdxpug\n\nImported from: http://calagator.org/events/1250456743 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: eXtreme Database Makeover 2: PORTAL LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090331T215355Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090409T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090409T190000 DTSTAMP;VALUE=DATE-TIME:20090331T215355Z LAST-MODIFIED;VALUE=DATE-TIME:20090331T215446Z UID:http://calagator.org/events/1250456914 DESCRIPTION:PostgreSQL Portland Performance Practice Project (P5) \;\n \;\nSponsored by the Computer Science Department\, Portland State Un iversity \;\n \;\nThis series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics\, and the eff ects of some system tuning techniques. This involves studying the well k nown Online Transaction Processing (OLTP) benchmark called TPC-C ( www.t pc.org ). TPC-C was developed by a committee\, representing all major pl ayers in the database marketplace\, to be representative of typical onli ne enterprise databases. TPC-C consists of a precisely defined schema an d 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open sou rce package that the speaker has developed\, called DBT-2\, which many D BAs have found useful. \;\n \;\nMark Wong has an MS in Computer Sc ience from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are hi s years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source so ftware. \;\n \;\n2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\ , 7:00 PM \;\nPORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \;\ nFOURTH AVENUE BUILDING – ROOM 86-01\n\nTags: postgresql\, postgres\, p5 \, dbt2\, database test 2\, dbt-2\n\nImported from: http://calagator.org /events/1250456914 URL:http://web.cecs.pdx.edu/~len/P5.pdf SUMMARY:PostgreSQL Portland Performance Practice Project (P5) - Linux Fil esystems LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090331T215922Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090416T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090416T190000 DTSTAMP;VALUE=DATE-TIME:20090331T215922Z LAST-MODIFIED;VALUE=DATE-TIME:20090410T152551Z UID:http://calagator.org/events/1250456915 DESCRIPTION:Monthly meeting of the Portland PostgreSQL Users' Group. \ ;\n \;\nChris May will be speaking. \;\n \;\nLooking forward to seeing everyone there...and of course\, drinks at the Lucky Lab (http:/ /www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.\n\nTags: pdxp ug\, postgresql\, postgres\n\nImported from: http://calagator.org/events /1250456915 URL:http://pugs.postgresql.org/node/540 SUMMARY:PDXPUG - MySQL war stories: Tales from the Crater LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090512T200044Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090514T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090514T190000 DTSTAMP;VALUE=DATE-TIME:20090512T200044Z LAST-MODIFIED;VALUE=DATE-TIME:20090513T162930Z UID:http://calagator.org/events/1250457199 DESCRIPTION:This session will survey a few PostgreSQL tuning \;\nparam eters and their effects on the OLTP workload DBT-2. \;\n \;\n-- 3\;\n \;\nPostgreSQL Portland Performance Practice Project (P5) \; \n \;\nSponsored by the Computer Science Department\, Portland State University \;\n \;\nThis series will consist of 5 to 6 presentatio ns aimed at PostgreSQL database users who wish to learn more about tunin g their systems for performance. Attendees will learn how to generate an d interpret operating system (Linux) and database statistics\, and the e ffects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www .tpc.org ). TPC-C was developed by a committee\, representing all major players in the database marketplace\, to be representative of typical on line enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate ho w each tuning technique affects their performance. We will use an open s ource package that the speaker has developed\, called DBT-2\, which many DBAs have found useful. \;\n \;\nMark Wong has an MS in Computer Science from OGI and several years of experience developing and executin g various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative o f the TPC-C benchmark to characterize system performance of open source software. \;\n \;\n2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\, 7:00 PM \;\nPORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \ ;\nFOURTH AVENUE BUILDING – ROOM 86-01 \;\n\n\nTags: database test 2\ , dbt-2\, dbt2\, p5\, postgres\, postgresql\n\nImported from: http://cal agator.org/events/1250457199 URL:http://web.cecs.pdx.edu/~len/P5.pdf SUMMARY:PostgreSQL Portland Performance Practice Project (P5) LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090515T233648Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090521T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090521T190000 DTSTAMP;VALUE=DATE-TIME:20090515T233648Z LAST-MODIFIED;VALUE=DATE-TIME:20090515T233648Z UID:http://calagator.org/events/1250457210 DESCRIPTION:by Len Shapiro \;\n \;\nAbstract: I'll survey how I tea ch the introductory database course at \;\nPSU. My goal for the talk is to elicit suggestions for how I could do \;\na better job. The t heme of the course is "\;transforming data into \;\nInformation&q uot\;. I use a 200 Meg database\, hosted on PostgreSQL\, instead \;\ nof the one-slide databases used in typical intro courses\, to \;\nil lustrate the principles of the course. The database is Federal \;\nE lections Commission data re donations to candidates\, so queries often&# 13\;\nreflect real questions about the real data. \;\n \;\nBio: Le n Shapiro has been a professor at PSU for 23 years. His \;\nresearch interests are primarily in query processing.\n\nTags: pdxpug\, postgres ql\, postgres\, psu\, portland state university\n\nImported from: http:/ /calagator.org/events/1250457210 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: Introductory Database Education at PSU LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090710T030015Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090716T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090716T190000 DTSTAMP;VALUE=DATE-TIME:20090710T030015Z LAST-MODIFIED;VALUE=DATE-TIME:20090715T192212Z UID:http://calagator.org/events/1250457404 DESCRIPTION:Webb Sprague will be speaking about PostGIS and the Census Da ta at the next PDXPUG meeting at FreeGeek (at 7:00pm - 1731 SE 10th Aven ue\, Portland\, OR). \;\n \;\nLooking forward to seeing everyone t here....and of course\, drinks at the Lucky Lab http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. \;\nafterwards. \;\n \;\nMore deta ils from Webb: \;\n \;\nIf anyone is wondering about specifics\, I will describe how I recently \;\ncreated a "\;crosswalk"\; table that correlates census tracts in 1980 with \;\ncensus tracts in 2000 in the Portland region (well\, Washington\, \;\nMultnomah\, and Clackamas counties)\, so that we could see poverty \;\ntrends over t he last 25 years. \;\n \;\nI used PostGIS\, Census naming conventi ons ("\;FIPS codes"\;)\, and lots of \;\nouter joins. So if you like that sort of thing\, I would love to hear \;\nyour comments tomorrow!\n\nTags: pdxpug\, postgresql\, postgis\, postgres\n\nImported from: http://calagator.org/events/1250457404 URL:http://pugs.postgresql.org/node/554 SUMMARY:PDXPUG - PostGIS and the Census Data LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090814T000804Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090820T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090820T190000 DTSTAMP;VALUE=DATE-TIME:20090814T000804Z LAST-MODIFIED;VALUE=DATE-TIME:20090814T000934Z UID:http://calagator.org/events/1250457552 DESCRIPTION:Join the Portland PostgreSQL Users' Group for our monthly mee ting! \;\n \;\nWhere: FreeGeek \;\nWhen: 7pm 20 August\, 2009 \;\nWho: Jim Cser \;\nWhat: Metro simulation database \;\n&# 13\;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgresql \, postgres\, sql\n\nImported from: http://calagator.org/events/12504575 52 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090821T163321Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090917T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090917T190000 DTSTAMP;VALUE=DATE-TIME:20090821T163321Z LAST-MODIFIED;VALUE=DATE-TIME:20090910T152257Z UID:http://calagator.org/events/1250457591 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 17 Sept\, 2009 \;\nWho: David Wheeler \;\nWhat: Unit Te st Your Database! \;\n \;\nDrinks afterward at the SE Lucky Lab.\n \nTags: pdxpug\, postgresql\, postgres\, sql\n\nImported from: http://ca lagator.org/events/1250457591 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20091014T230945Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091015T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091015T190000 DTSTAMP;VALUE=DATE-TIME:20091014T230945Z LAST-MODIFIED;VALUE=DATE-TIME:20091015T092246Z UID:http://calagator.org/events/1250457860 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 15 Oct\, 2009 \;\nWho: Selena Deckelmann \;\nWhat: Buca rdo: Replication with tiny little goats \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgres\, postgresql\, sql\n\nIm ported from: http://calagator.org/events/1250457860 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: Bucardo replication with tiny little goats LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20091115T204334Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091119T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091119T190000 DTSTAMP;VALUE=DATE-TIME:20091115T204334Z LAST-MODIFIED;VALUE=DATE-TIME:20091115T204655Z UID:http://calagator.org/events/1250458006 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 19 Nov\, 2009 \;\nWho: Dan Colish \;\nWhat: Materialize d Views (with cupcakes) \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgres\, postgresql\, sql\n\nImported from: htt p://calagator.org/events/1250458006 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: November meeting: Materialized Views LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20091229T063002Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100121T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100121T190000 DTSTAMP;VALUE=DATE-TIME:20091229T063002Z LAST-MODIFIED;VALUE=DATE-TIME:20091229T063002Z UID:http://calagator.org/events/1250458108 DESCRIPTION:The Portland PostgreSQL Users Group (PDXPUG) \;\n \;\nJ ohn Naylor will be talking about his experience in Florida as a data \;\nmanager for President Obama's 2008 campaign. He will discuss the rol e \;\nof data in political campaigns\, and also refactor some data wa rehouse \;\nqueries. Donuts and bacon provided. \;\n \;\nRefres hments will be partaken at the Lucky Labrador Pub in SE Portland afterwa rd.\n\nTags: postgresql\, databases\, obama\, bacon\, donuts\, freegeek\ , ftw\n\nImported from: http://calagator.org/events/1250458108 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG - Portland PostgreSQL Users Group: OBAMA! LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100210T160722Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100218T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100218T190000 DTSTAMP;VALUE=DATE-TIME:20100210T160722Z LAST-MODIFIED;VALUE=DATE-TIME:20100210T160722Z UID:http://calagator.org/events/1250458306 DESCRIPTION:Over Normalization from a developers point of view. \;\n&# 13\;\nBen Hengst works for Powells.com and has been involved in some in& #13\;\nhouse restructuring\, mostly centered around moving to a very ver tical \;\nstructure. This talk will revolve around what works and wha t doesn't\, \;\ncode and people problems that have been encountered a nd how to dig \;\nyour self out. \;\n \;\nLooking forward to se eing everyone there....and of course\, drinks at the Lucky Lab (http://w ww.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.\n\nTags: pdxpug \, postgresql\n\nImported from: http://calagator.org/events/1250458306 URL:http://pugs.postgresql.org/node/480 SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100310T012557Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100318T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100318T190000 DTSTAMP;VALUE=DATE-TIME:20100310T012557Z LAST-MODIFIED;VALUE=DATE-TIME:20100310T012557Z UID:http://calagator.org/events/1250458412 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 18 Mar\, 2010 \;\nWho: you! \;\nWhat: PostgreSQL 9.0alp ha testing party \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\ nTags: pdxpug\, postgres\, postgresql\, sql\n\nImported from: http://cal agator.org/events/1250458412 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100513T194521Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100520T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100520T190000 DTSTAMP;VALUE=DATE-TIME:20100513T194521Z LAST-MODIFIED;VALUE=DATE-TIME:20100513T194521Z UID:http://calagator.org/events/1250458686 DESCRIPTION:Join the Portland PostgreSQL Users' Group for our monthly mee ting! \;\n \;\nWhen: 7pm Thursday\, May 20 \;\nWhere: FreeGee k \;\nWho: Melissa Hollingsworth \;\nWhat: Normalization! \;\ n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgre s\, postgresql\, sql\n\nImported from: http://calagator.org/events/12504 58686 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100607T193618Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100617T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100617T190000 DTSTAMP;VALUE=DATE-TIME:20100607T193618Z LAST-MODIFIED;VALUE=DATE-TIME:20100607T211103Z UID:http://calagator.org/events/1250458749 DESCRIPTION:Join the Portland PostgreSQL Users' Group for our monthly mee ting! \;\n \;\nWhen: 7pm Thursday\, May 20 \;\nWhere: FreeGee k \;\nWho: Mark &\; gabrielle \;\nWhat: What's new in 9.0 \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, post gres\, postgresql\, sql\, databases\n\nImported from: http://calagator.o rg/events/1250458749 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG (Portland PostgreSQL Users' Group) LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100703T025238Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100710T170000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100710T083000 DTSTAMP;VALUE=DATE-TIME:20100703T025238Z LAST-MODIFIED;VALUE=DATE-TIME:20100703T025238Z UID:http://calagator.org/events/1250458826 DESCRIPTION:In early 2009\, several developers from Relevance and Viget L abs got together and starting talking about technical conferences. As we discussed our past experiences at regional\, national\, and internation al events\, we began to realize something: large conferences are wonderf ul for a lot of things\, but we wanted something that met a different se t of goals. We came up with Developer Day\, which was designed to: \; \nBuild lasting relationships among local peersBridge distinct technical communities \;\n \;\nAfter a year of Developer Days\, however\, w e decided a new look was in order\, and thus was born DevNation. We've s till got the same ideals\, but we feel that the DevNation name better re flects that vision (and it's easier to Google!) \;\n \;\nRelations hips \;\n \;\nThe general pattern for a large conference runs some thing like this: you fly to a city\, go to the event\, have a great time \, meet lots of great people\, and fly home. More often than not\, you d on't see those people again until the next big conference\, and that's a problem. We wanted our event to be different\, so it's intentionally lo cal. Speakers and attendees are overwhelmingly local to the conference\, so when you meet someone doing something cool\, you can connect with th em a week later for lunch without a problem. \;\n \;\nTechnology-A gnostic \;\n \;\nSure\, there are events that draw a wide range of developers (e.g.\, OSCON)\, but even then people tend to segregate\; th e Pythonists go to their sessions\, the Rubyists to theirs\, and the PHP devs to theirs. By having only one track\, we give everyone the opportu nity to see what's happening in other communities.\n\nTags: ruby\, riak\ , nosql\, conference\, html\, css\, javascript\, functional languages\, postgresql\n\nImported from: http://calagator.org/events/1250458826 URL:http://devnation.us/events/10 SUMMARY:Dev Nation LOCATION:Ace Hotel: 1022 SW Stark Street \, Portland OR 97205 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100913T233155Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100916T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100916T190000 DTSTAMP;VALUE=DATE-TIME:20100913T233155Z LAST-MODIFIED;VALUE=DATE-TIME:20100914T150141Z UID:http://calagator.org/events/1250459222 DESCRIPTION:Location-based services are all the rage these days\, and alm ost \;\neveryone has a latitude and longitude or two stashed away in a numeric column somewhere. But\, there is so much more to it than just a point. Once relegated to government and academia\, geographic inform ation systems are becoming increasingly visible. With the PostGIS exten sion\, PostgreSQL is a first-class geodatabase and an incredible platfor m for working with spatial data\, but what is PostGIS and why would one use it? And beyond PostGIS there are a dizzying array of tools to load\ , visualize and interact with the wonderful geospatial information in yo ur database. This talk will cover GIS and PostGIS basics and provide an introduction to geodatabases and spatial queries. \;\n \;\n-- \;\n \;\nEdwin Knuth spent quite some time as a sysadmin and web deve loper before going back to school to study Environmental Science at the University of Alaska Southeast. He quickly became fascinated with Geogr aphic Information Systems and realized that GIS was just a really neat d atabase application. In Alaska\, Edwin worked on several unique project s\, including building bat detectors and using PostGIS to manage a wirel ess sensor network on the Juneau Icefield. He has lived in Portland for the past year and loves it very much. \;\n \;\nThen a trip to the Lucky Lab after.\n\nTags: postgres\, postgis\, postgresql\, pdxpug\n\nI mported from: http://calagator.org/events/1250459222 URL:http://pugs.postgresql.org/node/1649 SUMMARY:All about PostGIS (at Portland PostgreSQL Users Group) LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:4 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20101014T204810Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20101021T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20101021T190000 DTSTAMP;VALUE=DATE-TIME:20101014T204810Z LAST-MODIFIED;VALUE=DATE-TIME:20101014T224351Z UID:http://calagator.org/events/1250459352 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 21 Oct\, 2010 \;\nWho: Aurynn Shaw \;\nWhat: PostgreSQL and node.js \;\n \;\nPostgres and Node.js\, a powerful event-driv en programming environment paired with our favourite open-source databas e\, now together in the same great package! Aurynn will be going over th e node.js environment\, how it differs from other programming environmen ts\, and how to use postgres with node. \;\n \;\nAurynn Shaw is Le ad Userspace Developer at Command Prompt\, Inc. She has come all the wa y from another country to present this talk\, so don't miss it! \;\n& #13\;\nBeer afterwards at the Lucky Lab. \;\n \;\nSee you there!\n \nTags: pdxpug\, postgres\, postgresql\, sql\n\nImported from: http://ca lagator.org/events/1250459352 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: Postgres + node.js LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20101108T232244Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20101118T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20101118T190000 DTSTAMP;VALUE=DATE-TIME:20101108T232244Z LAST-MODIFIED;VALUE=DATE-TIME:20101108T232244Z UID:http://calagator.org/events/1250459452 DESCRIPTION:\n\nTags: pdxpug\, postgresql\n\nImported from: http://calaga tor.org/events/1250459452 URL:http://pugs.postgresql.org/node/1652 SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110113T190508Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110120T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110120T190000 DTSTAMP;VALUE=DATE-TIME:20110113T190508Z LAST-MODIFIED;VALUE=DATE-TIME:20110120T235252Z UID:http://calagator.org/events/1250459638 DESCRIPTION:\n\nTags: pdxpug\, postgresql\n\nImported from: http://calaga tor.org/events/1250459638 URL:http://pugs.postgresql.org/node/1656 SUMMARY:PDXPUG (Postgresql) LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110204T030207Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110217T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110217T190000 DTSTAMP;VALUE=DATE-TIME:20110204T030207Z LAST-MODIFIED;VALUE=DATE-TIME:20110204T030207Z UID:http://calagator.org/events/1250459762 DESCRIPTION:Selena Deckelmann will be talking about managing terabyte ins tances of PostgreSQL. \;\n \;\nThis will be a preview of her MySQL Users Conference talk: \;\n \;\nhttp://en.oreilly.com/mysql2011/ public/schedule/detail/17195 \;\n \;\nSize can creep up on you. So me day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow\, and find out what new features in 9.0 have made life easi er for administrators and application developers working with big data.& #13\;\n \;\nThis talk will lead you through solutions to problems Pos tgres faces when it gets big: backups\, transaction wraparound\, bloat\, huge catalogs and upgrades. You need to monitor the right things\, find the gems in DBA-friendly database functions and catalog tables\, and kn ow the right places to look to spot problems early. We’ll also go over m onitoring best practices and open source tools to get the job done. \ ;\n \;\nWorking with multiple versions of Postgres back to version 8. 2 will be included\, and as well as tips on making the most out of new f eatures in 9.0. War stories will be taken from real-world work with Emma \, an email marketing company with a few large databases.\n\nTags: postg resql\, terabytes\, pdxpug\n\nImported from: http://calagator.org/events /1250459762 URL:http://www.postgresql.org SUMMARY:PDXPUG: Managing Terabytes LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110307T202708Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110317T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110317T190000 DTSTAMP;VALUE=DATE-TIME:20110307T202708Z LAST-MODIFIED;VALUE=DATE-TIME:20110307T202708Z UID:http://calagator.org/events/1250459888 DESCRIPTION:See http://pugs.postgresql.org/node/1660 for talk description .\n\nTags: pdxpug\, postgresql\, terabytes\n\nImported from: http://cala gator.org/events/1250459888 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG: PostgreSQL Logging LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110415T003137Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110421T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110421T190000 DTSTAMP;VALUE=DATE-TIME:20110415T003137Z LAST-MODIFIED;VALUE=DATE-TIME:20110415T003402Z UID:http://calagator.org/events/1250460492 DESCRIPTION:This month's meeting marks the fourth installment in our &quo t\;Founders Series"\;.. \;\n \;\nWhen: 7-9pm Thu Apr 21\, 2011 \;\nWhere: FreeGeek \;\nWho: David Wheeler \;\nWhat: Distribut ing Extensions on PGXN \;\n \;\nSo you've solved a common problem in PostgreSQL\, a serious pain point that lots of other people could tak e advantage of. You want to open-source the code\, and would like to pac kage it up and distribute it where people can find it\, read its docs\, and download and install it. \;\n \;\nThe newest destination for d istributing PostgreSQL extensions is PGXN\, the PostgreSQL Extension net work. PGXN offers a central index of PostgreSQL extensions and their doc umentation\, making it easy for people to find an install extensions. 3\;\n \;\nHow do you optimize your extension distribution for maximum PGXN exposure? By careful packaging\, thorough documentation\, and simp le installation. Join me for an overview of how best to achieve that — i ncluding how to build extensions compatible with PostgreSQL 9.1's improv ed extension support. \;\n \;\nDavid Wheeler is an associate at PG Experts\, and is responsible for PGXN\, the PostgreSQL Extension Network ) and pgTAP. He's into testing and extension distribution. \;\n \; \nBeer afterwards at the Lucky Lab. See you there!\n\nTags: postgres\, p ostgresql\, pdxpug\n\nImported from: http://calagator.org/events/1250460 492 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG: Distributing Extensions on PGXN LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110712T161344Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110724T170000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110724T093000 DTSTAMP;VALUE=DATE-TIME:20110712T161344Z LAST-MODIFIED;VALUE=DATE-TIME:20110712T161344Z UID:http://calagator.org/events/1250460814 DESCRIPTION:Coming to OSCON? Be sure to come a day early and join us for another PgDay! This summer marks PDXPUG's 5th anniversary\, and we want to see *your* smiling face! We will be celebrating at Gotham Tavern afte r the day of sessions. Sign up for sessions and afterparty here: http:// bit.ly/f1F2Mz . \;\n \;\nYes\, it's ok to show up just for the aft ernoon (or the party) if your flight arrives on Sunday. \;\n \;\nW e'd like a $30 donation to SPI for the sessions\, but don't let lack of funds deter you from attending.\n\nTags: oscon\, postgres\, postgresql\, databases\, pdxpug\n\nImported from: http://calagator.org/events/125046 0814 URL:http://wiki.postgresql.org/wiki/PDXPUGDay2011 SUMMARY:PgDay at OSCON LOCATION:Oregon Convention Center: 777 NE Martin Luther King Jr. Blvd.\, Portland OR 97232 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110816T021259Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110818T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110818T190000 DTSTAMP;VALUE=DATE-TIME:20110816T021259Z LAST-MODIFIED;VALUE=DATE-TIME:20110816T214501Z UID:http://calagator.org/events/1250461220 DESCRIPTION:Rob Wultsch\, a recent addition to Facebook's Database Operat ions team\, will compare and contrast the Facebook deployment with his p revious work with another large deployment of open source databases. In this db-agnostic talk\, he'll go over: the bizarre becoming ordinary\, t he many types of infrastructure that do not scale and what does and does not work when building a DBA team. \;\n \;\nBefore joining Facebo ok\, Rob worked for a very large hosting company as a database administr ator and a newspaper as a web developer. In his free time he enjoys ridi ng his motorcycle and bicycle and fantasizes about moving to Portland.&# 13\;\n \;\nAs always\, beer afterwards at the Lucky Lab. See you ther e!\n\nTags: postgresql\, postgres\, mysql\, ops\, facebook\, plancast:pl an=6xft\n\nImported from: http://calagator.org/events/1250461220 URL:http://Pugs.PostgreSQL.org/pdx SUMMARY:PDXPUG: Lessons from managing way too many databases at Facebook LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110908T215543Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110915T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110915T190000 DTSTAMP;VALUE=DATE-TIME:20110908T215543Z LAST-MODIFIED;VALUE=DATE-TIME:20110909T130955Z UID:http://calagator.org/events/1250461298 DESCRIPTION:When: 7-9pm Thu Sep 15\, 2011 \;\nWhere: FreeGeek \;\nW ho: Joshua Drake \;\nWhat: Practical PostgreSQL Performance \;\n&# 13\;\nThis presentation provides down tot earth performance advice. \ ;\n \;\nJoshua D. Drake (JD) is lead consultant at Command Prompt\, I nc. and \;\nPresident of PgUS. \;\n \;\nBeer afterwards at the Lucky Lab. See you there!\n\nTags: pdxpug\, postgres\, postgresql\n\nImp orted from: http://calagator.org/events/1250461298 URL:http://pugs.postgresql.org/node/1675 SUMMARY:PDXPUG: Practical PostgreSQL Performance LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20111007T015400Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111020T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111020T190000 DTSTAMP;VALUE=DATE-TIME:20111007T015400Z LAST-MODIFIED;VALUE=DATE-TIME:20111007T015400Z UID:http://calagator.org/events/1250461435 DESCRIPTION:When: 7-9pm Thu Oct 20\, 2011 \;\nWhere: Iovation \;\nW ho: Brent Dombrowski \;\nWhat: Upgrading PostGIS from 8.something to 9.0 \;\n \;\nSee PDXPUG blog (linked) for details.\n\nTags: pdxpug \, postgres\, postgresql\, postgis\, epdx:group=31\n\nImported from: htt p://calagator.org/events/1250461435 URL:http://pugs.postgresql.org/node/1678 SUMMARY:PDXPUG: Upgrading PostGIS LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20111104T032658Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111117T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111117T190000 DTSTAMP;VALUE=DATE-TIME:20111104T032658Z LAST-MODIFIED;VALUE=DATE-TIME:20111104T032658Z UID:http://calagator.org/events/1250461544 DESCRIPTION:See PDXPUG blog (linked) for details.\n\nTags: postgresql\, p ostgres\, pdxpug\, epdx:group=31\, database\n\nImported from: http://cal agator.org/events/1250461544 URL:http://pugs.postgresql.org/node/1679 SUMMARY:PDXPUG: collectd and Postgres LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120107T014653Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120119T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120119T190000 DTSTAMP;VALUE=DATE-TIME:20120107T014653Z LAST-MODIFIED;VALUE=DATE-TIME:20120107T014653Z UID:http://calagator.org/events/1250461819 DESCRIPTION:See PDXPUG blog (linked) for details.\n\nTags: postgresql\, d atabase\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://cal agator.org/events/1250461819 URL:http://pdxpug.wordpress.com/2012/01/07/pdxpug-january-meeting/ SUMMARY:PDXPUG: Database Tracking LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120211T000427Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120216T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120216T190000 DTSTAMP;VALUE=DATE-TIME:20120211T000427Z LAST-MODIFIED;VALUE=DATE-TIME:20120211T000427Z UID:http://calagator.org/events/1250461943 DESCRIPTION:See PDXPUG blog (linked) for details.\n\nTags: postgresql\, d atabase\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://cal agator.org/events/1250461943 URL:http://pdxpug.wordpress.com/2012/02/10/pdxpug-february-meeting/ SUMMARY:PDXPUG: Locks\, etc LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120310T074400Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120315T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120315T190000 DTSTAMP;VALUE=DATE-TIME:20120310T074400Z LAST-MODIFIED;VALUE=DATE-TIME:20120310T074400Z UID:http://calagator.org/events/1250462127 DESCRIPTION:See PDXPUG blog (linked) for details. Also\, "\;beware t he Ides of March"\;\, &\;c.\n\nTags: postgresql\, database\, post gres\, pdxpug\, epdx:group=31\n\nImported from: http://calagator.org/eve nts/1250462127 URL:http://pdxpug.wordpress.com/2012/03/09/pdxpug-march-meeting-next-week / SUMMARY:PDXPUG: NoSQL for People Living Under a Rock LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120406T001114Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120419T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120419T190000 DTSTAMP;VALUE=DATE-TIME:20120406T001114Z LAST-MODIFIED;VALUE=DATE-TIME:20120406T001114Z UID:http://calagator.org/events/1250462241 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250462241 URL:http://pdxpug.wordpress.com/2012/04/05/pdxpug-april-meeting-in-two-we eks/ SUMMARY:PDXPUG: Data Near Here LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120504T021518Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120517T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120517T190000 DTSTAMP;VALUE=DATE-TIME:20120504T021518Z LAST-MODIFIED;VALUE=DATE-TIME:20120504T021518Z UID:http://calagator.org/events/1250462358 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250462358 URL:http://pdxpug.wordpress.com/2012/05/03/pdxpug-may-meeting-in-two-week s/ SUMMARY:PDXPUG: Replication Without Tears LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120607T231815Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120621T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120621T190000 DTSTAMP;VALUE=DATE-TIME:20120607T231815Z LAST-MODIFIED;VALUE=DATE-TIME:20120607T231815Z UID:http://calagator.org/events/1250462452 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, android\, epdx:group=31\n\nImported from: http://calagator.org/events/1250462452 URL:http://pdxpug.wordpress.com/2012/06/07/pdxpug-june-meeting-in-two-wee ks/ SUMMARY:PDXPUG: Databases from Android LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120803T003113Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120816T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120816T190000 DTSTAMP;VALUE=DATE-TIME:20120803T003113Z LAST-MODIFIED;VALUE=DATE-TIME:20120803T003113Z UID:http://calagator.org/events/1250462677 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, android\, epdx:group=31\n\nImported from: http://calagator.org/events/1250462677 URL:http://pdxpug.wordpress.com/2012/08/02/pdxpug-august-meeting-in-two-w eeks-2/ SUMMARY:PDXPUG: Vertically Scaling Postgres LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120908T011549Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120920T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120920T190000 DTSTAMP;VALUE=DATE-TIME:20120908T011549Z LAST-MODIFIED;VALUE=DATE-TIME:20120920T162404Z UID:http://calagator.org/events/1250462832 DESCRIPTION:See PDXPUG blog (linked) for details. \;\n \;\nSqitch information is at http://sqitch.org/\n\nTags: postgresql\, database\, po stgres\, pdxpug\, epdx:group=31\n\nImported from: http://calagator.org/e vents/1250462832 URL:http://pdxpug.wordpress.com/2012/09/07/pdxpug-september-meeting-comin g-up/ SUMMARY:PDXPUG: Sqitch LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20121026T150450Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20121115T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20121115T190000 DTSTAMP;VALUE=DATE-TIME:20121026T150450Z LAST-MODIFIED;VALUE=DATE-TIME:20121026T150450Z UID:http://calagator.org/events/1250463037 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250463037 URL:http://pdxpug.wordpress.com/2012/10/25/pdxpug-november-meeting-in-thr ee-weeks/ SUMMARY:PDXPUG: Sqitch LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20121228T033953Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130110T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130110T185300 DTSTAMP;VALUE=DATE-TIME:20121228T033953Z LAST-MODIFIED;VALUE=DATE-TIME:20130108T215239Z UID:http://calagator.org/events/1250463281 DESCRIPTION:speaker: David Wheeler \;\n \;\n \;\nSQL change man agement is hard. Most “migration”-style implementations require opaque n aming conventions\, prefer DSLs that cover a fraction of SQL\, and requi re duplication of code for simple changes to existing functions. Such do es not have to be. And now it’s not \;\n \;\n \;\n \;\nIntro ducing Sqitch\, simple SQL change management that doesn’t suck. Sqitch d oesn’t care what programming language your app is written in. It has no opinions as to what database to use or what its schema should look like. And it doesn’t require sequentially-named migration scripts or the use of any DSL other than SQL. Sqitch lets you to write SQL migration script s that target your database\, and provides a simple\, unintrusive interf ace for specifying dependencies\, so that it can run things in the prope r order. \;\n \;\n \;\n \;\nSo come to this talk to learn al l about Sqitch: How it works\, where to get it\, and how to get the most out of managing database deployments. \;\n \;\n \;\n \;\nDa vid Wheeler is Senior Data Architect at iovation and an associate at PGE xperts. He is responsible\, among other things\, for PGXN\, pgTAP\, Desi gnScene\, and way too many CPAN modules. He lives in Portland unless he’ s traveling with his family. \;\n \;\n \;\nAs usual\, the meeti ng will be followed by social hour at the Lucky Lab Brew Pub.\n\nTags: p erl\, sql\, pdx.pm\, DB migration\, postgresql\, database\n\nImported fr om: http://calagator.org/events/1250463281 URL:http://pdx.pm.org/kwiki/?January2013Meeting SUMMARY:Portland Perl Mongers – Sane Database Change Management with Sqit ch LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130110T012641Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130117T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130117T190000 DTSTAMP;VALUE=DATE-TIME:20130110T012641Z LAST-MODIFIED;VALUE=DATE-TIME:20130110T012641Z UID:http://calagator.org/events/1250463361 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250463361 URL:https://pdxpug.wordpress.com/2013/01/09/pdxpug-january-meeting-2/ SUMMARY:PDXPUG: PostgreSQL in the Cloud LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130219T025129Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130221T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130221T190000 DTSTAMP;VALUE=DATE-TIME:20130219T025129Z LAST-MODIFIED;VALUE=DATE-TIME:20130219T025129Z UID:http://calagator.org/events/1250463670 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250463670 URL:https://pdxpug.wordpress.com/2013/02/18/pdxpug-february-meeting-this- week/ SUMMARY:PDXPUG: Dawn of a New Backup Era LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130319T171632Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130321T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130321T190000 DTSTAMP;VALUE=DATE-TIME:20130319T171632Z LAST-MODIFIED;VALUE=DATE-TIME:20130319T171632Z UID:http://calagator.org/events/1250463830 DESCRIPTION:Autovacuum’s like a Roomba\, right? You just turn it on and i t does all the work for you. Well\, not quite – for one\, your pets can’ t ride around on it – and occasionally it may get stuck in a (figurative ) corner. In this talk\, we’ll discuss vacuum\, analyze\, and their daem onic counterparts: how to adjust them to perform appropriately*\, and pe rhaps more importantly\, what the heck are they actually doing? \;\n& #13\;\nThis is a beginner-to-intermediate level talk\, but you will lear n something new about vacuuming\, regardless.** \;\n– \;\n \;\n Gabrielle Roth is a consultant with EnterpriseDB. She specializes in net work\, database\, and system monitoring\, as well as abusing SQL. \;\ n \;\n– \;\n \;\nAfter-meeting beer location: Huber’s\, the old est bar in Portland. See you there!\n\nTags: postgresql\, postgres\, pdx pug\n\nImported from: http://calagator.org/events/1250463830 URL:http://pdxpug.wordpress.com/2013/03/18/pdxpug-may-meeting-autovacuum- and-you/ SUMMARY:PDXPUG: Autovacuum and You LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130327T011710Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130418T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130418T190000 DTSTAMP;VALUE=DATE-TIME:20130327T011710Z LAST-MODIFIED;VALUE=DATE-TIME:20130327T011710Z UID:http://calagator.org/events/1250463881 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250463881 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: Extreme Database Makeover LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130327T011757Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130516T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130516T190000 DTSTAMP;VALUE=DATE-TIME:20130327T011757Z LAST-MODIFIED;VALUE=DATE-TIME:20130327T011757Z UID:http://calagator.org/events/1250463882 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250463882 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: Lightning Talks LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130617T200624Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130620T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130620T190000 DTSTAMP;VALUE=DATE-TIME:20130617T200624Z LAST-MODIFIED;VALUE=DATE-TIME:20130617T200624Z UID:http://calagator.org/events/1250464401 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250464401 URL:http://pdxpug.wordpress.com/2013/06/06/pdxpug-june-meeting-lightning- talks-really/ SUMMARY:PDXPUG: Lightning Talks LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130627T180439Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130724T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130724T180000 DTSTAMP;VALUE=DATE-TIME:20130627T180439Z LAST-MODIFIED;VALUE=DATE-TIME:20130724T164245Z UID:http://calagator.org/events/1250464479 DESCRIPTION:We have some special out-of-town guests here for OSCON\, so w e're having a special meeting for July. Details will be posted on the p dxpug website: http://wp.me/p25MlK-4r \;\n \;\nNote that this is n ot our regular meeting time\, day\, or location!\n\nTags: postgresql\, p ostgres\, pdxpug\n\nImported from: http://calagator.org/events/125046447 9 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: July meeting LOCATION:Emma: 524 E Burnside St.\, Suite 510\, Portland Oregon 97214 Uni ted States SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130801T022429Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130815T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130815T190000 DTSTAMP;VALUE=DATE-TIME:20130801T022429Z LAST-MODIFIED;VALUE=DATE-TIME:20130801T022429Z UID:http://calagator.org/events/1250464645 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250464645 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: YAMS Aren't Sweet Potatoes LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130905T212350Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130919T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130919T190000 DTSTAMP;VALUE=DATE-TIME:20130905T212350Z LAST-MODIFIED;VALUE=DATE-TIME:20130905T212350Z UID:http://calagator.org/events/1250464840 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250464840 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: JSON LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20131003T141449Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131017T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131017T190000 DTSTAMP;VALUE=DATE-TIME:20131003T141449Z LAST-MODIFIED;VALUE=DATE-TIME:20131017T221324Z UID:http://calagator.org/events/1250465006 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465006 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: UrbanFootprint LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20131101T140043Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131121T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131121T190000 DTSTAMP;VALUE=DATE-TIME:20131101T140043Z LAST-MODIFIED;VALUE=DATE-TIME:20131101T140043Z UID:http://calagator.org/events/1250465164 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465164 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: Aquameta LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140110T000648Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140116T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140116T190000 DTSTAMP;VALUE=DATE-TIME:20140110T000648Z LAST-MODIFIED;VALUE=DATE-TIME:20140110T000648Z UID:http://calagator.org/events/1250465469 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465469 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: January meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140204T143053Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140220T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140220T190000 DTSTAMP;VALUE=DATE-TIME:20140204T143053Z LAST-MODIFIED;VALUE=DATE-TIME:20140204T143053Z UID:http://calagator.org/events/1250465634 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465634 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: February meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140202T213234Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140224T220000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140224T170000 DTSTAMP;VALUE=DATE-TIME:20140202T213234Z LAST-MODIFIED;VALUE=DATE-TIME:20140202T213234Z UID:http://calagator.org/events/1250465623 DESCRIPTION:The Rentrak Hackathon is a gathering of laptops and laughter. Classically\, we all sit in a square and type words onto a keyboard tha t then get turned into a "\;computerized program"\;. It's a good chance to work on your personal projects\, learn what your peers are up to (computer-wise)\, figure out what the best programming language is\, and/or say the words "\;I don't have anything to work on"\; or "\;I forgot my laptop"\;. This event is very informal\, and ther e is no specific project we'll be focusing our efforts on. \;\n \; \nFood and refreshments are served. RSVPing to ssw@rentrakmail.com is ap preciated\, but not required. \;\n \;\nCome check out Rentrak's ne w downtown office. Everyone is welcome to join us!\n\nTags: ruby\, pytho n\, perl\, scala\, postgresql\, node\, javascript\, code\, coding\, objc \, java\, hackathon\, hacknight\n\nImported from: http://calagator.org/e vents/1250465623 URL:http://scottwainstock.com/hackathon/hackathon_february_2014.png SUMMARY:Rentrak Hackathon LOCATION:Rentrak - Downtown: 529 SW 3rd Avenue\, Floor 4\, Portland OR 97 204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140228T221525Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140320T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140320T190000 DTSTAMP;VALUE=DATE-TIME:20140228T221525Z LAST-MODIFIED;VALUE=DATE-TIME:20140228T221525Z UID:http://calagator.org/events/1250465772 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465772 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: March meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140221T211032Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140320T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140320T193000 DTSTAMP;VALUE=DATE-TIME:20140221T211032Z LAST-MODIFIED;VALUE=DATE-TIME:20140320T182456Z UID:http://calagator.org/events/1250465720 DESCRIPTION:Tonight at MaptimeStJohns\, we will review some compiled leaf let maps using several of the leaflet pluggins. We will go through some live custom examples using humangeo's dvf pluggin\, we will use postgis and output geojson\, geocsv and topojson to add to our leaflet maps\, a nd also discuss some temporal mapping tools. \;\n \;\nBring your l aptop with leaflet installed and a webserver available. Have a server sc ripting language such as php or python and postgressql/postgis installed . If you don't have a laptop\, come anyway and you will be able to see t hese tools in action\, as well as receive any materials handed out at th e meetup. Bring a flash drive so you can take a copy of the data home.&# 13\;\n \;\nLET'S GET TOGETHER AND MAP AT MAPTIMESTJOHNS!\n\nTags: osg eo\, mapping\, open source\, gis\, geography\, postgresql\, cartography\ , geospatial\, openstreetmap\, Spatial Data\, postgis\, GIS Web Develope rs\, Web mapping\, open source software\n\nImported from: http://calagat or.org/events/1250465720 URL:http://www.meetup.com/MapTime_StJohns/events/167180662/ SUMMARY:MaptimeStJohns LOCATION:Anna Bannanas Cafe\, St Johns: 8716 N Lombard St\, Portland Oreg on 97203 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140306T203758Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140324T220000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140324T170000 DTSTAMP;VALUE=DATE-TIME:20140306T203758Z LAST-MODIFIED;VALUE=DATE-TIME:20140306T203758Z UID:http://calagator.org/events/1250465802 DESCRIPTION:The Rentrak Hackathon is a gathering of laptops and laughter. Classically\, we all sit in a square and type words onto a keyboard tha t then get turned into a "\;computerized program"\;. It's a good chance to work on your personal projects\, learn what your peers are up to (computer-wise)\, figure out what the best programming language is\, and/or say the words "\;I don't have anything to work on"\; or "\;I forgot my laptop"\;. This event is very informal\, and ther e is no specific project we'll be focusing our efforts on. \;\n \; \nFood and refreshments are served. RSVPing to ssw@rentrakmail.com is ap preciated\, but not required. \;\n \;\nCome check out Rentrak's ne w downtown office. Everyone is welcome to join us!\n\nTags: ruby\, pytho n\, perl\, scala\, postgresql\, node\, javascript\, code\, coding\, objc \, java\, hackathon\, hacknight\n\nImported from: http://calagator.org/e vents/1250465802 URL:http://scottwainstock.com/hackathon/hackathon_march_2014.png SUMMARY:Rentrak Hackathon LOCATION:Rentrak - Downtown: 529 SW 3rd Avenue\, Floor 4\, Portland OR 97 204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140414T144616Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140417T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140417T190000 DTSTAMP;VALUE=DATE-TIME:20140414T144616Z LAST-MODIFIED;VALUE=DATE-TIME:20140414T144616Z UID:http://calagator.org/events/1250466011 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466011 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: April meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140414T003424Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140428T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140428T170000 DTSTAMP;VALUE=DATE-TIME:20140414T003424Z LAST-MODIFIED;VALUE=DATE-TIME:20140414T003424Z UID:http://calagator.org/events/1250466010 DESCRIPTION:The Rentrak Hackathon is a gathering of laptops and laughter. Classically\, we all sit in a square and type words onto a keyboard tha t then get turned into a "\;computerized program"\;. It's a good chance to work on your personal projects\, learn what your peers are up to (computer-wise)\, figure out what the best programming language is\, and/or say the words "\;I don't have anything to work on"\; or "\;I forgot my laptop"\;. This event is very informal\, and ther e is no specific project we'll be focusing our efforts on. \;\n \; \nFood and refreshments are served. RSVPing to ssw@rentrakmail.com is ap preciated\, but not required. \;\n \;\nCome check out Rentrak's ne w downtown office. Everyone is welcome to join us!\n\nTags: ruby\, pytho n\, perl\, scala\, postgresql\, node\, javascript\, code\, coding\, objc \, java\, hackathon\, hacknight\n\nImported from: http://calagator.org/e vents/1250466010 URL:http://scottwainstock.com/hackathon/hackathon_april_2014.png SUMMARY:Rentrak Hackathon LOCATION:Rentrak - Downtown: 529 SW 3rd Avenue\, Floor 4\, Portland OR 97 204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140508T041954Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140512T190000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140512T180000 DTSTAMP;VALUE=DATE-TIME:20140508T041954Z LAST-MODIFIED;VALUE=DATE-TIME:20140508T041954Z UID:http://calagator.org/events/1250466156 DESCRIPTION:## What Beginners Teach Us ## \;\n \;\n*Check out our p re-event Q&\;A with Selena on the New Relic [blog](http://blog.newrel ic.com/2014/05/07/advice-new-programmers-upcoming-futuretalk-speaker-sel ena-deckelmann/).* \;\n \;\nOpen source as an idea has won. Linux dominates developer servers\, open source tools are ubiquitous and being an open source developer rocks. And yet\, we talk frequently about how to find new contributors\, how to increase the number of people who part icipate and share code with us\, how to improve the skills of the junior developers and hire them as fast as we can. \;\n \;\nSelena has s pent a considerable amount of time teaching absolute beginners how to pr ogram in Python\, how to use the command-line and how to use revision co ntrol. These beginners succeed and fail in open source in both familiar and surprising ways. In this talk\, she will share lessons from their ex periences to help us create a more inclusive and welcoming future for op en source software. Further\, she will provide insights into the code re view process\, and how learning how to give code review (not just receiv e code review) is critical to becoming an expert developer. \;\n \ ;\n*This is the 7th event in a series of free monthly FutureTalks from d isruptive Developers\, innovative Technologists and world-changing Creat ives. Networking begins at 5:30\, with free food and drinks. The present ation will begin right at 6p.* \;\n \;\nPlease RSVP via Eventbrite [HERE](https://www.eventbrite.com/e/futuretalk-with-selena-deckelmann-t ickets-11529261331) \;\n \;\n*Selena is a major contributor to Pos tgreSQL and a data architect at Mozilla. She's been involved with free and open source software since 1995 and began running conferences for Po stgreSQL in 2007. She founded Open Source Bridge\, Postgres Open and spe aks internationally about open source\, databases and community. She is an advisor to the Ada Initiative\, an organization dedicated to increasi ng the participation of women in open source and technology communities. * \;\n \;\nYou can find her on Twitter @selenamarie and on her blo g at chesnok.com \;\n \;\n› FutureTalk is brought to you by New Re lic in collaboration with [TAO](http://www.techoregon.org)\n\nTags: new\ , relic\, futuretalk\, tech\, open\, source\, software\, developer\, cod e\, review\, python\, postgresql\n\nImported from: http://calagator.org/ events/1250466156 SUMMARY:FutureTalk with Selena Deckelmann LOCATION:New Relic: 111 SW 5th Avenue\, Suite 2700\, Portland Oregon 9720 4 United States SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140508T153849Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140515T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140515T190000 DTSTAMP;VALUE=DATE-TIME:20140508T153849Z LAST-MODIFIED;VALUE=DATE-TIME:20140508T153849Z UID:http://calagator.org/events/1250466159 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466159 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: May meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140604T042702Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140619T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140619T190000 DTSTAMP;VALUE=DATE-TIME:20140604T042702Z LAST-MODIFIED;VALUE=DATE-TIME:20140604T042702Z UID:http://calagator.org/events/1250466388 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466388 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: June meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140620T153034Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140722T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140722T190000 DTSTAMP;VALUE=DATE-TIME:20140620T153034Z LAST-MODIFIED;VALUE=DATE-TIME:20140620T153146Z UID:http://calagator.org/events/1250466534 DESCRIPTION:Portland Postgres Users Group. See link for details. \;\n& #13\;\nNote that this is not our regular meeting time or place!\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466534 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: July meeting: OSCON BoF SEQUENCE:4 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140807T213051Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140821T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140821T190000 DTSTAMP;VALUE=DATE-TIME:20140807T213051Z LAST-MODIFIED;VALUE=DATE-TIME:20140807T213051Z UID:http://calagator.org/events/1250466785 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466785 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: August meeting SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140811T164818Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140906T173000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140906T093000 DTSTAMP;VALUE=DATE-TIME:20140811T164818Z LAST-MODIFIED;VALUE=DATE-TIME:20140811T164818Z UID:http://calagator.org/events/1250466817 DESCRIPTION:Saturday\, September 6th\, is PostgreSQL Day\, co-hosted by t he Portland Postgres Users Group (PDXPUG) and Portland State University . Attendance is free\, but RSVP is required (link below) \;\n \;\n Place: Portland State University\, Engineering Building\, Room EB 102\, 1930 SW 4th Avenue\, Portland\, Oregon 97201. \;\n \;\nRegistrati on: Space is limited\, please RSVP! \;\n \;\nRSVP here: https://w ww.eventbrite.com/e/portland-postgresql-users-group-pdxpug-day-2014-tick ets-11916561757 \;\n \;\nFood: Light snacks &\; beverages provi ded. Breakfast and lunch is on your own\; food carts are nearby. \;\n \;\nPresentations: Organizers are looking for presenters for Postgre SQL Day. Talks should be about 45 minutes in length\, and about any of t he following topics: \;\n \;\nPostgreSQL administration and perfor mance \;\nCase studies of interesting uses of PostgreSQL and PostGIS& #13\;\nInteresting applications built on PostGIS or PostgreSQL \;\nDa tabase and/or geographic application development \;\nDatabase-related DevOps \;\nSQL and stored procedure programming \;\nNew Postgres/ PostGIS features and hacking Postgres/PostGIS \;\n \;\nOrganizers will also be taking lightning talks of 5 minutes each\, on similar topic s. Email your talk proposal to Mark Wong at markwkm -at- postgresql.org. \n\nTags: pdxpug\, foss4g\, postgresql\, postgis\, sql\n\nImported from: http://calagator.org/events/1250466817 URL:https://2014.foss4g.org/postgresql-day-september-6thq/ SUMMARY:PostgreSQL Day LOCATION:PSU Maseeh Engineering Building: 1930 SW 4th Avenue\, Portland O R 97201 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140906T013748Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140918T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140918T190000 DTSTAMP;VALUE=DATE-TIME:20140906T013748Z LAST-MODIFIED;VALUE=DATE-TIME:20140906T013748Z UID:http://calagator.org/events/1250466941 DESCRIPTION:Portland Postgres Users Group. See link for details. \;\n& #13\;\nWhen: 7-9pm Thu Sep 18\, 2014 \;\nWhere: Iovation \;\nWho: Jay Riddle \;\nWhat: Using Postgresql to enable Google like Search 3\;\n \;\nJay’s been experimenting with Pg’s full text search capabil ities. At our next meeting\, he’ll cover the following: \;\n* Brief i ntro on why Google like search capabilities are fun. \;\n* Introduce Postgresql full text abilities. Discuss at a high level why a full text index may be a bit heavier than a normal index. \;\n* Look at possibl e solutions for use cases where the data you want to index is spread acr oss multiple columns and multiple tables. \;\n \;\nJay Riddle is a database administrator at Viewpoint software. \;\n \;\nOur meetin g will be held at Iovation\, on the 32nd floor of the US Bancorp Tower a t 111 SW 5th (5th &\; Oak). It’s right on the Green &\; Yellow Max lines. Underground bike parking is available in the parking garage\; ou tdoors all around the block in the usual spots. No bikes in the office\, sorry! \;\n \;\nElevators open at 6:45 and building security clos es access to the floor at 7:30. \;\n \;\nThe building is on the Gr een &\; Yellow Max lines. Underground bike parking is available in th e parking garage\; outdoors all around the block in the usual spots. \;\n \;\nSee you there!\n\nTags: postgresql\, postgres\, pdxpug\n\nIm ported from: http://calagator.org/events/1250466941 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: September meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140911T020558Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140924T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140924T183000 DTSTAMP;VALUE=DATE-TIME:20140911T020558Z LAST-MODIFIED;VALUE=DATE-TIME:20140911T020558Z UID:http://calagator.org/events/1250466970 DESCRIPTION:# Come join us for Pythonic talks! \;\n \;\nAll levels are welcome! Talk levels vary from beginner to advanced. \;\n \;\n ##This month: \;\n \;\n* **Omnibus Database Machine: How to NoSQL in Postgres with Django** by Aleck Landgraf and Gavin McQuillan \;\n& #13\;\nAnd pizza from **Building Energy**! \;\n \;\nJoin us afterw ard at Rogue on NW 14th &\; Flanders to continue the discussion over a beverage. \;\n \;\nRSVP at [Meetup](http://www.meetup.com/pdxpyt hon/events/197450622/) \;\n \;\nJoin us on our [python.org](http:/ /mail.python.org/mailman/listinfo/portland) mailing list and in **#pdxpy thon** on Freenode. All are welcome!\n\nTags: python\, django\, postgres ql\, nosql\n\nImported from: http://calagator.org/events/1250466970 URL:http://www.meetup.com/pdxpython SUMMARY:PDX Python Presentation Night LOCATION:Urban Airship Inc: 1417 NW Everett St\, Suite 300\, Portland OR 97209 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140926T013020Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141016T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141016T180000 DTSTAMP;VALUE=DATE-TIME:20140926T013020Z LAST-MODIFIED;VALUE=DATE-TIME:20140926T013020Z UID:http://calagator.org/events/1250467047 DESCRIPTION:What: PgOpen Recap (gabrielle\, Mark\, John M)\; New Relic I nstrumentation of Pg Queries (Andrew) \;\n \;\nPlease note the new earlier meeting time! We’ll try this over the winter. \;\n \;\nTw o topics this month: PgOpen attendees will discuss highlights of that c onference\, and Andrew will talk about some New Relic-y stuff. \;\n&# 13\;\nOur meeting will be held at Iovation\, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th &\; Oak). It’s right on the Green &\; Yellow Max lines. Underground bike parking is available in the p arking garage\; outdoors all around the block in the usual spots. No b ikes in the office\, sorry! \;\n \;\nElevators open at 5:45 and bu ilding security closes access to the floor at 6:30.\n\nTags: postgresql\ , postgres\, pdxpug\n\nImported from: http://calagator.org/events/125046 7047 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: October meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20141106T032655Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141120T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141120T180000 DTSTAMP;VALUE=DATE-TIME:20141106T032655Z LAST-MODIFIED;VALUE=DATE-TIME:20141106T032655Z UID:http://calagator.org/events/1250467322 DESCRIPTION:See website for details.\n\nTags: postgresql\, postgres\, pdx pug\n\nImported from: http://calagator.org/events/1250467322 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: November meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20141026T163059Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141124T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141124T173000 DTSTAMP;VALUE=DATE-TIME:20141026T163059Z LAST-MODIFIED;VALUE=DATE-TIME:20141026T163059Z UID:http://calagator.org/events/1250467224 DESCRIPTION:The Rentrak Hackathon is a gathering of laptops and laughter. Classically\, we all sit in a square and type words onto a keyboard tha t then get turned into a "\;computerized program"\;. It's a good chance to work on your personal projects\, learn what your peers are up to (computer-wise)\, figure out what the best programming language is\, and/or say the words "\;I don't have anything to work on"\; or "\;I forgot my laptop"\;. This event is very informal\, and ther e is no specific project we'll be focusing our efforts on. \;\n \; \nFood and refreshments are served. RSVPing to ssw@rentrakmail.com is ap preciated\, but not required. \;\n \;\nCome check out Rentrak's ne w downtown office. Everyone is welcome to join us!\n\nTags: code\, codin g\, hackathon\, hacknight\, java\, javascript\, node\, objc\, perl\, pos tgresql\, python\, ruby\, scala\n\nImported from: http://calagator.org/e vents/1250467224 URL:http://scottwainstock.com/hackathon/hackathon_november_2014.png SUMMARY:Rentrak Hackathon LOCATION:Rentrak - Downtown: 529 SW 3rd Avenue\, Floor 4\, Portland OR 97 204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20141127T164405Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141204T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141204T180000 DTSTAMP;VALUE=DATE-TIME:20141127T164405Z LAST-MODIFIED;VALUE=DATE-TIME:20141127T164405Z UID:http://calagator.org/events/1250467435 DESCRIPTION:See website for details.\n\nTags: postgresql\, postgres\, pdx pug\n\nImported from: http://calagator.org/events/1250467435 URL:http://pdxpug.wordpress.com/2014/11/27/pdxpug-december-lab-no-regular -december-meeting/ SUMMARY:PDXPUG: December lab night LOCATION:Renewable Funding: 400 SW 6th Avenue\, Suite 902\, Portland OR 9 7204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20141201T235959Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141230T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141230T190000 DTSTAMP;VALUE=DATE-TIME:20141201T235959Z LAST-MODIFIED;VALUE=DATE-TIME:20141201T235959Z UID:http://calagator.org/events/1250467441 DESCRIPTION:Programming OS Web Spatio-temporal Mapping Visiualizations: T ues\, Dec 30\, 7:00pm\, Anna Bananas St Johns\, 8716 N. Lombard\, Portla nd\, Oregon (back room). This month we will work with OpenStreetMap Data . We will use JOSM to edit OSM data and learn to download OSM data for u se in our web visualizations. \;\n \;\nNOTE: we have a new time .. . we will begin at 7pm and go to 9pm. If you are late\, come anyway. We will be in the back room mapping away :)\n\nTags: geogeek\, geography\, gis\, javascript\, leaflet\, mapping\, osgeo\, postgis\, postgresql\, we bgeo\n\nImported from: http://calagator.org/events/1250467441 URL:http://www.meetup.com/MapTime_StJohns/events/195534912/ SUMMARY:Programming OS Web Spatio-temporal Mapping Visiualizations LOCATION:Anna Bananas\, St Johns: 8716 N. Lombard\, Portland Oregon 97203 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150107T152158Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150115T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150115T180000 DTSTAMP;VALUE=DATE-TIME:20150107T152158Z LAST-MODIFIED;VALUE=DATE-TIME:20150107T152158Z UID:http://calagator.org/events/1250467594 DESCRIPTION:When: 6-8pm Thu Jan 15\, 2015 \;\nWhere: Iovation \;\nW ho: Gabrielle Roth \;\nWhat: RDS Postgres \;\n \;\nAmazon integ rated Postgres into their general Relational Database Services (RDS) off erings July 1\, 2014. RDS offers automatic failover\, scalability\, and easy configuration\, plus Amazon handles all the patching and upgrades f or you! Their SDK supports many languages and includes a robust CLI\, if you want to automate management of your deployments. They also support several popular Postgres extensions. \;\n \;\nOf course\, since it ’s a managed service\, you can’t do everything you might expect or want to. In this talk\, I’ll discuss the fun\, the quirky\, and the downright maddening features I’ve discovered working with production RDS deployme nts. Come find out what it’s like to use RDS Postgres day-to-day. \;\ n \;\nThe building is on the Green &\; Yellow Max lines. Undergrou nd bike parking is available in the parking garage\; outdoors all around the block in the usual spots. \;\n \;\nWe’ll go to Huber’s for af ter-meeting socializing. \;\n \;\nSee you there!\n\nTags: postgres ql\, postgres\, pdxpug\n\nImported from: http://calagator.org/events/125 0467594 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: January meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150203T041827Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150219T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150219T180000 DTSTAMP;VALUE=DATE-TIME:20150203T041827Z LAST-MODIFIED;VALUE=DATE-TIME:20150203T041827Z UID:http://calagator.org/events/1250467769 DESCRIPTION:When: 6-8pm Thu Feb 19\, 2015 \;\nWhere: Iovation \ ;\nWho: David Kerr \;\nWhat: Using Bucardo to Migrate your Pg datab ase to RDS with minimal downtime \;\n \;\nAs a followup to January ’s RDS discussion\, Dave Kerr works through strategies to move your exis ting Postgres database into RDS. \;\n \;\nUsing Bucardo and Master /Master Replication we can achieve a migration to RDS with minimal or no downtime. \;\n \;\nDave will show some tools and techniques so he lp facilitate this transition as well as go over the idiosyncrasies of u sing Bucardo with RDS.\n\nTags: postgresql\, postgres\, pdxpug\n\nImport ed from: http://calagator.org/events/1250467769 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: February meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:4 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150311T024916Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150319T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150319T180000 DTSTAMP;VALUE=DATE-TIME:20150311T024916Z LAST-MODIFIED;VALUE=DATE-TIME:20150311T024916Z UID:http://calagator.org/events/1250468039 DESCRIPTION:\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: ht tp://calagator.org/events/1250468039 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: March meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150410T004911Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150416T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150416T180000 DTSTAMP;VALUE=DATE-TIME:20150410T004911Z LAST-MODIFIED;VALUE=DATE-TIME:20150410T004911Z UID:http://calagator.org/events/1250468207 DESCRIPTION:\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: ht tp://calagator.org/events/1250468207 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: April meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150502T020646Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150521T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150521T180000 DTSTAMP;VALUE=DATE-TIME:20150502T020646Z LAST-MODIFIED;VALUE=DATE-TIME:20150502T020646Z UID:http://calagator.org/events/1250468356 DESCRIPTION:\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: ht tp://calagator.org/events/1250468356 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: May meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20170707T183128Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20170720T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20170720T180000 DTSTAMP;VALUE=DATE-TIME:20170707T183128Z LAST-MODIFIED;VALUE=DATE-TIME:20170707T183128Z UID:http://calagator.org/events/1250472191 DESCRIPTION:PostgreSQL 10 is now out in beta. We called it 10 because thi s release is going to blow your socks off. Josh Berkus will demonstrate several of the new features in this version\, including built-in logical replication\, native partitioning\, additional query parallelism\, JSON full-text search\, and more. He'll also explain some of the issues you' re likely to encounter upgrading to Version X. \;\n \;\nJosh Berku s recently retired from the PostgreSQL Core Team and is currently workin g for Redhat as the Project Atomic Community Lead. \;\n \;\n— \ ;\nIf you have a job posting or event you would like me to announce at t he meeting\, please send it along. The deadline for inclusion is 5pm the day before the meeting.\n\nTags: psotgres\, postgresql\n\nImported from : http://calagator.org/events/1250472191 URL:https://pdxpug.wordpress.com/2017/07/07/postgresql-10-beta/ SUMMARY:PostgreSQL 10 Beta LOCATION:Iovation 111 SW 5th Ave suite 3200 (big pink): 111 sw 5th ave\, portland or 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180130T164631Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180215T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180215T180000 DTSTAMP;VALUE=DATE-TIME:20180130T164631Z LAST-MODIFIED;VALUE=DATE-TIME:20180130T164631Z UID:http://calagator.org/events/1250473187 DESCRIPTION:Want automated high availability PostgreSQL *without* relying on someone else's cloud service? It's possible today\, and easier than you think\; we just need a little container orchestration pixiedust\, an d your DBAs can take the weekend off. \;\n \;\nJosh Berkus will ex plain the current state of HA Postgres services on Kubernetes/OpenShift\ , introducing the several projects in this area\, and then going into a deep dive on Patroni/Spilo. He'll bring you up to date on the new "\ ;Kube-native"\; Patroni\, and work expected in the future. With live demos! \;\n \;\n--------- \;\n \;\nJosh Berkus helps manage the Kubernetes community for Red Hat. He is a "\;hacker emeritus&qu ot\; for PostgreSQL. He lives in NE Portland with a large black cat\, a pottery studio\, and a librarian.\n\nTags: postgres\, postgresql\, OpenS hift\, kubernetes\, patroni\, spilo\n\nImported from: http://calagator.o rg/events/1250473187 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Automatic For The People LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180405T143332Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180419T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180419T180000 DTSTAMP;VALUE=DATE-TIME:20180405T143332Z LAST-MODIFIED;VALUE=DATE-TIME:20180831T072303Z UID:http://calagator.org/events/1250473542 DESCRIPTION:Presented by: Dr. Kristin Tufte \;\n \;\nThis talk will describe work in Smart Cities in the Portland region. We’ll begin with the framework and motivation for the Smart Cities work and the question What is a Smart City? We’ll discuss Portland’s approach to Smart Cities\ , provide some historical context and then give an overview of ongoing S mart Cities projects including work on AV policy\, the Portland Urban Da ta Lake\, new sensors and earthquake resilience. The goal of the talk is to give the audience an overview of the work being done in Portland to bring a human face to data and technology and to inspire question and di scussion. \;\n \;\nDr. Tufte is actively involved in Portland’s Sm art Cities work and was the data lead on the City of Portland’s Smart Ci ties proposal. Dr. Tufte has collaborated closely with transportation ag encies in the Portland-Vancouver area for the past ten years and directs PORTAL — the regional transportation data archive. Dr. Tufte is a membe r of the Transportation Research Board’s Urban Data Committee\, co-chair ing its Urban Big Data subcommittee and Portland Global Cities Team Chal lenge Action Cluster. Dr. Tufte has a PhD in Database Management from th e University of Wisconsin - Madison. Dr. Tufte’s passion is using data a nd technology to change people’s lives\, especially those in traditional ly underserved communities.\n\nTags: postgresql\, postgres\, Data Lake\, smart cities\n\nImported from: http://calagator.org/events/1250473542 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: PUDL: Portland Urban Data Lake LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180508T040408Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180517T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180517T180000 DTSTAMP;VALUE=DATE-TIME:20180508T040408Z LAST-MODIFIED;VALUE=DATE-TIME:20180508T040408Z UID:http://calagator.org/events/1250473715 DESCRIPTION:\n\nTags: postgresql\, postgres\n\nImported from: http://cala gator.org/events/1250473715 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG May meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180614T013909Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180621T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180621T180000 DTSTAMP;VALUE=DATE-TIME:20180614T013909Z LAST-MODIFIED;VALUE=DATE-TIME:20180614T013909Z UID:http://calagator.org/events/1250473882 DESCRIPTION:\n\nTags: postgresql\, postgres\n\nImported from: http://cala gator.org/events/1250473882 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG June meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180815T032857Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180816T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180816T180000 DTSTAMP;VALUE=DATE-TIME:20180815T032857Z LAST-MODIFIED;VALUE=DATE-TIME:20180815T032857Z UID:http://calagator.org/events/1250474119 DESCRIPTION:Stored procedure support is coming to PostgreSQL 11. Come he ar about what a stored procedure is and how it differs from the existing user-defined functions.\n\nTags: postgres\, postgresql\, stored procedu res\n\nImported from: http://calagator.org/events/1250474119 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: Sneak peek at stored procedures LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180402T005516Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180910T180000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180910T090000 DTSTAMP;VALUE=DATE-TIME:20180402T005516Z LAST-MODIFIED;VALUE=DATE-TIME:20180402T005516Z UID:http://calagator.org/events/1250473528 DESCRIPTION:The Portland PostgreSQL Users Group (PDXPUG)\, Portland State University Maseeh College of Engineering and Computer Science\, and Dat alab\, the PSU Data and Information Management Laboratory and is proud to present a day of presentations about PostgreSQL\, an open source rela tional database management system. \;\n\n\nTags: postgresql\, postgre s\n\nImported from: http://calagator.org/events/1250473528 URL:https://pdx.postgresql.us/pdxpgday2018 SUMMARY:Portland PostgreSQL Day (PDXPUG PGDay) 2018 LOCATION:Portland State University Engineering Building: 1930 SW 4th Ave\ , Portland Oregon 97201 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180918T171457Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180925T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180925T180000 DTSTAMP;VALUE=DATE-TIME:20180918T171457Z LAST-MODIFIED;VALUE=DATE-TIME:20180918T171457Z UID:http://calagator.org/events/1250474255 DESCRIPTION:For an opening act\, CNPDX organizer Josh Berkus will demo a walk-through of deploying high availability PostgreSQL as an application on Kubernetes. \;\n \;\nOur main event will be: \;\n \;\nDe ploying TiDB\, a distributed open-source MySQL-Compatible HTAP Database\ , using Kubernetes \;\n \;\nThis talk will introduce TiDB's archit ecture\, key use cases\, a user story with Mobike (one of the largest bi kesharing platforms in the world)\, and a deep-dive into deploying TiDB as a *stateful* application using Kubernetes. TiDB is built by the compa ny PingCAP and its open-source community. \;\n \;\nSpeakers: Ed Hu ang (co-founder/CTO of PingCAP)\, Kevin Xu (GM of U.S. at PingCAP) \; \n \;\nAs a special bonus for this meetup\, TiDB will hold a busines s card raffle for a Google Home Mini at the end of the presentation. \;\n \;\nOur meetup host this month will be software maker Eleven. 3\;\n \;\nPLEASE RSVP on Meetup.com if you can\, so that we can get a headcount for food.\n\nTags: kubernetes\, docker\, containers\, cloud\, databases\, postgresql\, mysql\n\nImported from: http://calagator.org/e vents/1250474255 URL:https://www.meetup.com/Cloud-Native-PDX/events/253766653 SUMMARY:CNPDX Sept: Cloud-Native Databases with TiDB LOCATION:Eleven: 318 SW 11th St.\, 3rd Floor\, Portland OR 97205 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190105T021558Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190124T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190124T180000 DTSTAMP;VALUE=DATE-TIME:20190105T021558Z LAST-MODIFIED;VALUE=DATE-TIME:20190105T021558Z UID:http://calagator.org/events/1250474769 DESCRIPTION:Note new location and we are meeting the 4th Thursday this mo nth! \;\n \;\npdxpug.wordpress.com \;\n \;\nBDR (bi-directio nal replication) enables asynchronous multi-master replication in Postgr es as an extension and has been in full production status since 2014. We will discuss the use cases that BDR is most appropriate for\, and where is might not be best suited. \;\n \;\nMark works at 2ndQuadrant a s a consultant for English Speaking Territories\, based out of Oregon. H e is a Contributor to PostgreSQL\, co-organizer of the Portland PostgreS QL User Group\, and serves as a Director and Treasurer for the United St ates PostgreSQL Association.\n\nTags: pdxpug\, postgres\, postgresql\, b dr\, replication\, multi-master\n\nImported from: http://calagator.org/e vents/1250474769 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Bi-Directional Replication for Postgres LOCATION:New Relic: 111 SW 5th Avenue\, Suite 2700\, Portland Oregon 9720 4 United States SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190206T194854Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T180000 DTSTAMP;VALUE=DATE-TIME:20190206T194854Z LAST-MODIFIED;VALUE=DATE-TIME:20190206T194854Z UID:http://calagator.org/events/1250475002 DESCRIPTION:Temporal databases let you record history: either a history o f the database (what the table used to say)\, a history of the thing its elf (what it used to be)\, or both at once. The theory of temporal datab ases goes back to the 90s\, but standardization has only just begun with some modest recommendations in SQL:2011\, and database products (includ ing Postgres) are still missing major functionality. \;\n \;\nThis talk will cover how temporal tables are structured\, how they are queri ed and updated\, what SQL:2011 offers (and doesn't)\, what functionality Postgres has already\, and what remains to be built. \;\n \;\nPau l started programming on a Tandy 1000 at age 8 and hasn't been able to s top since. He helped build one of the Mac's first web servers in 1994 an d has founded software companies in politics and technical hiring. He wo rks as an independent consultant specializing in Rails\, Postgres\, and Chef.\n\nTags: postgres\, postgresql\, pdxpug\, temporal\n\nImported fro m: http://calagator.org/events/1250475002 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: Temporal Databases: Theory and Postgres LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190306T141445Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190321T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190321T180000 DTSTAMP;VALUE=DATE-TIME:20190306T141445Z LAST-MODIFIED;VALUE=DATE-TIME:20190306T141445Z UID:http://calagator.org/events/1250475200 DESCRIPTION:Speaker: Hannah Stepanek \;\n \;\nLet’s talk databases in python! What’s an ORM? Is there a way to write database queries so th at they are compatible with multiple types of databases? How do you make database changes (such as adding a new table or a new column) safely? W hat is a connection pool and why is it useful? What are some things that can go wrong when operating at scale? In this talk we’ll take a deep di ve into how the python libraries sqlalchemy and alembic make managing pr oduction databases simple\, efficient\, and painless so you can get back to feature development. \;\n \;\nHannah has been working in indus try for over 6 years as a python software engineer. She currently works at Hypothesis\, a web application for annotating web pages and pdfs. In her spare time she enjoys riding her horse Sophie and playing board game s.\n\nTags: pdxpug\, postgres\, postgresql\, python\, orm\n\nImported fr om: http://calagator.org/events/1250475200 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: March Meetup: Let’s talk databases in python! LOCATION:PDX Code Guild: 2828 SW Corbett Ave #208\, Portland OR 97201 Uni ted States SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190410T171745Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190418T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190418T180000 DTSTAMP;VALUE=DATE-TIME:20190410T171745Z LAST-MODIFIED;VALUE=DATE-TIME:20190410T171745Z UID:http://calagator.org/events/1250475419 DESCRIPTION:Speaker: Grant Holly \;\n \;\nThis month I will be demo nstrating using non-blocking IO database access using Scala and the Slic k library. No really\, the library is called Slick AND it is very cool to use. Slick and Scala are great for working with Postgres with either straight SQL\, or using the FRM (that’s a Functional Relation Mapper li ke in functional programming). After Hannah gave a great talk talk abou t Python\, Postgres\, and ORMs\, I got to thinking that I could do a lan guage and ORM talk. Thanks Hannah\, that was great. \;\n \;\nhttp s://github.com/grantholly/pdx_pug_scala_and_pg \;\n \;\nHi\, it’s me still Grant. I work at New Relic as an engineer on the database engi neering team. I’ve been using Postgres in production since 9.2 and have been using and enjoying Scala for about two years having worked on a co uple of production high throughput applications.\n\nTags: pdxpug\, postg res\, postgresql\, scala\n\nImported from: http://calagator.org/events/1 250475419 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Postgres with non-blocking IO and Scala LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190514T221434Z DTEND;VALUE=DATE:20190518 DTSTART;VALUE=DATE:20190516 DTSTAMP;VALUE=DATE-TIME:20190514T221434Z LAST-MODIFIED;VALUE=DATE-TIME:20190514T221434Z UID:http://calagator.org/events/1250475606 DESCRIPTION:This event runs from Thursday\, May 16\, 2019 at 6pm through Friday\, May 17\, 2019 at 8pm.\n\nDescription:\nLearn about the consider ations in planning for disaster recovery in order to maintain business c ontinuity. There are solutions available that can help you achieve your backup and recovery objectives by taking advantage of PostgreSQL feature s\, such as point-in-time recovery\, and help implement retention polici es. \;\n \;\nAlso learn how to take advantage of PostgreSQL’s repl ication features to keep your database highly-available\, and the basic cluster architectures to consider to keep a PostgreSQL cluster up and ru nning. \;\n \;\nMark works at 2ndQuadrant as a consultant for Engl ish Speaking Territories\, based out of Oregon. He is a Contributor to P ostgreSQL\, co-organizer of the Portland PostgreSQL User Group\, and ser ves as a Director and Treasurer for the United States PostgreSQL Associa tion.\n\nTags: pdxpug\, postgres\, postgresql\n\nImported from: http://c alagator.org/events/1250475606 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Disaster Recovery and High Availability Planning LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190605T160755Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190620T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190620T180000 DTSTAMP;VALUE=DATE-TIME:20190605T160755Z LAST-MODIFIED;VALUE=DATE-TIME:20190605T160755Z UID:http://calagator.org/events/1250475705 DESCRIPTION:Speaker: Will McLean \;\n \;\nTo follow the presentatio ns on accessing Postgres from Python and Scala\, I will lead a discussio n on accessing Postgres with Java. I'll start with a jdbc tutorial and f inish with adding data access to a springboot webapp. \;\n \;\nI h ave twenty years experience in e-commerce applications\, the last eight here in Portland\, mostly at Nike.For the last few years everything has been moving to Amazon RDS Postgres\, that's a trend pdxpug can get behin d! \;\nI am currently working for Navis on CRM applications for the h ospitality industry.\n\nTags: pdxpug\, postgres\, postgresql\, java\, cr m\, springbot\n\nImported from: http://calagator.org/events/1250475705 URL:https://pdx.postgresql.us SUMMARY:PDXPUG Meetup: Accessing Postgres with Java LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190806T044445Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190815T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190815T180000 DTSTAMP;VALUE=DATE-TIME:20190806T044445Z LAST-MODIFIED;VALUE=DATE-TIME:20190806T044445Z UID:http://calagator.org/events/1250475956 DESCRIPTION:Jackson will discuss the basics of GIS\, and the current envi ronment in which enterprise spatial analytics are performed. Considering the many pitfalls of this current system\, he will discuss how FOSS too ls – especially PostgreSQL/PostGIS – are vitally important for modern sp atial analytics. In addition to the PostGIS extension\, Jackson will tal k about network routing using the PgRouting extension and the interface between R and PostgreSQL. This talk will act more as a showcase of GIS a nd “spatial SQL” within PostgreSQL than it will nitty-gritty database de velopment. \;\n \;\nJackson Voelkel is a Health Data Analyst on Ka iser Permanente’s GIS Team as well as an Adjunct Professor of Geography at Portland State University. He focuses on developing infrastructure fo r and performing advanced spatial analytics across healthcare\, environm ent\, urban planning\, utilities\, and econometrics. He teaches courses on advanced spatial analytics in R as well as spatial database design wi th PostgreSQL/PostGIS.\n\nTags: pdxpug\, postgres\, postgresql\, gis\, p ostgis\n\nImported from: http://calagator.org/events/1250475956 URL:https://pdx.postgresql.us SUMMARY:PDXPUG August Meetup: PostGIS LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190917T032340Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190919T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190919T180000 DTSTAMP;VALUE=DATE-TIME:20190917T032340Z LAST-MODIFIED;VALUE=DATE-TIME:20190917T032340Z UID:http://calagator.org/events/1250476209 DESCRIPTION:This month I am going to be talking about my current work on sharding large mysql databases with Vitess. My team has been on a journ ey towards splitting our largest mysql databases and I want to share my experiences and lessons learned. We are going to look at the problems a nd possible solutions to scaling reads and writes in relational database s. \;\n \;\nVitess is an open source project born at youtube to sc ale their largest and most critical databases. It has been adopted in a s a Cloud Native Compute Foundation incubator project. With PostgreSQL on the medium-term road map\, let’s take a look at what we have been abl e to do with mysql. \;\n \;\nHi its me Grant. I work on the datab ase engineering team at New Relic. I’ve been using Postgres in producti on since 9.2. I co-organize the Postgres user group in Portland with Ma rk Wong.\n\nTags: pdxpug\, postgres\, postgresql\, mysql\, vitess\n\nImp orted from: http://calagator.org/events/1250476209 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Sharding large MySQL databases with Vitess LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20191009T160136Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191017T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191017T180000 DTSTAMP;VALUE=DATE-TIME:20191009T160136Z LAST-MODIFIED;VALUE=DATE-TIME:20191009T160136Z UID:http://calagator.org/events/1250476315 DESCRIPTION:pg_top was born in 2007 from a fork of the unixtop\, a termin al program displaying top processes on the system\, where pg_top focuses on the processes with the PostgreSQL database you are connected to. Rec ently pg_systat was forked from systat to display additional database st atistics. \;\n \;\nThese tools have can help do more such as explo re query execution plans and create reports from system and database res ources. \;\n \;\nCome learn about the statistics PostgreSQL keeps and how to use these tools to view them. \;\n \;\nMark leads the 2 ndQuadrant performance practice as a Performance Consultant for English Speaking Territories\, based out of Oregon in the USA. He is a long time Contributor to PostgreSQL\, co-organizer of the Portland PostgreSQL Use r Group\, and serves as a Director and Treasurer for the United States P ostgreSQL Association.\n\nTags: postgres\, postgresql\, pdxpug\, pg_top\ , pg_systat\, pg_proctab\n\nImported from: http://calagator.org/events/1 250476315 URL:https://pdx.postgresql.us SUMMARY:PDXPUG October Meetup: Terminal Tools & Database Statistics LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200115T180802Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200116T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200116T180000 DTSTAMP;VALUE=DATE-TIME:20200115T180802Z LAST-MODIFIED;VALUE=DATE-TIME:20200115T180802Z UID:http://calagator.org/events/1250476695 DESCRIPTION:Speaker: Alex Theodore \;\n \;\nAs a CTO I saw everythi ng that went into and came out of the web development process\, from the "\;client needs"\; to the source-controlled code. But being ski lled in database development showed me time and time again that database s (and their architecture) were often sidelined treated as after-thought s and often times served as little more than flexible storage spaces. Ye t\, their contents were the very essence of value for the process/client /company being served. This strange inversion of priorities led me to de velop a way of looking at databases as "\;outside"\; the applica tion and ultimately to interacting with them as API's. In my talk I'll b e presenting this concept and showing with simple rules and examples how it can be done. \;\n \;\nBio: \;\n \;\nI was the product an d technology founder of Fracture.me and CTO up until 2018 where I develo ped the manufacturing processes and ERP software that powered our produc tion process. That got me deeply involved in database work\, especially with architecture and process design and optimization. Now I work part t ime as a database consultant and part time building modern\, minimalisti c furniture for my new (small) company MillFinish.com. \;\n \;\n\n \nTags: pdxpug\, postgres\, postgresql\n\nImported from: http://calagato r.org/events/1250476695 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Interacting with databases as API's LOCATION:Portland State Business Accelerator: 2828 SW Corbett Ave.\, Port land OR 97201 us SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200206T164845Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200220T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200220T180000 DTSTAMP;VALUE=DATE-TIME:20200206T164845Z LAST-MODIFIED;VALUE=DATE-TIME:20200206T164845Z UID:http://calagator.org/events/1250476774 DESCRIPTION:Speakers: Gabrielle Roth &\; Michelle Franz \;\n \;\ nIn February\, long-term PDXPUGers Michelle Franz &\; Gabrielle Roth return to discuss DBLINK and FDW\, two methods of accessing data that’s outside your database. We’ll briefly mention SQL/MED on the way\, and te ll a couple of bad (Dad) jokes. \;\n \;\nWe’ll cover use (and mis- use) cases\, configuration of each\, and interesting quirks. Gabrielle w ill attempt a live demo of file_fdw and postgres_fdw. You’re welcome to follow along if you’d like\, just show up with a couple of Pg databases: they can be on the same cluster (or container or RDS instance or what h ave you) or different ones\, doesn’t really matter. One of them should h ave at least one table with data in it. \;\n \;\nAbout the speaker s: \;\n \;\nFrom embedded systems to UI to relational database pro gramming\, Michelle’s running an interesting path through the software w orld. Working with databases is her current episode\, with some programm ing\, some DBA\, some SysAdmin and a healthy dose of learning agile. She ’s very quickly come to appreciate and enjoy working with Postgres and h er work has allowed her to learn from some super talented database exper ts. \;\n \;\nGabrielle has been using Postgres since sometime in t he version 7s\, and thinks that the best part of using Open Source softw are is the culture of sharing knowledge. She’s a Senior Data Engineer at NS1 and co-founder and former co-lead of PDXPUG.\n\nTags: postgres\, po stgresql\, pdxpug\, dblink\, fdw\, sql\n\nImported from: http://calagato r.org/events/1250476774 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG February 2020 Meetup: DBlink and SQL/MED and FDW\, oh my! External Data Access tricks LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200415T154356Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200423T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200423T183000 DTSTAMP;VALUE=DATE-TIME:20200415T154356Z LAST-MODIFIED;VALUE=DATE-TIME:20200415T154356Z UID:http://calagator.org/events/1250476979 DESCRIPTION:We are using Meetup.com to distribute the link to the online meeting [1]\, which will be set shortly before the meeting as we will be using Jitsi [2]. Meetup does require you to RSVP to get access to the link. Jitsi can be used directly with Firefox and Chrome (with extension )\, or phones/tablets with the Jitsi Meet app. \;\n \;\nSpeaker: P aul Jungwirth \;\n \;\nI'd like to present a couple patches I have in-progress for Postgres\, the first to add a new type called "\;mu ltiranges"\;\, and the second to add various SQL:2011 temporal datab ase features: temporal primary &\; foreign keys\, and temporal UPDATE and DELETE. I'll discuss what these features look like to users and als o highlight some of the implementation details behind them. \;\n \ ;\n[1] https://www.meetup.com/pdxpug/events/270062132/ \;\n[2] https: //jitsi.org \;\n\n\nTags: pdxpug\, postgres\, postgresql\, multirange s\, temporal\, datatypes\n\nImported from: http://calagator.org/events/1 250476979 URL:https://www.meetup.com/pdxpug/events/270062132/ SUMMARY:PDXPUG: Multiranges and SQL:2011 Temporal Features LOCATION:Online: placeholder for on-line events\, SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20221215T205235Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230119T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230119T183000 DTSTAMP;VALUE=DATE-TIME:20221215T205235Z LAST-MODIFIED;VALUE=DATE-TIME:20221215T205235Z UID:http://calagator.org/events/1250480086 DESCRIPTION:PostgreSQL 15 was released on October 13\, 2022 so let's give it a look! \;\n \;\nWe will shamelessly use a presentation readil y available on the internet to see all the newness in this latest releas e. \;\n \;\nCome learn what's new\, share experiences with changes \, or just meet with local peers! Casual\, informal.\n\nTags: postgres\, postgresql\, databases\n\nImported from: http://calagator.org/events/12 50480086 URL:https://www.meetup.com/pdxpug/events/290336190/ SUMMARY:PDXPUG: What's new in PostgreSQL 15 (Note last minute venue chang e.) LOCATION:PDX Code Guild: 407 NE 12th Avenue\, Portland OR 97232 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20230514T005531Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230518T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230518T183000 DTSTAMP;VALUE=DATE-TIME:20230514T005531Z LAST-MODIFIED;VALUE=DATE-TIME:20230514T005531Z UID:http://calagator.org/events/1250480524 DESCRIPTION:Getting started with Django is a delight. However\, as your a pplication grows\, that sqlite database you start with can become a limi tation. We are going to look at how to wire up a new Django project to P ostgres\, and we will talk about some of the neat features in Postgres a nd Django that you can utilize including JSON\, UDFs/procs\, and extensi ons to name a few. \;\n \;\nHopefully you can pick a few ideas\, o r even share your own with the group. This talk is for all levels of exp erience from “I just heard about Django” to “We run production Django”\, from “oh Postgres\, that’s the elephant one right?” to “Ask me anything about Postgres”. \;\n \;\nWe will also have zoom link available c loser to the presentation date if you want to attend remotely. Sign up on MeetUp for this notification: https://www.meetup.com/pdxpug/events/29 3519969/\n\nTags: postgres\, postgresql\, django\, python\n\nImported fr om: http://calagator.org/events/1250480524 URL:https://www.meetup.com/pdxpug/events/293519969/ SUMMARY:PDXPUG MeetUp: Django and Postgres LOCATION:PDX Code Guild: 407 NE 12th Avenue\, Portland OR 97232 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20230517T222306Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230615T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230615T183000 DTSTAMP;VALUE=DATE-TIME:20230517T222306Z LAST-MODIFIED;VALUE=DATE-TIME:20230517T222306Z UID:http://calagator.org/events/1250480527 DESCRIPTION:Few abstractions and tools have proved as enduring in the fie ld of Computer Science as the relational database model. Due to the dili gent efforts of the Postgres team\, the Postgres project has an ever inc reasing popularity in the software world and a fully modernized feature set. One effect of the longevity of the project has been to create a dee p pool of received wisdom regarding the use and misuse of Data Models an d SQL. Revisit some of the wisdom from a classic of the genre: SQL Antip atterns: Avoiding the Pitfalls of Database Programming by Bill Karwin\, with updated opinions and commentary to modernize the material. Stay aft er for pizza and a rousing exchange of ideas on the past\, present\, and future of SQL and of the Postgres project. \;\n \;\nSpeaker: Jose ph Hammerman \;\n \;\nJoseph Hammerman is a Linux Systems Administ rator and Database Reliability Engineer with 18 years of experience. For the last 10 years that work has focused on Postgresql database reliabil ity and High Availability engineering practices. Some career highlights include: serving on the iHeartRadio launch team\, working at SecondMarke t prior to and during their acquisition by NASDAQ Private Markets\, and founding and serving on the Squarespace Database Reliability Engineering team. He is currently employed as Technical Lead for the DataDog Postgr esql database reliability engineering team. He is a passionate advocate of Free and Open Source software and the ideals that it embodies.\n\nTag s: postgres\, postgresql\, sql\, antipatterns\n\nImported from: http://c alagator.org/events/1250480527 URL:https://www.meetup.com/pdxpug/events/293599321/ SUMMARY:PDXPUG: SQL Antipatterns LOCATION:PDX Code Guild: 2828 SW Corbett Ave\, Portland OR 97201 us SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20230804T005513Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230817T083000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230817T063000 DTSTAMP;VALUE=DATE-TIME:20230804T005513Z LAST-MODIFIED;VALUE=DATE-TIME:20230817T231158Z UID:http://calagator.org/events/1250480640 DESCRIPTION:Speaker: Jerry Sievert \;\n \;\nExtensions are part of what makes Postgres such a powerful and popular database. Being able to add new capabilities to your database allows developers to adapt Postgre s to many different use cases from geospatial (PostGIS)\, to multi-serve r sharding (Citus)\, to custom datatypes (pg_semver)\, to foreign data w rappers (postgres_fdw)\, and others. \;\n \;\nJerry is going to wa lk us through getting started working on database extensions. We will co ver how extensions work and getting started authoring your very own firs t database extension! Time permitting\, and with interest\, we will cove r operators and types. This talk is intended for all developers and DBA’ s alike\, so bring your questions. If you have a favorite extension\, we want to know\, so bring it to the discussion. I’ll go first: favorite e xtension: most flavors of FDW’s for sure. \;\n \;\nNow a bit about Jerry. He’s currently working at Hydra (https://hydra.so/) on data ware housing with Postgres\, but has been using Postgres for waaaay too long. If you’ve ever used PLJS (https://github.com/plv8/pljs)\, he’s the auth or\, and he is the maintainer of PLV8 (https://plv8.github.io/).\n\nTags : postgres\, postgresql\n\nImported from: http://calagator.org/events/12 50480640 URL:https://www.meetup.com/pdxpug/events/295229582/ SUMMARY:PDXPUG: Developing Your Own Database Extensions LOCATION:WeWork: 830 NE Holldaday St\, Portland Oregon 97232 USA SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20231020T233446Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20231102T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20231102T183000 DTSTAMP;VALUE=DATE-TIME:20231020T233446Z LAST-MODIFIED;VALUE=DATE-TIME:20231020T233446Z UID:http://calagator.org/events/1250480741 DESCRIPTION:PostgreSQL 16 was released on September 14\, 2023 so let's gi ve it a look! \;\n \;\nWe will shamelessly use a presentation read ily available on the internet to see all the newness in this latest rele ase. \;\n \;\nCome learn what's new\, share experiences with chang es\, or just meet with local peers! Casual\, informal. \;\n \;\nNo te that this will be the last PDXPUG meeting of the year until 2024.\n\n Tags: postgres\, postgresql\, pgsql\n\nImported from: http://calagator.o rg/events/1250480741 URL:https://www.meetup.com/pdxpug/events/296865128/ SUMMARY:PDXPUG: What's new in PostgreSQL 16 LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20240214T021517Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240215T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240215T183000 DTSTAMP;VALUE=DATE-TIME:20240214T021517Z LAST-MODIFIED;VALUE=DATE-TIME:20240214T021517Z UID:http://calagator.org/events/1250480973 DESCRIPTION:Speaker: Grant Holly \;\n \;\nMoving a live production dataset between servers is hard to do. I’m going to share a few examples of how I’ve been able to move data and workloads between servers withou t downtime\, dropped writes\, or stale reads. I had to break out more th an a few Postgres tricks like logical replication\, foreign data wrapper s\, and writable views\, all of which we will be reviewing. \;\n \ ;\nMy goal is to share a few strategies that have worked and how they ha ndle the common difficulties with moving live datasets. Please bring you r own stories and questions and add to the conversation.\n\nTags: postgr es\, postgresql\n\nImported from: http://calagator.org/events/1250480973 URL:https://www.meetup.com/pdxpug/events/299185648/ SUMMARY:PDXPUG: Zero Downtime: Live Data and Server Migrations LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20240329T184614Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240418T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240418T183000 DTSTAMP;VALUE=DATE-TIME:20240329T184614Z LAST-MODIFIED;VALUE=DATE-TIME:20240329T184614Z UID:http://calagator.org/events/1250481024 DESCRIPTION:PostgreSQL 17 is in feature freeze. The expected release date is sometime this September. \;\n \;\nWe will review freely availa ble presentations available on the internet to see what we can can expec t in the next major release. \;\n \;\nCome learn what's new\, shar e experiences with changes\, or just meet with local peers! Casual\, inf ormal. \;\n \;\nPlease RSVP in the MeetUp link to help us gauge ex pected attendance. https://www.meetup.com/pdxpug/events/300096141/\n\nTa gs: postgres\, postgresql\n\nImported from: http://calagator.org/events/ 1250481024 URL:https://www.meetup.com/pdxpug/events/300096141/ SUMMARY:PDXPUG: What's coming up in PostgreSQL 17 LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20240814T230142Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240822T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240822T183000 DTSTAMP;VALUE=DATE-TIME:20240814T230142Z LAST-MODIFIED;VALUE=DATE-TIME:20240814T230142Z UID:http://calagator.org/events/1250481254 DESCRIPTION:Speaker: Paul Jungwirth \;\n \;\nBenchmarking is an imp ortant part of developing database systems like Postgres. For businesses \, benchmarking can guide important decisions around selecting a databas e management system\, or evaluate configuration changes. However\, while there are many standard benchmarks out there\, setting up\, configuring \, running\, and collecting results was left as an exercise to the reade r. \;\n \;\nBenchbase is an open-source benchmarking framework fro m Carnegie Melon University’s Database Group (https://github.com/cmu-db/ benchbase). It helps you configure\, run\, and collect results from vari ous standard benchmarks. It also provides a framework for authoring your own performance benchmarks\, and wiring it up to the batteries-included configuration\, running\, and results collection provided by it. \;\ n \;\nPaul is going to walk us through Benchbase\, and some recent wo rk he has embarked on around creating a benchmark. If you are a veteran of benchmarking\, or have never done a benchmark before\, this talk is f or everyone. \;\n \;\nNow a bit about Paul. He’s a freelance softw are developer here in Portland\, and has been building applications with Postgres since 2011. Paul has been working on the Postgres project itse lf. He’s authored many database extensions\, and his contributions to Po stgres include work on GiST indexes\, multiranges\, and SQL:2011 applica tion-time features.\n\nTags: postgres\, postgresql\, benchmarking\, benc hbase\n\nImported from: http://calagator.org/events/1250481254 URL:https://www.meetup.com/pdxpug/events/302834998/ SUMMARY:PDXPUG: Benchmarking with Benchbase LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20241218T203051Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250116T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250116T183000 DTSTAMP;VALUE=DATE-TIME:20241218T203051Z LAST-MODIFIED;VALUE=DATE-TIME:20241218T203051Z UID:http://calagator.org/events/1250481694 DESCRIPTION:PostgreSQL 17 was release September 26\, 2024. \;\n \;\ nWe will review freely available presentations available on the internet . \;\n \;\nCome learn what's new\, share experiences\, or just mee t with local peers! Casual\, informal.\n\nTags: postgres\, postgresql\n\ nImported from: http://calagator.org/events/1250481694 URL:https://www.meetup.com/pdxpug/events/305148196/ SUMMARY:PDXPUG: What's new in PostgreSQL 17 LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20250123T210418Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250220T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250220T183000 DTSTAMP;VALUE=DATE-TIME:20250123T210418Z LAST-MODIFIED;VALUE=DATE-TIME:20250123T210418Z UID:http://calagator.org/events/1250481749 DESCRIPTION:Postgres has a wide array of supported authentication methods . The \;\nstrongest methods have trouble scaling across large numbers of \;\ndatabase instances\, though\, and while organizations have wa ys to \;\ncentralize user credentials -- for example by using LDAP or Kerberos \;\n-- those solutions come with their own large lists of c aveats.I'm \;\ncurrently developing Postgres-native support for OAuth \, which is a \;\nwidely-deployed framework for authorizing clients u sing a third-party \;\nprovider. I'll talk about the current state of the patchset\, explain \;\nsome of the elements of the design\, and demonstrate what it might look \;\nlike to deploy it yourself.\n\nTag s: postgres\, postgresql\, oauth\n\nImported from: http://calagator.org/ events/1250481749 URL:https://www.meetup.com/pdxpug/events/305777417/ SUMMARY:PDXPUG Meetup: OAuth Support in PostgreSQL LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20260120T220648Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20260219T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20260219T183000 DTSTAMP;VALUE=DATE-TIME:20260120T220648Z LAST-MODIFIED;VALUE=DATE-TIME:20260120T220648Z UID:http://calagator.org/events/1250482416 DESCRIPTION:Please note different location at Multnomah Arts Center. Also \, please RSVP on MeetUp as space is limited: https://www.meetup.com/pdx pug/events/312977438/ \;\n \;\nPostgreSQL 18 was released Septembe r 25\, 2025. \;\n \;\nWe will review freely available presentation s available on the internet. \;\n \;\nCome learn what's new\, shar e experiences\, or just meet with local peers! Casual\, informal.\n\nTag s: pdxpug\, postgres\, postgresql\n\nImported from: http://calagator.org /events/1250482416 URL:https://www.meetup.com/pdxpug/events/312977438/ SUMMARY:PDXPUG: Portland PostgreSQL Users Meetup : What's new in PostgreS QL 18 LOCATION:Multnomah Arts Center: 7688 Sw Capitol Hwy\, Portland OR 97219 U S SEQUENCE:1 END:VEVENT END:VCALENDAR