This repo is part of the tutorial PostgreSQL for MySQL DBA's available at https://www.youtube.com/channel/UCN41e11CmxvbTYKwrTNLG1w.

This tutorial is focused on teaching PostgreSQL to professionals who are already experienced with databases, especially MySQL. A beginner may adapt the concepts easily but [s]he needs to know the basic concepts of a relational database.

We start from the principle that relational databases share a lot of similar concepts and you may find it easier if we help you relate the concepts of PostgreSQL with MySQL. Thus, we will start with PostgreSQL Architecture for MySQL DBAs and proceed with most common installation methods, configuration and so on.

The approach we take within this tutorial is to present an overview of the PostgreSQL architecture and operation in view of MySQL's. We will build a lab together to practice everything we discuss here. Note that we will mix lecture with hands-on work and you, the listener, have to apply those very same concepts we present here in practice in your lab before covering new ones. We will start with a simple and quick installation of PostgreSQL and then walk all the way to set up and maintain a stand by replica. By the end of this training you shall be able to have a good understanding of how PostgreSQL works, and feel confident enough to try it yourself elsewhere.

• Here are the main points covered in this tutorial :
• PostgreSQL architecture
• Installation and setup
• Configuration files: parameters you need to know
• Client Authentication
• System Catalogs
• Physical Storage, Tablespaces and Files Layout
• MVCC in PostgreSQL
• The VACUUM
• Roles and Privileges
• Encryption Options
• Backup and Recovery, an overview of Backup Methods
• SQL Dump and Restore
• Physical Backup
• Replication, an overview of Replication Methods
• Physical Replication
• Logical Replication

Contributing

Contributions are very welcome!

Suggestions and criticism are always welcome and help us to learn more and improve the quality of this project!

You can contribute in many ways. You can, for example, contribute by promoting this training on your social media. Note that most of us are not English native speakers and reviewing the documents here is a great Contribution :D

Also, translating both this material on Github and the videos to your mother language, improving current examples, creating new examples, suggesting new content, creating content and submitting here... There are many other ways to contribute, be creative :D

Acknowledgements

This README was created using the amazing readme.so tool by Katherin Peterson. You can find more about it at https://readme.so.

License

[BSD 3-Clause License] (https://opensource.org/licenses/BSD-3-Clause)

Copyright (c) 2021, DBjunkies
All rights reserved.

Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright notice, this
   list of conditions and the following disclaimer.

2. Redistributions in binary form must reproduce the above copyright notice,
   this list of conditions and the following disclaimer in the documentation
   and/or other materials provided with the distribution.

3. Neither the name of the copyright holder nor the names of its
   contributors may be used to endorse or promote products derived from
   this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

You can also find a full copy of this license in the file "LICENSE" in the root folder of this repository.