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: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 BEGIN:DAYLIGHT DTSTART:20090308T020000 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 END:VTIMEZONE 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: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: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: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: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: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: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: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: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:20140120T161214Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140125T140000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140125T100000 DTSTAMP;VALUE=DATE-TIME:20140120T161214Z LAST-MODIFIED;VALUE=DATE-TIME:20140120T161214Z UID:http://calagator.org/events/1250465548 DESCRIPTION:See web link for details. \;\n \;\nAdvanced signup is r equired.\n\nTags: pdxpug\, postgres\n\nImported from: http://calagator.o rg/events/1250465548 URL:http://pdxpug.wordpress.com/2013/12/30/streaming-rep-saturday/ SUMMARY:PDXPUG: Streaming Rep Saturday workshop LOCATION:Emma: 524 E Burnside St.\, Suite 510\, Portland Oregon 97214 Uni ted States 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: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: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: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: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: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: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: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: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