{"id":393,"date":"2014-02-17T15:31:29","date_gmt":"2014-02-17T15:31:29","guid":{"rendered":"http:\/\/it.tuxie.eu\/?p=393"},"modified":"2014-02-17T15:31:45","modified_gmt":"2014-02-17T15:31:45","slug":"postgresql-9-3-install-by-one-command-debian-7-4-x64","status":"publish","type":"post","link":"http:\/\/it.tuxie.eu\/?p=393","title":{"rendered":"PostgreSQL 9.3 install-by-one-command (Debian 7.4 x64)"},"content":{"rendered":"

Laziness. Need for one-click solution (Windows). Need for one-command solution (*nix). OK! \ud83d\ude42<\/p>\n

<\/p>\n

root@deb74:~# echo \"deb http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg main\" > \/etc\/apt\/sources.list.d\/postgre.list && wget --quiet -O - https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | apt-key add - && apt-get update && apt-get dist-upgrade && apt-get install postgresql-9.3<\/code><\/strong><\/span><\/span>
\nOK<\/span>
\nIgn cdrom:\/\/[Debian GNU\/Linux 7.4.0 _Wheezy_ – Official amd64 DVD Binary-1 20140208-13:47] wheezy Release.gpg<\/span>
\nIgn cdrom:\/\/[Debian GNU\/Linux 7.4.0 _Wheezy_ – Official amd64 DVD Binary-1 20140208-13:47] wheezy Release<\/span>
\nIgn cdrom:\/\/[Debian GNU\/Linux 7.4.0 _Wheezy_ – Official amd64 DVD Binary-1 20140208-13:47] wheezy\/contrib amd64 Packages\/DiffIndex<\/span>
\nIgn cdrom:\/\/[Debian GNU\/Linux 7.4.0 _Wheezy_ – Official amd64 DVD Binary-1 20140208-13:47] wheezy\/main amd64 Packages\/DiffIndex<\/span>
\nIgn cdrom:\/\/[Debian GNU\/Linux 7.4.0 _Wheezy_ – Official amd64 DVD Binary-1 20140208-13:47] wheezy\/contrib Translation-en_US<\/span>
\nIgn cdrom:\/\/[Debian GNU\/Linux 7.4.0 _Wheezy_ – Official amd64 DVD Binary-1 20140208-13:47] wheezy\/main Translation-en_US<\/span>
\nHit http:\/\/security.debian.org wheezy\/updates Release.gpg\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\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/security.debian.org wheezy\/updates Release\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\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy Release.gpg\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\u00a0 \u00a0<\/span>
\nHit http:\/\/security.debian.org wheezy\/updates\/main Sources\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/security.debian.org wheezy\/updates\/contrib Sources\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy-updates Release.gpg\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>
\nHit http:\/\/security.debian.org wheezy\/updates\/main amd64 Packages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/security.debian.org wheezy\/updates\/contrib amd64 Packages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy Release\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\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/security.debian.org wheezy\/updates\/contrib Translation-en\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>
\nHit http:\/\/security.debian.org wheezy\/updates\/main Translation-en\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>
\nHit http:\/\/ftp.de.debian.org wheezy-updates Release\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>
\nHit http:\/\/ftp.de.debian.org wheezy\/main Sources\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>
\nHit http:\/\/ftp.de.debian.org wheezy\/main amd64 Packages\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy\/main Translation-en\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy-updates\/main Sources\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy-updates\/contrib Sources\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nGet:1 http:\/\/apt.postgresql.org wheezy-pgdg Release.gpg [836 B]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy-updates\/main amd64 Packages\/DiffIndex<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy-updates\/contrib amd64 Packages<\/span>
\nGet:2 http:\/\/apt.postgresql.org wheezy-pgdg Release [29.2 kB]<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy-updates\/contrib Translation-en<\/span>
\nHit http:\/\/ftp.de.debian.org wheezy-updates\/main Translation-en\/DiffIndex<\/span>
\nGet:3 http:\/\/apt.postgresql.org wheezy-pgdg\/main amd64 Packages [43.6 kB]<\/span>
\nIgn http:\/\/apt.postgresql.org wheezy-pgdg\/main Translation-en_US<\/span>
\nIgn http:\/\/apt.postgresql.org wheezy-pgdg\/main Translation-en<\/span>
\nFetched 73.6 kB in 1s (38.9 kB\/s)<\/span>
\nReading package lists… Done<\/span>
\nReading package lists… Done<\/span>
\nBuilding dependency tree\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nReading state information… Done<\/span>
\nCalculating upgrade… Done<\/span>
\nThe following packages will be upgraded:<\/span>
\n\u00a0 file libmagic1<\/span>
\n2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.<\/span>
\nNeed to get 254 kB of archives.<\/span>
\nAfter this operation, 110 kB of additional disk space will be used.<\/span>
\nDo you want to continue [Y\/n]? <\/span>
\nGet:1 http:\/\/security.debian.org\/ wheezy\/updates\/main file amd64 5.11-2+deb7u1 [51.9 kB]<\/span>
\nGet:2 http:\/\/security.debian.org\/ wheezy\/updates\/main libmagic1 amd64 5.11-2+deb7u1 [202 kB]<\/span>
\nFetched 254 kB in 0s (1,136 kB\/s)<\/span>
\nReading changelogs… Done<\/span>
\n(Reading database … 142292 files and directories currently installed.)<\/span>
\nPreparing to replace file 5.11-2 (using …\/file_5.11-2+deb7u1_amd64.deb) …<\/span>
\nUnpacking replacement file …<\/span>
\nPreparing to replace libmagic1:amd64 5.11-2 (using …\/libmagic1_5.11-2+deb7u1_amd64.deb) …<\/span>
\nUnpacking replacement libmagic1:amd64 …<\/span>
\nProcessing triggers for man-db …<\/span>
\nSetting up libmagic1:amd64 (5.11-2+deb7u1) …<\/span>
\nSetting up file (5.11-2+deb7u1) …<\/span>
\nReading package lists… Done<\/span>
\nBuilding dependency tree\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>
\nReading state information… Done<\/span>
\nThe following extra packages will be installed:<\/span>
\n\u00a0 libpq5 pgdg-keyring postgresql-client-9.3 postgresql-client-common postgresql-common<\/span>
\nSuggested packages:<\/span>
\n\u00a0 oidentd ident-server locales-all postgresql-doc-9.3<\/span>
\nThe following NEW packages will be installed:<\/span>
\n\u00a0 libpq5 pgdg-keyring postgresql-9.3 postgresql-client-9.3 postgresql-client-common<\/span>
\n\u00a0 postgresql-common<\/span>
\n0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.<\/span>
\nNeed to get 6,142 kB of archives.<\/span>
\nAfter this operation, 24.4 MB of additional disk space will be used.<\/span>
\nDo you want to continue [Y\/n]? <\/span>
\nGet:1 http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg\/main libpq5 amd64 9.3.2-1.pgdg70+1 [565 kB]<\/span>
\nGet:2 http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg\/main pgdg-keyring all 2013.2 [4,802 B]<\/span>
\nGet:3 http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg\/main postgresql-client-common all 151.pgdg70+1 [70.7 kB]<\/span>
\nGet:4 http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg\/main postgresql-client-9.3 amd64 9.3.2-1.pgdg70+1 [1,477 kB]<\/span>
\nGet:5 http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg\/main postgresql-common all 151.pgdg70+1 [157 kB]<\/span>
\nGet:6 http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ wheezy-pgdg\/main postgresql-9.3 amd64 9.3.2-1.pgdg70+1 [3,867 kB]<\/span>
\nFetched 6,142 kB in 4s (1,391 kB\/s)\u00a0 \u00a0<\/span>
\nPreconfiguring packages …<\/span>
\nSelecting previously unselected package libpq5.<\/span>
\n(Reading database … 142292 files and directories currently installed.)<\/span>
\nUnpacking libpq5 (from …\/libpq5_9.3.2-1.pgdg70+1_amd64.deb) …<\/span>
\nSelecting previously unselected package pgdg-keyring.<\/span>
\nUnpacking pgdg-keyring (from …\/pgdg-keyring_2013.2_all.deb) …<\/span>
\nSelecting previously unselected package postgresql-client-common.<\/span>
\nUnpacking postgresql-client-common (from …\/postgresql-client-common_151.pgdg70+1_all.deb) …<\/span>
\nSelecting previously unselected package postgresql-client-9.3.<\/span>
\nUnpacking postgresql-client-9.3 (from …\/postgresql-client-9.3_9.3.2-1.pgdg70+1_amd64.deb) …<\/span>
\nSelecting previously unselected package postgresql-common.<\/span>
\nUnpacking postgresql-common (from …\/postgresql-common_151.pgdg70+1_all.deb) …<\/span>
\nAdding ‚diversion of \/usr\/bin\/pg_config to \/usr\/bin\/pg_config.libpq-dev by postgresql-common‘<\/span>
\nSelecting previously unselected package postgresql-9.3.<\/span>
\nUnpacking postgresql-9.3 (from …\/postgresql-9.3_9.3.2-1.pgdg70+1_amd64.deb) …<\/span>
\nProcessing triggers for man-db …<\/span>
\nSetting up libpq5 (9.3.2-1.pgdg70+1) …<\/span>
\nSetting up pgdg-keyring (2013.2) …<\/span>
\nRemoving apt.postgresql.org key from trusted.gpg: OK<\/span>
\nImporting apt.postgresql.org key: OK<\/span>
\nSetting up postgresql-client-common (151.pgdg70+1) …<\/span>
\nSetting up postgresql-client-9.3 (9.3.2-1.pgdg70+1) …<\/span>
\nupdate-alternatives: using \/usr\/share\/postgresql\/9.3\/man\/man1\/psql.1.gz to provide \/usr\/share\/man\/man1\/psql.1.gz (psql.1.gz) in auto mode<\/span>
\nSetting up postgresql-common (151.pgdg70+1) …<\/span>
\nAdding user postgres to group ssl-cert<\/span>
\nBuilding PostgreSQL dictionaries from installed myspell\/hunspell packages…<\/span>
\n\u00a0 en_us<\/span>
\nRemoving obsolete dictionary files:<\/span>
\n[warn] No PostgreSQL clusters exist; see „man pg_createcluster“ … (warning).<\/span>
\nSetting up postgresql-9.3 (9.3.2-1.pgdg70+1) …<\/span>
\nCreating new cluster 9.3\/main …<\/span>
\n\u00a0 config \/etc\/postgresql\/9.3\/main<\/span>
\n\u00a0 data\u00a0\u00a0 \/var\/lib\/postgresql\/9.3\/main<\/span>
\n\u00a0 locale en_US.UTF-8<\/span>
\n\u00a0 port\u00a0\u00a0 5432<\/span>
\nupdate-alternatives: using \/usr\/share\/postgresql\/9.3\/man\/man1\/postmaster.1.gz to provide \/usr\/share\/man\/man1\/postmaster.1.gz (postmaster.1.gz) in auto mode<\/span>
\n[ ok ] Starting PostgreSQL 9.3 database server: main.<\/span>
\nroot@deb74:~# <\/span><\/p>\n

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

Laziness. Need for one-click solution (Windows). Need for one-command solution (*nix). OK! \ud83d\ude42<\/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\/393"}],"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=393"}],"version-history":[{"count":0,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions"}],"wp:attachment":[{"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=393"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/it.tuxie.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}