Portland PostgreSQL Day (PDXPUG PGDay) 2018

The Portland PostgreSQL Users Group (PDXPUG), Portland State University Maseeh College of Engineering and Computer Science, and Datalab, the PSU Data and Information Management Laboratory and are proud to present a day of presentations about PostgreSQL.

More information at https://pdx.postgresql.us/pdxpgday2018

Advertisements

Postgres container workflows

When: 6-8pm Thursday March 15, 2018

Ahoy database folk!  Time for another meetup and more container chit chat.  Yeah yeah, you, like me, have heard that you shouldn’t run databases in containers.  Well without throwing all caution to the wind, I’m hoping to show you guys some container workflows with Postgres that I’ve been using lately.  We’ll talk a bit about why you haven’t been running databases in containers, then walk through some development work flows with Postgres, and lastly look at options for deploying and running persistent databases in containers.

https://github.com/grantholly/pg_docker

———

Hi, its me Grant Holly.  I work at Iovation on the data science and analytics team wrangling our data into visualizations and machine learning models.  I live in SE, play in bands, and am a learning machine.

———

NEW MEETING LOCATION

Our meeting will still be held at iovation, but now on the 3rd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines.  For access to the 3rd floor of the plaza, please either take the lobby stairs to the third floor or take the plaza elevator (near Subway and Rabbit’s Cafe) to the third floor. There will be signs directing you to the meeting room.

February 2018 Meeting: Automatic For The People

When: 6-8pm Thursday February 15, 2018

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, and your DBAs
can take the weekend off.

Josh Berkus will explain 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!

———

Josh Berkus helps manage the Kubernetes community for Red Hat. He is a
“hacker emeritus” for PostgreSQL. He lives in NE Portland with a large
black cat, a pottery studio, and a librarian.

———

NEW MEETING LOCATION

Our meeting will still be held at iovation, but now on the 3rd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines.  For access to the 3rd floor of the plaza, please either take the lobby stairs to the third floor or take the plaza elevator (near Subway and Rabbit’s Cafe) to the third floor. There will be signs directing you to the meeting room.

PDXPUG: October meeting in one week

When: 6-8pm Thursday October 19, 2017
Where: iovation
Who: Grant Holly
What: Golang + Pg

This month, Grant will be talking about using Golang with Postgres 9.6 and showing us some of the client libraries.

Grant Holly is a Service Reliability Engineer at iovation, where he works with a lot of different database systems.

https://github.com/grantholly/pdx_pug_go_and_pg


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our 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 parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!

PDXPUG September meeting in 1 week

… ok, maybe a bit less than a week.

When: 6-8pm Thursday Sept 21, 2017
Where: iovation
Who: Mark Wong
What: Postgres BI Performeant & News From the Pg-XL Project

If you missed Postgres Open, here’s your chance to catch one of the talks!

Mark will share performance improvements in analytical / BI workloads in recent PostgreSQL releases, illustrated with results from multiple major versions, and also about what additional improvements might happen in the near future. He’ll will also discuss news from Postgres-XL, the distributed PostgreSQL fork, and how it compares to the current PostgreSQL in this area.

Mark leads the 2ndQuadrant performance practice as a Performance Consultant for English Speaking Territories, based out of Oregon in the USA.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our 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 parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!

PostgreSQL 10 Beta

When: 6-8pm Thursday July 20, 2017
Where: iovation
Who: Josh Berkus
What: PostgreSQL 10 Beta

 

PostgreSQL 10 is now out in beta. We called it 10 because this 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.

Josh Berkus recently retired from the PostgreSQL Core Team and is currently working for Redhat as the Project Atomic Community Lead.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our 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 parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

PDXPUG: June meeting

When: 6-8pm Thursday June 15, 2017
Where: iovation
Who: Kevin Jernigan, AWS
What: Amazon Aurora (PostgreSQL)

In 2014, AWS announced Amazon Aurora – a cloud-native, MySQL-compatible relational database. Features include fault-tolerant, self-healing storage that allows customers to scale from 10 GB all the way up to 64 TB without pre-provisioning. Aurora makes six copies of data across three Availability Zones and backs it up to Amazon Simple Storage Service (S3) without impacting performance or availability. Customers can create up to 15 low-latency read replicas that draw from common storage.

In response to repeated customer requests for the same capabilities for PostgreSQL, AWS announced the Amazon Aurora PostgreSQL-compatible edition in late 2016.

In this talk we’ll cover what makes Aurora (PostgreSQL) different from PostgreSQL, as well as what remains the same. We’ll discuss compatibility, scalability and performance. Please bring your scenarios, questions and requests!


Kevin Jernigan is a Senior Product Manager in the Amazon Relational Database Services (RDS) team. His deep database engine experience spans Oracle, Ingres, Informix, DB2, and PostgreSQL. He lives in San Francisco, and when not working on database engines loves to play squash and spend time with his wife and kids.


If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Our 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 parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

iovation provides us a light dinner (usually sandwiches or pizza).

Elevators open at 5:45 and building security closes access to the floor at 6:30.

See you there!