• PostgreSQL 14: What's New! with Christophe Pettus

    Online event

    Join us virtually on October 13, 2021 as Christophe Pettus presents, "PostgreSQL 14: What's New!"

    PostgreSQL version 14 is out, and it is full of lots of interesting improvements. Join us for a summary of what they are, and how you can use them around the house.

    Christophe Pettus is the CEO and lead consultant of PostgreSQL Experts, Inc., a decade-old independent PostgreSQL consultancy.

    Schedule:
    11:50 AM: GoToMeeting room opens.
    12:00 PM Announcements, speaker introduction, presentation, Q&A.
    1:15 PM Closing announcements, wrap up.
    1:30 PM Event ends.

    Link for the GoToMeeting room has been sent on October 12, 2021.

    You can use GoToMeeting directly in your browser.

    You can also download and install the app ahead of time:
    https://global.gotomeeting.com/install/375084917

    And yes, you can customize your background!
    https://global.gotomeeting.com/#/settings/custom-background

    We will open the meeting room around 11:50 AM. If you try to log in prior to this time, the system will give you a message that the room is not available, and to try logging in later.

  • SFBayPUG Celebrates World Elephant Day with "Elephants at the Watering Hole"

    Join us virtually on August 11, 2021 as we celebrate World Elephant Day with "Elephants at the Watering Hole"—a PostgreSQL open discussion!

    Instead of a single speaker, we'll open the virtual floor and give everyone a chance to speak.

    Share your favorite tips and tricks, your "you won't believe this!" stories, and your enthusiasm for all things Postgres.

    Schedule:
    12:00 PM Announcements, discussion.
    1:15 PM Closing announcements, wrap up.
    1:30 PM Event ends.

    Link for the GoToMeeting room has been posted. If you need dial-in phone numbers, please DM the organizers, or check your email for details, since the MeetUp link field cannot accommodate anything other than the web link.

  • "Secrets of 'psql'—a Great Tool!", Presented by Laetitia Avrot

    Join us virtually on July 14, 2021 as Lætitia Avrot presents, "Secrets of `psql'—a Great Tool!"

    The more I learn about it, the more I want to learn about it.
    After rendering the webpage `psql-tips`, I decided to compile my best tips on those slides to make you become more efficient easily and quickly with `psql`!

    You'll also see what new features will be added to `psql` with Postgres 14!

    Lætitia Avrot is Senior Database Consultant for EDB in France.
    She began working with PostgreSQL in 2007. She also had to learn Oracle and SQL Server at the same time. She had a lot of exciting experiences with high availability, production crashes, disaster recovery plan, load balancing, spatial data...
    Laetitia is involved with the community in many ways: she is the Treasurer for PostgreSQL Europe; she co-founded Postgres Women; and she's a recognized PostgreSQL Project Contributor.

    Schedule:
    12:00 PM Announcements, speaker introduction, presentation, Q&A.
    1:15 PM Closing announcements, wrap up.
    1:30 PM Event ends.

    The link for the GoToMeeting room was sent at 1:19 PM PDT on Tuesday, July 13, 2021. If you don't see the email, please check your spam folder.

    Install the app:
    https://global.gotomeeting.com/install/375084917

    or use the extension in Chrome.

    Customize your background!
    https://global.gotomeeting.com/#/settings/custom-background

    Dial in by phone: The link box below can't accommodate the dial-in information; please check the email, or send us a DM, for the phone codes.

  • May Event: "Architecting & Building a Multi-cloud Postgres Managed Service"

    Join us virtually on May 11, 2021 as Louise Grandjonc and Craig Kerstiens present, "Architecting & Building a Multi-cloud Postgres Managed Service."

    It's one thing to install a single Postgres server, configure wal-e or pgBackRest, and watch and babysit your single production database. It's another to install Postgres and say your job is done as long as the server is up, it's the user's problem.

    How do you give a great database experience to thousands of users without dying from pager burnout? Crunchy Bridge is an attempt for a better option for Postgres hosting. We'll look mostly at how it's built with a little time on why we feel the need for there to be yet another Postgres managed service offering.

    Louise is a SQL/python/ruby developer. She is a senior software engineer at Crunchy Data where she works on Crunchy Bridge, a multi-cloud managed postgres service. Before that she was working as a developer focusing on database performance as Citus Data and Ulule (a crowdfunding platform).

    Craig currently runs Crunchy Bridge, a multi-cloud fully managed Postgres service from Crunchy Data. Previously he ran product for Heroku Postgres, ran product at Citus Data, and product for Azure Postgres. He curates Postgres weekly, a weekly newsletter of interesting Postgres content.

    Schedule:
    12:00 PM Announcements, speaker introduction, presentation, Q&A.
    1:15 PM Closing announcements, wrap up.
    1:30 PM Event ends.

    Link and password for the GoToMeeting room will be sent the evening before the event.

    11
  • "Tidying Up Your Data" with Muffy Barkocy - a Joint Event with Portland PUG!

    Join us virtually on April 13, 2021 as Muffy Barkocy presents, "Tidying Up Your Data".

    Tidy up your relational databases by moving old data to alternative storage solutions and keeping live data live. A thought experiment based on Instacart’s process for creation, fulfillment, and maintaining history of orders.

    Muffy has worked as a software engineer for more than 30 years. She started with packaged software for database interfaces, but latched onto Web development from the outset, excited by how it spoke to her vision of computers as a way to connect people around the world and change their lives. She has worked at Instacart since 2015, where she enjoys building tools for everyone, mentoring other engineers, and helping non-engineers learn more about technical topics.

    Schedule:
    12:00 PM Announcements, speaker introduction, presentation, Q&A.
    1:15 PM Closing announcements, wrap up.
    1:30 PM Event ends.

    Link and password for the GoToMeeting room will be sent the evening before the event.

  • Managing PostgreSQL with Ansible with Andreas Scherbaum

    Online event

    ***RSVPs are closed. If you would like to join, please send a message to the organizers. Thank you!***

    Join us virtually on January 26, 2021 as Andreas Scherbaum presents, "Managing PostgreSQL with Ansible".

    Ansible is an open-source configuration management and deployment tool, which can be used to manage a fleet of servers and software installations at scale.

    PostgreSQL is the world's most advanced Open Source relational database.

    This talk will introduce Ansible itself, and then show how Ansible is used to install and configure PostgreSQL on a server. Starting by installing the software on different operating systems, apply configuration changes, user and database creation up to starting and stopping the software.

    Demos for every step will round out the talk.

    Andreas Scherbaum is working with PostgreSQL since 1997. He is involved in several PostgreSQL related community projects, member of the Board of Directors of the European PostgreSQL User Group, and also wrote a PostgreSQL book (in German). Since 2020 he is working as Head of Databases for Adjust GmbH in Germany.

    Schedule:
    12:00 PM Announcements, speaker introduction, presentation, Q&A.
    1:15 PM Closing announcements, wrap up.
    1:30 PM Event ends.

    Link and password for the GoToMeeting room will be sent the evening before the event.

  • SFPUG Vacation Edition: A Virtual Visit to the Elephant Sanctuary in Tennessee!

    It's August, and everyone is ready for a vacation, so this month, we're doing something a bit different for SFBayPUG—a virtual visit to the Elephant Sanctuary of Tennessee!

    Sanctuary educator Morgan Kaelin will bring the Sanctuary to us via photos, Q & A, and live-streaming EleCams in the elephant habitats! We'll be able to visit the elephants from the comfort of our own spaces, without disturbing these wonderful creatures.

    Schedule (Note the Start Time!):
    11:00 AM Announcements, speaker introduction, presentation, Q&A.
    11:55 AM Closing announcements, wrap up.
    12:00 PM Event ends.

    Link for the online meeting room will be sent the day before the event.

    ABOUT THE ELEPHANT SANCTUARY:
    Since 1995, The Sanctuary has provided refuge for 28 elephants who are retired from zoos and circuses. There are currently 11 elephant residents with room for more. The Elephant Sanctuary in Tennessee began on 110 acres and has grown to three separate and protected, natural habitats, spanning over more than 2,700 acres.

    The Elephant Sanctuary in Tennessee provides elephants retired from entertainment and exhibition with herd, home, and individualized veterinary and husbandry care for life. Elephants that have lived their lives in captivity have an opportunity at The Sanctuary to live in an expansive habitat that allows for a range of natural behaviors.

    The Sanctuary is a 501(c)(3) non-profit and is accredited by The Global Federation of Animal Sanctuaries, certified by the Association of Zoos & Aquariums and is licensed by the U.S. Department of Agriculture and the Tennessee Wildlife Resources Agency.

    You can find out more about the Sanctuary on their website:
    https://www.elephants.com/about-us

    5
  • PostgreSQL 13 Beta Preview with Christophe Pettus—Joint Event with Portland PUG!

    SFPUG is going virtual—and we're doing a joint Meetup with our friends at the Portland PUG!

    Join us online on June 18, 2020 as Christophe Pettus presents a preview of the PostgreSQL 13 beta.

    This exciting new release has many new features, covering a wide range of functionality: Indexing, query functionality and performance, vacuuming, monitoring and status reporting, partitioning, and a host of others. We'll talk about the highlights of what to expect in version 13.

    Christophe Pettus is the CEO and lead consultant of PostgreSQL Experts, Inc., a decade-old independent PostgreSQL consultancy.

    Schedule:
    7:00 PM Announcements, speaker introduction, presentation, Q&A.
    8:15 PM Closing announcements, wrap up.
    8:30 PM Event ends.

    Link for the GoToMeeting room will be sent the day of the event.

    14
  • JSONB Tricks: Operators, Indexes, And When To (NOT) Use It

    SFPUG is going virtual!

    Join us online on May 19, 2020 as Colton Shepard presents, "JSONB Tricks: Operators, Indexes, And When To (NOT) Use It".

    When do you use jsonb, and when don’t you? How do you make it fast? What operators are available, and what can they do? How will this change? These are all very good questions, but jsonb support in Postgres moves so fast that it’s hard to keep up.

    In this talk, you will get details on these topics, complete with practical examples and real-world stories:

    *When to use jsonb, what it’s good for, and when to not use it
    *Operators and how to use them effectively
    *Indexing, operator support for indexes, and the tradeoffs involved
    *Postgres 12 improvements and new features

    I was a Solutions Engineer at Citus Data, and continue to perform the same role at Microsoft now that we've been acquired. I have specialized in data, application, and stored procedure migrations, and tend to get weird and interesting problems to solve.

    Schedule:
    7:00 PM Announcements, speaker introduction, presentation, Q&A.
    8:15 PM Closing announcements, wrap up.
    8:30 PM Event ends.

    Link and password for the GoToMeeting room will be sent the day of the event.

    2
  • SF PUG for November 2019

    Neustar, Inc.

    Thank you to Neustar for hosting!

    Join us on November 19, 2019 for two presentations!

    1. "PostgreSQL for SQL Server DBAs" with Chandra Sekhar Pathivada. The demand for polyglot DBAs, proficient with more than one database, is a common feature of current job descriptions. We'll discuss how knowledge of SQL Server helps to learn PostgreSQL.

    Chandra is a PMP and AWS Certified Solutions Architect, currently working with Datavail Corporation as a Senior Cloud Database Architect. Chandra has around 18 years of experience on a broad range of databases, which include PostgreSQL, SQL Server,MySQL, and Redshift.

    2. "Postgres 12—Now That It's Here, What Do I Do With It?" with Christophe Pettus. PostgreSQL 12 was released on October 3. While the release report tells us what changes to expect, how do you actually incorporate them into your work?

    Christophe has been using Postgres since the 7.2 days. He consults on all sorts of database and application things as CEO of PostgreSQL Experts, Inc.

    Schedule:
    6:30 PM Doors open for socializing and food.
    7:00 PM Announcements, speaker introduction, presentations, Q&A.
    8:15 PM Closing announcements, wrap up.
    8:30 PM Event ends.

    RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Even if you have provided it before, if your full name does not show on your current profile, you need to send it to us. We have over 1,600 members, so you need to let us know which one you are. Thanks!