PostgreSQL 17 is in feature freeze. The expected release date is sometime this September.

We will review freely available presentations available on the internet to see what we can can expect in the next major release.

Come learn what's new, share experiences with changes, or just meet with local peers! Casual, informal.

Please RSVP in the MeetUp link to help us gauge expected attendance. https://www.meetup.com/pdxpug/events/300096141/

Speaker: Grant Holly

Moving 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 without downtime, dropped writes, or stale reads. I had to break out more than a few Postgres tricks like logical replication, foreign data wrappers, and writable views, all of which we will be reviewing.

My goal is to share a few strategies that have worked and how they handle the common difficulties with moving live datasets. Please bring your own stories and questions and add to the conversation.

PostgreSQL 16 was released on September 14, 2023 so let's give it a look!

We will shamelessly use a presentation readily available on the internet to see all the newness in this latest release.

Come learn what's new, share experiences with changes, or just meet with local peers! Casual, informal.

Note that this will be the last PDXPUG meeting of the year until 2024.

See web link for details.

Advanced signup is required.

We have some special out-of-town guests here for OSCON, so we're having a special meeting for July. Details will be posted on the pdxpug website: http://wp.me/p25MlK-4r

Note that this is not our regular meeting time, day, or location!

See PDXPUG blog (linked) for details.

When: 7-9pm Thu Sep 15, 2011 Where: FreeGeek Who: Joshua Drake What: Practical PostgreSQL Performance

This presentation provides down tot earth performance advice.

Joshua D. Drake (JD) is lead consultant at Command Prompt, Inc. and President of PgUS.

Beer afterwards at the Lucky Lab. See you there!

Rob Wultsch, a recent addition to Facebook's Database Operations team, will compare and contrast the Facebook deployment with his previous work with another large deployment of open source databases. In this db-agnostic talk, he'll go over: the bizarre becoming ordinary, the many types of infrastructure that do not scale and what does and does not work when building a DBA team.

Before joining Facebook, Rob worked for a very large hosting company as a database administrator and a newspaper as a web developer. In his free time he enjoys riding his motorcycle and bicycle and fantasizes about moving to Portland.

As always, beer afterwards at the Lucky Lab. See you there!

This month's topic is "Data Visualization and Exploration Techniques Using R and Postgres" with PSU's Dr Christopher Monsere.

Full details: http://pugs.postgresql.org/node/1669

Normally, Gabrielle ensures that we have thoughtful and informative presentations. Unfortunately for you, I -- Melissa -- am guest-hosting this month.

What I'll come up with is anyone's guess, but BYOB is strongly recommended. Muahahaha.

Oh, and we may also talk about Postgres or something. And we'll join those folks at the Lucky Lab afterwards.

This month's meeting marks the fourth installment in our "Founders Series"..

When: 7-9pm Thu Apr 21, 2011 Where: FreeGeek Who: David Wheeler What: Distributing Extensions on PGXN

So you've solved a common problem in PostgreSQL, a serious pain point that lots of other people could take advantage of. You want to open-source the code, and would like to package it up and distribute it where people can find it, read its docs, and download and install it.

The newest destination for distributing PostgreSQL extensions is PGXN, the PostgreSQL Extension network. PGXN offers a central index of PostgreSQL extensions and their documentation, making it easy for people to find an install extensions.

How do you optimize your extension distribution for maximum PGXN exposure? By careful packaging, thorough documentation, and simple installation. Join me for an overview of how best to achieve that — including how to build extensions compatible with PostgreSQL 9.1's improved extension support.

David Wheeler is an associate at PGExperts, and is responsible for PGXN, the PostgreSQL Extension Network) and pgTAP. He's into testing and extension distribution.

Beer afterwards at the Lucky Lab. See you there!

See http://pugs.postgresql.org/node/1660 for talk description.

Selena Deckelmann will be talking about managing terabyte instances of PostgreSQL.

This will be a preview of her MySQL Users Conference talk:

http://en.oreilly.com/mysql2011/public/schedule/detail/17195

Size can creep up on you. Some 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 easier for administrators and application developers working with big data.

This talk will lead you through solutions to problems Postgres 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 know the right places to look to spot problems early. We’ll also go over monitoring best practices and open source tools to get the job done.

Working 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 features in 9.0. War stories will be taken from real-world work with Emma, an email marketing company with a few large databases.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 21 Oct, 2010 Who: Aurynn Shaw What: PostgreSQL and node.js

Postgres and Node.js, a powerful event-driven programming environment paired with our favourite open-source database, now together in the same great package! Aurynn will be going over the node.js environment, how it differs from other programming environments, and how to use postgres with node.

Aurynn Shaw is Lead Userspace Developer at Command Prompt, Inc. She has come all the way from another country to present this talk, so don't miss it!

Beer afterwards at the Lucky Lab.

See you there!

Location-based services are all the rage these days, and almost everyone 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 information systems are becoming increasingly visible. With the PostGIS extension, PostgreSQL is a first-class geodatabase and an incredible platform 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 your database. This talk will cover GIS and PostGIS basics and provide an introduction to geodatabases and spatial queries.

--

Edwin Knuth spent quite some time as a sysadmin and web developer before going back to school to study Environmental Science at the University of Alaska Southeast. He quickly became fascinated with Geographic Information Systems and realized that GIS was just a really neat database application. In Alaska, Edwin worked on several unique projects, including building bat detectors and using PostGIS to manage a wireless sensor network on the Juneau Icefield. He has lived in Portland for the past year and loves it very much.

Then a trip to the Lucky Lab after.

Jonathan Leto will be talking about "PL/Parrot and PL/Perl6 - Parrots and Butterflies in your Database".

Beer afterwards at the SE Lucky Lab.

Brian Kurle will be giving a talk about his experiences on architecting and developing a middleware system for Decagon Devices that collects data from remote devices via GSM and provides aggregated data via the web to users with PostgreSQL as the central database.

Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterward.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Mark & gabrielle What: What's new in 9.0

Drinks afterward at the SE Lucky Lab.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Melissa Hollingsworth What: Normalization!

Drinks afterward at the SE Lucky Lab.

Tim Bruce will be speaking at the next PDXPUG meeting at FreeGeek (at 7:00pm - 1731 SE 10th Avenue, Portland, OR).

An Introduction to Managing and Troubleshooting PostgreSQL on Windows

This talk will be for entry-level to mid-level Windows Administrators who have to support PostgreSQL on Windows (Windows Server or Windows Desktops). I'll touch on managing the service(s) and checking the Windows logs, as well as some quick ways to look for performance of the Operating System and PostgreSQL with the built-in tools on Microsoft Windows.

Tim Bruce is a Database Administrator for Fiserv Enterprise Technology. He is spread between Microsoft SQL Server on Windows and PostgreSQL running on SuSE Linux. In his spare time, he supports several Emergency Service organizations including the Washington County Composite Squadron of the Civil Air Patrol.

Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterward.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 18 Mar, 2010 Who: you! What: PostgreSQL 9.0alpha testing party

Drinks afterward at the SE Lucky Lab.

Over Normalization from a developers point of view.

Ben Hengst works for Powells.com and has been involved in some in house restructuring, mostly centered around moving to a very vertical structure. This talk will revolve around what works and what doesn't, code and people problems that have been encountered and how to dig your self out.

Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.

The Portland PostgreSQL Users Group (PDXPUG)

John Naylor will be talking about his experience in Florida as a data manager for President Obama's 2008 campaign. He will discuss the role of data in political campaigns, and also refactor some data warehouse queries. Donuts and bacon provided.

Refreshments will be partaken at the Lucky Labrador Pub in SE Portland afterward.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 19 Nov, 2009 Who: Dan Colish What: Materialized Views (with cupcakes)

Drinks afterward at the SE Lucky Lab.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 15 Oct, 2009 Who: Selena Deckelmann What: Bucardo: Replication with tiny little goats

Drinks afterward at the SE Lucky Lab.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 17 Sept, 2009 Who: David Wheeler What: Unit Test Your Database!

Drinks afterward at the SE Lucky Lab.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

Where: FreeGeek When: 7pm 20 August, 2009 Who: Jim Cser What: Metro simulation database

Drinks afterward at the SE Lucky Lab.

Webb Sprague will be speaking about PostGIS and the Census Data at the next PDXPUG meeting at FreeGeek (at 7:00pm - 1731 SE 10th Avenue, Portland, OR).

Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.

More details from Webb:

If anyone is wondering about specifics, I will describe how I recently created a "crosswalk" table that correlates census tracts in 1980 with census tracts in 2000 in the Portland region (well, Washington, Multnomah, and Clackamas counties), so that we could see poverty trends over the last 25 years.

I used PostGIS, Census naming conventions ("FIPS codes"), and lots of outer joins. So if you like that sort of thing, I would love to hear your comments tomorrow!