Presented by:

Software Developer, working with micro-startups & small teams to build niche software, typically database-backed desktop-style enterprise-oriented web apps running server-side in pure Java on the Vaadin framework.

Previously worked in long-term client engagements building in-house custom-crafted departmental database apps for cost accounting, business operations, and workflow.

Also spent a couple years as a trainer teaching software development (database, business logic, and user-interface) to developers both novice and expert in week-long seminars.

Hobbies include extreme dog-walking and welding bird-cages. And spending way too much time on Stack Overflow.

Demo of spinning up a new virtual machine instance running FreeBSD (the open-source Unix-like OS, similar to Linux). On that cloud server, we install the Postgres database engine. On our local computer, we use open-source pgAdmin, to connect to the database server and create a new database.

Learn about the nature of Digital Ocean virtual machines, and the mechanism for secure connections to your cloud server. Get a quick overview of FreeBSD’s avenue to obtain and install software: the Packages & Ports tools. Get a list of steps to follow in setting up a fresh Postgres install. Learn about the network and security issues in making a remote connection from a database admin tool such as pgAdmin. Lastly, see how to capture a snapshot of your configured Postgres cloud instance, so you can instantly launch more servers already configured.

Date:
Duration:
45 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2019
Language:
Track:
Postgres Track
Difficulty:
Medium

Happening at the same time:

  1. Computers are Broken (and we're all going to die)
  2. Start Time:
    2019 April 27 09:30

    Room:
    HC-108

  3. Baling Wire, Bailing Buckets, or Bailing Out
  4. Start Time:
    2019 April 27 09:30

    Room:
    CC-236

  5. Elephant on a Cloud
  6. Start Time:
    2019 April 27 09:30

    Room:
    HC-103 Postgres

  7. UEFI Boot for Mere Mortals
  8. Start Time:
    2019 April 27 09:30

    Room:
    CC-208

  9. Let's build our own Internet-of-Things
  10. Start Time:
    2019 April 27 09:30

    Room:
    CC-115

  11. The Top Seven Database Mistakes You Are Making
  12. Start Time:
    2019 April 27 09:30

    Room:
    CC-200

  13. Playing in the Sandbox
  14. Start Time:
    2019 April 27 09:30

    Room:
    CC-114

  15. Audio Production on Linux
  16. Start Time:
    2019 April 27 09:30

    Room:
    HC-104 Jupiter

  17. Logging, Metrics and APM at Scale
  18. Start Time:
    2019 April 27 09:30

    Room:
    G-103

  19. Try Linux Tutorium
  20. Start Time:
    2019 April 27 09:30

    Room:
    CC-234

  21. Make a music synthesizer in Bash
  22. Start Time:
    2019 April 27 10:00

    Room:
    CC-202 Tutorials

  23. Blender 2.8: An intro to 3D Animation
  24. Start Time:
    2019 April 27 10:00

    Room:
    CC-201 Tutorials

  25. LPIC-1 Preparation Session
  26. Start Time:
    2019 April 27 10:00

    Room:
    HC-112 LPI