The ele lephant in in th the enterpris ise Who we are Th The - PowerPoint PPT Presentation

The ele lephant in in th the enterpris ise

Who we are Th The Company > Founded in 2010 > More than 70 specialists > Specialized in the Middleware Infrastructure > The invisible part of IT > Customers in Switzerland and all over Europe Our Offer > Consulting > Service Level Agreements (SLA) > Trainings > License Management The elephant in the enterprise 20.02.2020 Page 2

About me Da Daniel l Westermann Principal Consultant Open Infrastructure Technology Leader +41 79 927 24 46 daniel.westermann[at]dbi-services.com @westermanndanie Daniel Westermann The elephant in the enterprise 20.02.2020 Page 3

Th The ele lephant in in the enterpris ise Before we start We have a a Pos ostgreSQL use ser group in in Switzerland! > https://www.swisspug.org Consider supporting us! The elephant in the enterprise 20.02.2020 Page 4

Th The ele lephant in in the enterpris ise Before we start We have a a Pos ostgreSQL meetup group in in Switzerland! > https://www.meetup.com/Switzerland-PostgreSQL-User-Group/ Consider joining us! The elephant in the enterprise 20.02.2020 Page 5

Th The ele lephant in in the enterpris ise Before we start Upcoming community conferences, Swis iss PGDay 20 2020 20 > https://www.pgday.ch The elephant in the enterprise 20.02.2020 Page 6

Th The ele lephant in in the enterpris ise Before we start Upcoming community conferences, PGC GConf.DE 20 2020 20 > https://2020.pgconf.de/ The elephant in the enterprise 20.02.2020 Page 7

Agenda 1.How does that "PostgreSQL" thing work? 2.Enterprise features 3.Beyond community PostgreSQL 4.Getting support 5.Best practices 6.Conclusion The elephant in the enterprise 20.02.2020 Page 8

How does th that "P "PostgreSQL" th thing work rk? 1 2 3 4 5 6 The elephant in the enterprise 20.02.2020 Page 9

PostgreSQL is is dif ifferent How does that "PostgreSQL" thing work? Th The PostgreSQL lice license expli licit itly allo allows s you > To use, copy, modify and distribute the software > for any purpose > without fee > without a written agreement > https://opensource.org/licenses/postgresql The elephant in the enterprise 20.02.2020 Page 10

But how do they make money then? How does that "PostgreSQL" thing work? PostgreSQL is is > non-commercial > all volunteer > a free software project Th There is is no o formal l lis list t of of feature requir irements requir ired for or development "W "We enjoy allo allowin ing developers s to o explore th the topics of of th their ir ch choosin ing, g, …" > https://www.postgresql.org/developer/roadmap The elephant in the enterprise 20.02.2020 Page 11

Come on, , they need money, , don't they? How does that "PostgreSQL" thing work? How doe oes th the community fu funds its its work? > A lot of companies all over the world hire people for working on the PostgreSQL source code > EnterpriseDB > VMWare > RedHat > 2ndQuadrant > Fujitsu > NTT > ( many, many, many, more ) Th The goal l is is to o brin ring in in features th that th the community ag agrees on on. Everybody win ins! The elephant in the enterprise 20.02.2020 Page 12

What is is the roadmap then? How does that "PostgreSQL" thing work? "P "PostgreSQL is is a a non on-commercial, l, all all volu lunteer, fr free so software project, an and as as su such th there is is no o formal l lis list of of feature requir irements requir ired for development. We reall lly do o foll llow th the mantra of le of lettin ing developers scr scratch th their own it itches" > https://www.postgresql.org/developer/roadmap So Some companie ies wanted to ch change th that at t le leas ast a a lit littl tle bit it > https://wiki.postgresql.org/wiki/Fujitsu_roadmap - 2018 2018 > https://wiki.postgresql.org/wiki/NTT_roadmap - 2016 2016 > https://wiki.postgresql.org/wiki/Postgres_Professional_roadmap - 2017 2017 Fin Finall lly th they've come bac ack to th the usu sual l community process The elephant in the enterprise 20.02.2020 Page 13

Who is is controll llin ing PostgreSQL then? How does that "PostgreSQL" thing work? If you ar If are loo looking for a a Pos ostgreSQL gatekeeper, ce central l commit ittee, or or controllin ling company > giv give e up - th ther ere is isn't 't on one Th There is is a a cor ore commit ittee an and commit itters > these groups are more for admin inistrative e purp rposes than control Th The project is is dir irected by y th the communit ity of of developers an and use sers > anyone can joi oin > all you need to do is to subscribe to the mailing lists and participate in the discussions The elephant in the enterprise 20.02.2020 Page 14

Who is is controll llin ing PostgreSQL then? How does that "PostgreSQL" thing work? Who is is th the PostgreSQL Glo Global l De Development Gr Group? > "The "PGDG" is an international, unincorporated association of individuals and companies who have contributed to the PostgreSQL project. The PostgreSQL Core Team generally act as spokespeople for the PGDG." > https://wiki.postgresql.org/wiki/FAQ#Who_is_the_PostgreSQL_Global_Development_Group.3F The elephant in the enterprise 20.02.2020 Page 15

Who is is controll llin ing PostgreSQL then? How does that "PostgreSQL" thing work? Who is is th the PostgreSQL Cor ore team? > A committee of five to seven (currently five) senior contributors to PostgreSQL who do the following for the project > (a) set release dates > (b) handle confidential matters for the project > (c) act as spokespeople for the PGDG when required > (d) arbitrate community decisions which are not settled by consensus The elephant in the enterprise 20.02.2020 Page 16

Who is is controll llin ing PostgreSQL then? How does that "PostgreSQL" thing work? Th The cu current PostgreSQL core team an and so some major contrib ibutors > https://www.postgresql.org/community/contributors The elephant in the enterprise 20.02.2020 Page 17

Who is is controll llin ing PostgreSQL then? How does that "PostgreSQL" thing work? So So, on once ag again in, who is is ownin ing Pos ostgreSQL? The PostgreSQL community! The elephant in the enterprise 20.02.2020 Page 18

PostgreSQL develo lopment How does that "PostgreSQL" thing work? How doe oes it it wor ork th then when it it comes to o development? > What about certifying operating systems? > What about bug tracking systems? > What about source code control? > What about decisions? Who decides what? > What about security fixes? The elephant in the enterprise 20.02.2020 Page 19

PostgreSQL develo lopment How does that "PostgreSQL" thing work? Le Let's start fr from th the very ry begin inning > What do you need when you work with a commercial vendor? A support contract? Money? A subscription? Access to patches? Patience, a lot of patience? Access to a support portal? The elephant in the enterprise 20.02.2020 Page 20

PostgreSQL develo lopment How does that "PostgreSQL" thing work? What do o you need for PostgreSQL? Who in this room does not have an email address? The elephant in the enterprise 20.02.2020 Page 21

PostgreSQL develo lopment How does that "PostgreSQL" thing work? All ll you need to o become par art of of th the community is is an an > Everything is based on mailing lists > All discussions happen via Email > No matter what you are looking for, there probably is a mailing list for it > https://www.postgresql.org/list/ The elephant in the enterprise 20.02.2020 Page 22

PostgreSQL develo lopment How does that "PostgreSQL" thing work? Even patches an and new features start with ith an an The elephant in the enterprise 20.02.2020 Page 23

Commit itfests How does that "PostgreSQL" thing work? PostgreSQL is is comple letely op open an and tr transparent > All features and patches that are going on are tracked online > https://commitfest.postgresq.sql The elephant in the enterprise 20.02.2020 Page 24

How PostgreSQL is is tested? How does that "PostgreSQL" thing work? Th The build ild farm > https://buildfarm.postgresql.org/cgi-bin/show_status.pl The elephant in the enterprise 20.02.2020 Page 25

PostgreSQL communit ity communic icatio ion How does that "PostgreSQL" thing work? To o su summarize + Commitfests > New features + Commitfests > Patches + Commitfests > Bug tracking > Decisions https://git.postgresql.org/gitweb/?p=postgresql.git;a=summary > Source code control https://buildfarm.postgresql.org/ > Supported Operating systems The elephant in the enterprise 20.02.2020 Page 26

Where does PostgreSQL ru run on? How does that "PostgreSQL" thing work? Lin Linux (all (all recent dis istributions) Solaris So is - AIX - HP/U /UX Win indows s (20 (2000 SP SP4 4 an an la later) OS S X FreeBSD, OpenBSD, Fr , NetBSD The elephant in the enterprise 20.02.2020 Page 27