The workshops will take place at the same venue of PGDay.IT 2019 (Hotel Parchi del Garda, Via Brusà 16/17 - Pacengo di Lazise). Registration has to be made through Eventbrite. On the registration page, you have to select the topic of interest. The workshop fee does NOT include: coffee break, lunch, and access to PGDay.IT 2019. Participants has to bring their computer. IMPORTANT: WORKSHOPS WILL BE CONFIRMED AT THE ENTRY OF 3 MEMBERS. IN CASE ONE OR MORE WORKSHOPS WILL NOT BE CONFIRMED, WE WILL REFUND THE FEE RECEIVED.
A good disaster recovery plan is a fundamental element for the operational continuity of our services. During the workshop, we will deal with basic business continuity topics and how to implement it with the native PostgreSQL functionalities, through a disaster recovery plan in which the backups and continuous archiving of WAL will be protagonists.
Ansible is a powerful automation tool written in Python. With its modules already built for PostgreSQL, we can easily manage the most advanced open source database, making sure its configuration is exact in every detail and repeatable as many times as it is needed. In this workshop we will understand how Ansible works, see some of its main modules for system/cloud administration, and learn how it can be used to orchestrate PostgreSQL deployments, managing all parts of the process at ease. As an use-case example, we will write a playbook to install a PostgreSQL master and a standby in streaming replication. For a more hands-on experience, the workshop participants should have Vagrant installed on their laptops, which will allow the creation of virtual machines to test the Ansible playbooks.
In this workshop we will talk about the best features of PostgreSQL and the best features of Go. We will use the "database/sql" package to create a connnection to PostgreSQL and the "lib/pq" package, which implements in Go the PostgreSQL binary protocol. We will talk about the native Go connection pooler, about "pressly/goose" to manage migrations and about "jmoiron/sqlx" to use PostgreSQL more comfortably and why usually we don't need an ORM. At the end of the workshop we will have a simple web server exposing a REST API based on PostgreSQL.
Analyzing the real possibilities of the Open Source GIS, during the four hours envisaged we will see how to create a web connector, based on PHP and capable of generating GEOJson flows, for the publication of the cartographic data and an online viewer for consulting and querying spatial data. In the workshop, with real data to the hand provided by the teacher, will be treated not only the technologies and languages but also the protocols and formats of transport of geographic information.
When you first start running your queries it looks like the database is doing some magic and returning your results very fast. After you gain some confidence in writing more complex queries you see that the magic sometimes doesn’t work. Why does the database fail to do its job? To see the reasons why your queries run slowly you can use the EXPLAIN command which devises a detailed query plan of your query. After reading it, you should figure out exactly what is going on with the query, and easily find a way to fix it. In this workshop, we will start with simple queries and joins, and make our way up to subselects, CTE-s and stored procedures. To see all this in action we will use the textual representation of the EXPLAIN and the help of pgAdminIII/4 and other available tools. If time allows it, we can try to fix some problematic queries attendees bring from home 😎
For a company, a fundamental aspect to always keep in mind is the availability of databases that are always online to carry out their analyzes, checks, reports and everything concerning the information aspect on the database. In our Workshop we will configure the Failover management in PostgreSQL environment. We'll see what happens when the primary server breaks and how the Failover procedure occurs on the secondary server. Infine vedremo anche le differenze con una soluzione Enterprise quale EnterpriseDB Failover Manager. Eventually, we’ll also see the differences with an Enterprise solution such as EnterpriseDB Failover Manager.
In this workshop, we demonstrate several aspects of data persistence in PostgreSQL, in terms of architecture, database configuration and application behavior.
Workshop - Ordinary ticket