PostgreSQL is more and more widely adopted for all kinds of applications. Many people are also moving their enterprise applications for Oracle, MS SQL, or DB2 to PostgreSQL. But, it is not only about the database and the data itself. The entire application has to be migrated and high security standards have to be maintained. […]
Author Archives: PGDay
Die Oracle Lizenzkosten verhindern leider immer wieder, dass man das Optimale aus der Applikationen herausholt – auf der anderen Seite hat Oracle aber Vorteile wie Clustering, die PostgreSQL so nicht bieten kann. Anhand von 2-3 Beispielen für Implementierungen zeigen wir Möglichkeiten, um aus beiden Datenbanken ein unschlagbares Team zu machen. Sprecher Christian Pfundtner Ich bin […]
14 highly interesting talks, seven in German and seven in English, were selected from 40 submissions by the Talk Committee (according to standardised scoring) – thus the schedule for the first PGDAY Austria has been finalised. Our eleven male and three female speakers come from eleven different nations and guarantee exciting and well-founded talks. During […]
What is Replication? Why do we need Replication? How many replication layers do we have? Understanding milestones of built-in Database Physical Replication. What is the purpose of replication? and How to rescue system in case of failover? What is Streaming Replication and what is its advantages? Async vs Sync, Hot standby etc. How to configurate […]
Input-output performance problems are on every day agenda for DBAs since databases exist. In Linux – probably the most popular operating system for databases now – there is a major overhaul of the IO stack for last several years. In this talk I will review what is going on there, why the IO stack needed […]
Deployment of PostgreSQL inside of Kubernetes with high availability, configurable cluster members. Handling load balancing, exposing service to outside world. Synchronisation between instances, Scaling up and down. Storage options and advantages. Health monitoring. Rolling upgrades and downgrades. Speaker Armin Nesiren I’m DevOps and software engineer and I’ve been dealing with PostgreSQL for more than ten […]
Data security is an important issue and the introduction of GDPR has added even more requirements. But how can one live in a demand environment? How can one secure data and make sure that the right people can see the right data? Speaker Pavlo Golub PostgreSQL expert and developer at Cybertec. Working with PostgreSQL for […]