Rather it basically means “installation". What do all the fields mean? Well, each line is so called “cluster", which is rather unfortunate term, as it's not cluster in the generally used meaning. Ver Cluster Port Status Owner Data directory Log file 13 main 5432 online postgres /var /lib /postgresql / 13 /main /var /log /postgresql /postgresql- 13-main.log One, generally, should always use the latest version – it has the most features, and the most bugs removed. Postgresql- 9.6 - object-relational SQL database, version 9.6 server Postgresql- 9.5 - object-relational SQL database, version 9.5 server Postgresql- 9.4 - object-relational SQL database, version 9.4 server Postgresql- 9.3 - object-relational SQL database, version 9.3 server Postgresql- 9.2 - object-relational SQL database, version 9.2 server Postgresql- 9.1 - object-relational SQL database, version 9.1 server Postgresql- 9.0 - object-relational SQL database, version 9.0 server Postgresql- 8.4 - object-relational SQL database, version 8.4 server
Postgresql- 8.3 - object-relational SQL database, version 8.3 server Postgresql- 8.2 - object-relational SQL database, version 8.2 server Postgresql- 13 - object-relational SQL database, version 13 server Postgresql- 12 - object-relational SQL database, version 12 server Postgresql- 10 - object-relational SQL database, version 10 server Postgresql- 11 - object-relational SQL database, version 11 server Ubuntu ships with sudo configured in such a way that my user (first created) already belongs to sudo group, thanks to which I apt-cache search ^postgresql- | grep -E '^postgresql-+ ' So, I need some way to get to root for things like package installation. Now, before I will go any further – I tend to not work from root account, unless I absolutely must. testdebian – Debian GNU/Linux 10 (buster)īoth were updated to newest versions of packages before any work was done.testubuntu – running Ubuntu 20.10 groovy.To make sure I start in as vanilla configuration as possible, I made myself two virtual servers:
Please do not configure production servers using this howto. As in: server where user can do anything, and we don't really care about security. These do not necessarily mean that these are the best for everybody, but I think this is a good start for anyone wanting to start their adventure with PostgreSQL.įinal note of warning – this post is for installing and setting PostgreSQL on developer workstation. With that in mind I decided to write a howto based on my ideas on what is right. But there are always some caveats – which packages to use, what to configure in the beginning, where to find config files and logs.
#POSTGRESQL INSTALL DEBIAN 8 HOW TO#
One thing that almost immediately jumped to my mind is – how to install PostgreSQL? The task is theoretically simple. Recently I spent some time thinking about what can be improved when it comes to helping new users start using PostgreSQL.
0 kommentar(er)
