{"id":805,"date":"2016-02-02T19:52:22","date_gmt":"2016-02-02T18:52:22","guid":{"rendered":"http:\/\/it.tuxie.eu\/?p=805"},"modified":"2016-02-02T19:52:22","modified_gmt":"2016-02-02T18:52:22","slug":"postgresql-9-5-first-impression","status":"publish","type":"post","link":"http:\/\/it.tuxie.eu\/?p=805","title":{"rendered":"PostgreSQL 9.5 First Impression"},"content":{"rendered":"

There are many ways how one can be impressed by software product. Size of package, company\/community promotion, installer functions + user\/friendly UI, etc. I like PostgreSQL, no doubt about it – so let’s check how is it packed by Enterprise DB in last release (9.5).<\/p>\n

<\/p>\n

Installation package size<\/strong><\/p>\n

I was a bit suscpicious about installer size:<\/p>\n

-rwxrwx—\u00a0 1 ji users 37847509 Jan\u00a0 8 11:41 postgresql-9.5.0-1-linux-x64.run<\/span><\/p>\n

38MB – sounds incredible!<\/p>\n

For your comparison, MySQL 5.7.10 sizes: Windows (320MB-400MB), Ubuntu (180MB), SuSE (375MB), Linux generic – static glibc 2.5 (550MB-580MB).<\/p>\n

As a root, you can install postgresql in 2 ways – text and graphical mode. Text mode is maybe not intentioned more or less – if you have no DISPLAY variable setup:<\/p>\n

linux-9aor:\/home\/ji # .\/postgresql-9.5.0-1-linux-x64.run <\/span>
\n—————————————————————————-<\/span>
\nWelcome to the PostgreSQL Setup Wizard.<\/span><\/p>\n

—————————————————————————-<\/span>
\nPlease specify the directory where PostgreSQL will be installed.<\/span><\/p>\n

You can continue in a text installation indeed or you can import DISPLAY variable and enjoy graphical output:<\/p>\n

linux-9aor:\/home\/ji # export DISPLAY=:0<\/span>
\nlinux-9aor:\/home\/ji # .\/postgresql-9.5.0-1-linux-x64.run <\/span><\/p>\n

Installation screens:<\/strong><\/p>\n

\"01-inst\"<\/a><\/p>\n

\"02-inst\"<\/a><\/p>\n

\"03-inst\"<\/a><\/p>\n

\"04-inst\"<\/a><\/p>\n

\"05-inst\"<\/a><\/p>\n

\"06-inst\"<\/a><\/p>\n

\"07-inst\"<\/a><\/p>\n

\"08-inst\"<\/a><\/p>\n

\"09-inst\"<\/a><\/p>\n

Stack Builder is a small utility which can be used for downloading (+installing) extensions. For me it makes sense PostGIS. 3 clicks and here we go…. excellent work (I remember days full of frustration from hidden error during compiling this GIS extension).<\/p>\n

Is that all?<\/strong><\/p>\n

Well….. yes, it is.<\/p>\n

PostgreSQL related menu is also created:<\/p>\n

\"menu\"<\/a><\/p>\n

Service is up and running:<\/p>\n

linux-9aor:~ # service postgresql-9.5 status<\/span>
\npostgresql-9.5.service – PostgreSQL 9.5 database server<\/span>
\n\u00a0\u00a0 Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql-9.5.service; enabled)<\/span>
\n\u00a0\u00a0 Active: active (running) since Tue 2016-02-02 19:27:59 CET; 25s ago<\/span>
\n\u00a0 Process: 741 ExecStart=\/opt\/PostgreSQL\/9.5\/bin\/pg_ctl -w start -D \/opt\/PostgreSQL\/9.5\/data -l \/opt\/PostgreSQL\/9.5\/data\/pg_log\/startup.log -w -t\u00a0 (code=exited, status=0\/SUCCESS)<\/span>
\n\u00a0Main PID: 875 (postgres)<\/span>
\n\u00a0\u00a0 CGroup: \/system.slice\/postgresql-9.5.service<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u251c\u2500 875 \/opt\/PostgreSQL\/9.5\/bin\/postgres -D \/opt\/PostgreSQL\/9.5\/data<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u251c\u25001005 postgres: logger process\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u251c\u25001025 postgres: checkpointer process\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u251c\u25001026 postgres: writer process\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u251c\u25001027 postgres: wal writer process\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u251c\u25001030 postgres: autovacuum launcher process\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2514\u25001031 postgres: stats collector process\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span><\/p>\n

pgAdmin III<\/strong><\/p>\n

Command line is great, universal and have some requirements for user to use (knowing syntax). GUI delivered with postgresql package is named pgAdmin III. It’s simple, not hungry, basic GUI for a work with postgresql database. Objects hierarchy are clearly visible just from first sight and metadata are tempting to be discovered .-)<\/p>\n

\"010-pgadmin\"<\/a><\/p>\n

Wizards for common actions are really nicely written and impose large number of parameters. Example for creating database:<\/p>\n

\"011-crdb\"<\/a><\/p>\n

\"012-crdb\"<\/a><\/p>\n

\"013-crdb\"<\/a><\/p>\n

\"014-crdb\"<\/a><\/p>\n

\"015-crdb\"<\/a><\/p>\n

\"016-crdb\"<\/a><\/p>\n

pgAdmin also provides SQL query part (with both parts – text one and visual query builder):<\/p>\n

\"017-que\"<\/a><\/p>\n

Command line<\/strong><\/p>\n

Clean software touch is visible also within working in command line – PostgreSQL does no rely on window manager and brings…. tadaaaaa…. good old xterm:<\/p>\n

\"018-psql\"<\/a><\/p>\n

Overview:<\/strong><\/p>\n