PostgreSQL - MC

PostgreSQL #2 - Installation In this post I'm going to explain how to install PostgreSQL database server. I will try to make it clear as possible. You will find in the post the prerequisites, on what environment I'm working on and step by step instructions on how to install postgresql via yum or from source code. So, Lets begin :) Prerequisites You can find all the prerequisites in the official documentation . To be honest I looked at the prerequisites maybe once. If you are trying to create a production enivronment you should check the prerequisites. If you are just want to learn or create a test env just follow the post instructions and you'll be ok. My environment I dont have any server therefore I downloaded oracle virtualbox . I created a virtual machine on my laptop and installed centos 7 on it. You need to configure the machine so that it can access the internet. In other word if you can ping outside of your network you are good to go. I...

PostgreSQL #1 - Introduction Hi, My name is Mariel Cherkassky and I'm going to write in this blog all the things that I have learned so far about postgresql . I will try to explain anything from what it is to the most complicated things that I handled. Hopefully it will be usefull for some people someday.  ?So what is PostgreSQL PostgreSQL is a relational database (data stored in tables). PostgreSQL has many advantages in compare to other relational databases but you should remember that what makes it so unique is that it is an  open source  database. In other words the PostgreSQL project`s code is visible to the community. Every one can reach that code and help make this project better. As a result of that there are many helpfull tools in the field that can make our life easier whether you are developer,system administrator, dba or just someone that is trying postgresql. This huge attribute led to the creation of many PostgreSQL`s forks. In other word...