Simon Riggs - PostgreSQL 9 Administration Cookbook

Simon Riggs is the CTO of 2ndQuadrant and an active PostgreSQL committer. He has contributed to PostgreSQL as a major developer for more than 10 years, having written and designed many new features in every release over that period. His feature credits include replication, performance, business intelligence, management, and security. Under his guidance, 2ndQuadrant is now a leading developer of open source PostgreSQL and a platinum sponsor of the PostgreSQL Project, serving hundreds of clients in USA, Europe, Asia-Pacific, the Middle East, and Africa.

Simon is a frequent speaker at many conferences and is well known for his speeches on PostgreSQL Futures and different aspects of replication. He has worked with many different databases as a developer, architect, data analyst, and designer with companies across USA and Europe for nearly 30 years.

Thanks to my clients for trusting me with hard problems, having faith, and giving me the energy to solve them; every one of you has helped me. Thanks to my friends and colleagues at 2ndQuadrant for such strong teamwork and the PostgreSQL Community for your belief in community. Lastly, thanks to my family for everything!

Gianni Ciolli is a principal consultant at 2ndQuadrant Italia, where he has been working since 2008 as a developer, consultant, and trainer. He has spoken at PostgreSQL conferences in Europe and abroad, and his other IT skills include functional languages and symbolic computing.

Gianni has a PhD in mathematics, and is the author of published research on Algebraic Geometry, Theoretical Physics, and Formal Proof Theory. He previously worked at the University of Florence as a researcher and teacher.

Gianni has been working on free and open source software for almost 20 years. From 2001 to 2004, he was a cofounder and the president of PLUG, short for Prato Linux User Group. He organized many sessions of the Italian PostgreSQL conference, and in 2013, he was elected to the board of ITPUG, the Italian PostgreSQL Users Group.

He currently lives in London with his son. His other interests include music, drama, poetry, and sportathletics in particular, where he competes in combined events.

First, I wish to thank all the persons whose dedication and knowledge have helped me learn everything so far: my colleagues at 2ndQuadrant, the members of the PostgreSQL community, and also my former colleagues and teachers.

I am grateful for what was shared with me, and also for being given the opportunity to find useful applications.

Hannu Krosing is a principal consultant at 2ndQuadrant and a technical advisor at Ambient Sound Investments. As the original database architect at Skype Technologies, he was responsible for designing the SkyTools suite of replication and scalability technology. He has worked with and contributed to the PostgreSQL project for more than 12 years.

Gabriele Bartolini is a long-time open source programmer, a principal consultant with 2ndQuadrant, and an active member of the international PostgreSQL community.

Gabriele has a degree in statistics from the University of Florence. His areas of expertise are data mining and data warehousing, and he has worked on web traffic analysis in Australia and Italy.

He currently lives in Prato, a small but vibrant city located in the northern part of Tuscany, Italy. His second home is Melbourne, Australia, where he studied at Monash University and worked in the ICT sector. Gabriele's hobbies include playing his Fender Stratocaster electric guitar and "calcio" (football or soccer, depending on which part of the world you come from).

Thanks to my family, especially my wife, Cathy, who always encourages me to learn something new. Thanks to all the members of 2ndQuadrant, particularly the Italian team; all of you are fantastic people who share the same vision and passion for PostgreSQL, Linux, and open source software.

Atdhe Buja MSc is a certified ethical hacker, DBA (MCITP, OCA11g), and manager with good management skills. He is a DBA at the Ministry of Public Administration, Pristina, Republic of Kosovo, where he manages some e-governance projects. He has 10 years of experience in databases and SQL Server.

Atdhe is an active contributor to the Albanian ICT Awards (www.ictawards.com) and is a regular columnist for the newspaper of University for Business and Technology, Pristina. He holds an MSc in computer science and engineering and a bachelor's in management and information. He is pursuing a bachelor's in political science at the University of Pristina.

He specializes in, and is certified in, many technologies such as SQL Server 2000-2005-2008 R2, Oracle 11g, CEH, Windows Server, Microsoft Project, System Center, and BizTalk Server.

I would like to thank my wife, Donika, for encouraging me and my Buja family for their support.

Jrme tv is a full stack web application developer with a wide range of technological interests. After getting a master's degree in bioinformatics from the University of Lille, France, in 2002, he began developing web applications for the corporate sector and the general public, which he has been doing until now. He currently works at Broadbean, a recruitment technology company in London. He regularly creates and shares open source software on his GitHub account (