{"id":325,"date":"2014-02-05T13:50:53","date_gmt":"2014-02-05T13:50:53","guid":{"rendered":"http:\/\/it.tuxie.eu\/?p=325"},"modified":"2014-02-05T14:18:17","modified_gmt":"2014-02-05T14:18:17","slug":"postgresql-9-3-2-installation-on-debian-7-2-x64","status":"publish","type":"post","link":"http:\/\/it.tuxie.eu\/?p=325","title":{"rendered":"PostgreSQL 9.3.2 installation (Debian 7.2 x64)"},"content":{"rendered":"

Binary way, ignoring repositories, is very favourite and can be reproduced in any other linux distribution…<\/p>\n

<\/p>\n

PostgreSQL is recommending (for non-package method) using packaging from EnterpriseDB = after downloading .run file<\/a> you can run it as root:<\/p>\n

root@debian:\/home\/j\/install# .\/postgresql-9.3.2-3-linux-x64.run<\/strong><\/span><\/span><\/p>\n

\"\"<\/p>\n

First you need to define installation directory:<\/p>\n

\"\"<\/p>\n

Similar to previous option, defining data directory is also essential:<\/p>\n

\"\"<\/p>\n

Password for user postgres is needed:<\/p>\n

\"\"<\/p>\n

And of course listening port (default 5432):<\/p>\n

\"\"<\/p>\n

Now very interesting option, can save a lot of issue later \ud83d\ude09 :<\/p>\n

\"\"<\/p>\n

Installation lasts few seconds, initializing is following…:<\/p>\n

\"\"<\/p>\n

You are also asked, if you want to download additional software related to PostgreSQL (highly recommended!).<\/p>\n

Well, installation is over. No additional info given. Let\u00b4s investigate if postgresql is running \ud83d\ude42<\/p>\n

root@debian:\/home\/j\/install# ps -ef | grep postgre<\/strong><\/span><\/span>
\npostgres\u00a0 5079\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:40 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 \/opt\/PostgreSQL\/9.3\/bin\/postgres -D \/opt\/PostgreSQL\/9.3\/data<\/span>
\npostgres\u00a0 5080\u00a0 5079\u00a0 0 14:40 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 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>
\npostgres\u00a0 5082\u00a0 5079\u00a0 0 14:40 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 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>
\npostgres\u00a0 5083\u00a0 5079\u00a0 0 14:40 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 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>
\npostgres\u00a0 5084\u00a0 5079\u00a0 0 14:40 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 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>
\npostgres\u00a0 5085\u00a0 5079\u00a0 0 14:40 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 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>
\npostgres\u00a0 5086\u00a0 5079\u00a0 0 14:40 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 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

Well, nice.<\/p>\n

postgres@debian:~\/bin$ pwd<\/span>
\n\/opt\/PostgreSQL\/9.3\/bin<\/span>
\npostgres@debian:~\/bin$ .\/psql<\/strong><\/span><\/span>
\nPassword: <\/span>
\npsql.bin (9.3.2)<\/span>
\nType „help“ for help.<\/span><\/p>\n

No entry for terminal type „xterm“;<\/span>
\nusing dumb terminal settings.<\/span>
\npostgres=# <\/span><\/p>\n

Command line also working. We can try to restart server for verifying all init.d actions were successful:<\/p>\n

root@debian:\/etc\/init.d# \/etc\/init.d\/postgresql-9.3 restart<\/strong><\/span><\/span>
\nRestarting PostgreSQL 9.3: <\/span>
\nwaiting for server to shut down…. done<\/span>
\nserver stopped<\/span>
\nwaiting for server to start…. done<\/span>
\nserver started<\/span>
\nPostgreSQL 9.3 restarted successfully<\/span><\/p>\n

I found relict, .ini file in \/etc directory, collecting all information done during installation process.<\/p>\n

root@debian:\/etc# cat postgres-reg.ini <\/strong><\/span><\/span>
\n[PostgreSQL\/9.3]<\/span>
\nInstallationDirectory=\/opt\/PostgreSQL\/9.3<\/span>
\nVersion=9.3.2.3<\/span>
\nShortcuts=1<\/span>
\nDataDirectory=\/opt\/PostgreSQL\/9.3\/data<\/span>
\nPort=5432<\/span>
\nServiceID=postgresql-9.3<\/span>
\nLocale=en_US.UTF-8<\/span>
\nSuperuser=postgres<\/span>
\nServiceaccount=postgres<\/span>
\nDescription=PostgreSQL 9.3<\/span>
\nBranding=PostgreSQL 9.3<\/span>
\nDisableStackBuilder=0<\/span><\/p>\n

One more thing regarding configuration – in my case, Debian is just server, running on VirtualBox machine – so I want to use it as server, client = Windows. For non-conflict setting up I\u00b4m using Network „Network only with guest“, ip address for debian = 192.168.56.102. You need to know how it works with postgresql, connecting into database from other hosts. First of all you need to locate pg_hba.conf<\/strong> file. I have no idea where it is located in this binary installation:<\/p>\n

root@debian:\/opt\/PostgreSQL\/9.3\/data# find \/ -name 'pg_hba.conf' 2>\/dev\/null<\/strong><\/span><\/span>
\n\/opt\/PostgreSQL\/9.3\/data\/pg_hba.conf<\/code><\/span><\/p>\n

Editing pg_hba.conf is essential, I just need to add this line:<\/p>\n

host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192.168.56.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/span><\/p>\n

Done. No need to do anything else now.<\/p>\n

\"\"<\/p>\n

-a-<\/p>\n","protected":false},"excerpt":{"rendered":"

Binary way, ignoring repositories, is very favourite and can be reproduced in any other linux distribution…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,15],"tags":[],"_links":{"self":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/325"}],"collection":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=325"}],"version-history":[{"count":0,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/325\/revisions"}],"wp:attachment":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}