{"id":2336,"date":"2012-05-22T14:00:00","date_gmt":"2012-05-22T12:00:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/"},"modified":"2012-05-22T14:00:00","modified_gmt":"2012-05-22T12:00:00","slug":"postgresql-installation","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/","title":{"rendered":"PostgreSQL: L&#8217;installation"},"content":{"rendered":"<p>Dans mon pr\u00e9c\u00e9dent article concernant PostgreSQL, j&#8217;ai annonc\u00e9 une serie d&#8217;article sur ce SGBDR, apr\u00e9s une courte introduction et avant de plonger dans le fonctionnement interne, l&#8217;architecture etc&#8230; je vous propose d&#8217;aborder l&#8217;installation du produit.<\/p>\n<h3>Que signifie installer PostgreSQL ?<\/h3>\n<p>Installer PorsgreSQL, signifie installer un ensemble de logiciels que l&#8217;on nomme &#8220;the Core Distribution&#8221; c&#8217;est \u00e0 dire l&#8217;ensemble des packages constituant ce qui est juste necessaire et utile au fonctionnement du SGBDR, \u00e0 savoir:<\/p>\n<ul>\n<li>Le serveur de base avec une documentation compl\u00e8te (html, man)<\/li>\n<li>Plusieurs outils en ligne de commande (par exemple psql, pg_ctl, pg_dump, pg_restore)<\/li>\n<li>Biblioth\u00e8que C (libpq) et embarqu\u00e9 C processeur (ecpg)<\/li>\n<li>Plusieurs langages c\u00f4t\u00e9 serveur (par exemple proc\u00e9dure plpgsql, pltcl, plperl)<\/li>\n<li>Plusieurs add-on populaires<\/li>\n<\/ul>\n<p>Contrairement au systeme propri\u00e9taire comme Oracle RDBMS ou SQLserver, la communaut\u00e9 PostgreSQL nous propose une multitude de possibilit\u00e9s pour installer le logiciel.<\/p>\n<p>Nous avons en fonction des systemes cibles un ou plusieurs choix possibles d&#8217;installation:<\/p>\n<ul>\n<li>Package binaires disponible pour FreeBSD \u00b7 Linux \u00b7 Mac OS X \u00b7 Solaris \u00b7 Windows<\/li>\n<li>Code sources disponible pour tous les OS<\/li>\n<li>Ou des distributions particulieres<\/li>\n<\/ul>\n<p>Ainsi si vous souhaitez installer PostgreSQL sur un system AIX vous devrez soit le compiler \u00e0 partir des sources soit trouver un fournisseur d&#8217;installeur.<br \/>\nDu cot\u00e9 de Linux il y a pour chaque distribution des packages binaires mais aussi des installeurs graphiques ind\u00e9pendants de la distribution.<br \/>\nLe site postgresql.org vous propose des <a href=\"http:\/\/www.postgresql.org\/download\/linux\/\">liens<\/a>.<br \/>\nLa soci\u00e9t\u00e9 EnterpriseDB maintien un tel installeur :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png\" alt=\"Installer_gui\" width=\"578\" height=\"278\" \/><br \/>\nNous n&#8217;explorerons pas ici l&#8217;ensemble des solutions, mais une de celle fournie par une distribution Ubuntu et l&#8217;installation graphique propos\u00e9e par EnterpriseDB.<\/p>\n<p>&nbsp;<\/p>\n<h3>Distribution Ubuntu ( debian )<\/h3>\n<h4>L&#8217;installation<\/h4>\n<p>Dans une installation g\u00e9r\u00e9e par une distribution\u00a0 un grand nombre d&#8217;\u00e9tapes seront prises en charge par le package \u00e0 savoir:<\/p>\n<ul>\n<li>La cr\u00e9ation du user postgres,<\/li>\n<li>Le choix d&#8217;organisation<\/li>\n<li>Le script de d\u00e9marrage de l&#8217;instance ( cluster de base de donn\u00e9es ) se trouvant dans \/etc\/init.d<\/li>\n<\/ul>\n<p>Dans le cas de PostgreSQL choisir une distribution c&#8217;est choisir une organisation et des outils (scripts) mis \u00e0 disposition par la distribution.<br \/>\nPour ubuntu l&#8217;installation se fait en tantque root par la commande suivante:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><samp><code><\/code><\/samp>root@ubuntu:~# apt-get install postgresql postgresql-client\nReading package lists... Done\nBuilding dependency tree\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\nReading state information... Done\nThe following extra packages will be installed:\n postgresql-9.1 postgresql-client-9.1\nSuggested packages:\n oidentd ident-server locales-all postgresql-doc-9.1\nThe following NEW packages will be installed:\n postgresql postgresql-9.1 postgresql-client postgresql-client-9.1\n0 upgraded, 4 newly installed, 0 to remove and 0 not upgraded.\nNeed to get 5,330 kB of archives.\nAfter this operation, 14.7 MB of additional disk space will be used.\nDo you want to continue [Y\/n]? Y\nGet:1 http:\/\/us.archive.ubuntu.com\/ubuntu\/ oneiric-updates\/main postgresql-client-9.1 amd64 9.1.3-0ubuntu0.11.10 [972 kB]\nGet:2 http:\/\/us.archive.ubuntu.com\/ubuntu\/ oneiric-updates\/main postgresql-9.1 amd64 9.1.3-0ubuntu0.11.10 [4,346 kB]\nGet:3 http:\/\/us.archive.ubuntu.com\/ubuntu\/ oneiric-updates\/main postgresql all 9.1+122ubuntu1 [5,852 B]\nGet:4 http:\/\/us.archive.ubuntu.com\/ubuntu\/ oneiric-updates\/main postgresql-client all 9.1+122ubuntu1 [5,830 B]\nFetched 5,330 kB in 15s (349 kB\/s)\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\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\nSelecting previously deselected package postgresql-client-9.1.\n(Reading database ... 59599 files and directories currently installed.)\nUnpacking postgresql-client-9.1 (from ...\/postgresql-client-9.1_9.1.3-0ubuntu0.11.10_amd64.deb) ...\nSelecting previously deselected package postgresql-9.1.\nUnpacking postgresql-9.1 (from ...\/postgresql-9.1_9.1.3-0ubuntu0.11.10_amd64.deb) ...\nSelecting previously deselected package postgresql.\nUnpacking postgresql (from ...\/postgresql_9.1+122ubuntu1_all.deb) ...\nSelecting previously deselected package postgresql-client.\nUnpacking postgresql-client (from ...\/postgresql-client_9.1+122ubuntu1_all.deb) ...\nSetting up postgresql-client-9.1 (9.1.3-0ubuntu0.11.10) ...\nupdate-alternatives: using \/usr\/share\/postgresql\/9.1\/man\/man1\/psql.1.gz to provide \/usr\/share\/man\/man1\/psql.1.gz (psql.1.gz) in auto mode.\nSetting up postgresql-9.1 (9.1.3-0ubuntu0.11.10) ...\nCreating new cluster (configuration: \/etc\/postgresql\/9.1\/main, data: \/var\/lib\/postgresql\/9.1\/main)...\nMoving configuration file \/var\/lib\/postgresql\/9.1\/main\/postgresql.conf to \/etc\/postgresql\/9.1\/main...\nMoving configuration file \/var\/lib\/postgresql\/9.1\/main\/pg_hba.conf to \/etc\/postgresql\/9.1\/main...\nMoving configuration file \/var\/lib\/postgresql\/9.1\/main\/pg_ident.conf to \/etc\/postgresql\/9.1\/main...\nConfiguring postgresql.conf to use port 5433...\nupdate-alternatives: using \/usr\/share\/postgresql\/9.1\/man\/man1\/postmaster.1.gz to provide \/usr\/share\/man\/man1\/postmaster.1.gz (postmaster.1.gz) in auto mode.\n * Starting PostgreSQL 9.1 database server\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\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [ OK ] \nSetting up postgresql (9.1+122ubuntu1) ...\nSetting up postgresql-client (9.1+122ubuntu1) ...\nroot@ubuntu:~#<\/pre>\n<p>&nbsp;<\/p>\n<p><samp><\/samp>Durant cette installation nous avons effectu\u00e9:<\/p>\n<ul>\n<li>Le t\u00e9l\u00e9chargement des binaires<\/li>\n<li>Leur installation<\/li>\n<li>La cr\u00e9ation d&#8217;un cluster de base de donn\u00e9es dont la configuration se trouve dans \/etc\/postgresql\/9.1\/main, et les donn\u00e9es dans \/var\/lib\/postgresql\/9.1\/main\/<\/li>\n<li>Le lancement du server de base de donn\u00e9es sur la configuration 9.1\/main sur un port d&#8217;acces 5433.<\/li>\n<li>La cr\u00e9ation d&#8217;un ensemble de r\u00e9pertoire contenant les binaires et scripts permettant d&#8217;\u00e9x\u00e9cuter les t\u00e2ches de connexion et d&#8217;administration du cluster de base.<\/li>\n<\/ul>\n<p>Nous reviendrons dans un futur poste sur cette organisation.<\/p>\n<h4>Le premier acc\u00e9s<\/h4>\n<p>Nous pouvons d\u00e8s maintenant acc\u00e9der au serveur par la commande psql \u00e0 partir de l&#8217;utilisateur OS postgres. Notez que la creation d&#8217;un fichier .postgresqlrc dans le home de l&#8217;utilisateur permettra au wrapper de l&#8217;installation Ubuntu\/debian d&#8217;\u00e9x\u00e9cuter le binaire:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">postgres@ubuntu:~$ psql\npsql.bin (9.1.3)\nType \"help\" for help.\n\npostgres=# l\n List of databases\n Name\u00a0\u00a0\u00a0 |\u00a0 Owner\u00a0\u00a0 | Encoding | Collation\u00a0 |\u00a0\u00a0 Ctype\u00a0\u00a0\u00a0 |\u00a0\u00a0 Access privileges\u00a0 \u00a0\n-----------+----------+----------+------------+------------+-----------------------\n postgres\u00a0 | postgres | UTF8\u00a0\u00a0\u00a0\u00a0 | en_US.utf8 | en_US.utf8 | \n template0 | postgres | UTF8\u00a0\u00a0\u00a0\u00a0 | en_US.utf8 | en_US.utf8 | =c\/postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 +\n |\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 | postgres=CTc\/postgres\n template1 | postgres | UTF8\u00a0\u00a0\u00a0\u00a0 | en_US.utf8 | en_US.utf8 | =c\/postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 +\n |\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 | postgres=CTc\/postgres\n(3 rows)<\/pre>\n<p>postgres=# q<br \/>\npostgres@ubuntu:~$<\/p>\n<h4>La d\u00e9sinstallation<\/h4>\n<p>C&#8217;est finalement une op\u00e9ration plus rare mais n\u00e9cessaire \u00e0 la maintenance d&#8217;un serveur apr\u00e9s une mont\u00e9e de version majeure.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">root@ubuntu:\/etc\/init.d# apt-get remove postgresql-9.1 \nReading package lists... Done\nBuilding dependency tree\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\nReading state information... Done\nThe following packages will be REMOVED:\n postgresql-9.1\n0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.\nAfter this operation, 11.7 MB disk space will be freed.\nDo you want to continue [Y\/n]? Y\n(Reading database ... 59965 files and directories currently installed.)\nRemoving postgresql-9.1 ...\n * Stopping PostgreSQL 9.1 database server\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\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [ OK ] \nupdate-alternatives: using \/usr\/share\/postgresql\/8.4\/man\/man1\/postmaster.1.gz to provide \/usr\/share\/man\/man1\/postmaster.1.gz (postmaster.1.gz) in auto mode.<\/pre>\n<h3>L&#8217;installation EnterpriseDB<\/h3>\n<p>Cette installation ressemble plus \u00e0 ce que nous avons l&#8217;habitude avec l&#8217;installer Oracle par exemple.\u00a0 Elle peut \u00eatre \u00e9x\u00e9cut\u00e9e en mode graphique, en mode texte ou en mode silencieux.<\/p>\n<h4>Le mode graphique<\/h4>\n<p>Il est n\u00e9cessaire de se connecter au serveur avec une redirection de port X11 sous ssh ou avec un client NX. Sous ubuntu la commande doit \u00eatre lanc\u00e9e par un sudo car l&#8217;installation se fait en tant que root.<\/p>\n<p><samp>pib@ubuntu$ <strong>sudo .\/postgresql-9.0.7-1-linux-x64.run<\/strong><\/samp><samp><\/samp><samp>password :<\/samp><samp><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup.png\" alt=\"Screenshot-Setup\" width=\"476\" height=\"347\" \/><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-1.png\" alt=\"Screenshot-Setup-1\" width=\"479\" height=\"349\" \/><\/samp><samp>\u00a0<\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-2.png\" alt=\"Screenshot-Setup-2\" width=\"482\" height=\"350\" \/><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-3.png\" alt=\"Screenshot-Setup-3\" width=\"482\" height=\"350\" \/><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-4.png\" alt=\"Screenshot-Setup-4\" width=\"480\" height=\"349\" \/><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-5.png\" alt=\"Screenshot-Setup-5\" width=\"484\" height=\"352\" \/><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-6.png\" alt=\"Screenshot-Setup-6\" width=\"482\" height=\"350\" \/><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-7.png\" alt=\"Screenshot-Setup-7\" width=\"483\" height=\"351\" \/><\/samp><samp><\/samp><samp><\/samp><samp><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-Setup-8.png\" alt=\"Screenshot-Setup-8\" width=\"484\" height=\"352\" \/><\/samp><samp><\/samp><\/p>\n<h4>Gestion de la connexion \u00e0 la base<\/h4>\n<p>L&#8217;installeur a pr\u00e9par\u00e9 un ficher de configuraton de l&#8217;environnement (pg_env.sh). Avant toute tentative de connexion nous allons positionner cette environnement par une recopie dans l&#8217;environnement de l&#8217;utilisateur postgres :<br \/>\npostgres@ubuntu:~$<strong> cp \/opt\/PostgreSQL\/9.0\/pg_env.sh .<\/strong><\/p>\n<p><samp>Visualiston cette environnement :<\/samp><samp><\/samp><samp>postgres@ubuntu:~$ <strong>cat pg_env.sh<\/strong><br \/>\n#!\/bin\/sh<br \/>\n# The script sets environment variables helpful for PostgreSQL<\/samp><\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><samp><\/samp>export PATH=\/opt\/PostgreSQL\/9.0\/bin:$PATH\nexport PGDATA=\/opt\/PostgreSQL\/9.0\/data\nexport PGDATABASE=postgres\nexport PGUSER=postgres\nexport PGPORT=5434\nexport PGLOCALEDIR=\/opt\/PostgreSQL\/9.0\/share\/locale\nexport MANPATH=$MANPATH:\/opt\/PostgreSQL\/9.0\/share\/man<\/pre>\n<p>&nbsp;<\/p>\n<p>Ex\u00e9cutons le script puis lan\u00e7ons psql.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">postgres@ubuntu:~$ . pg_env.sh\npostgres@ubuntu:~$ psql\nPassword: \npsql.bin (9.0.7)\nType \"help\" for help.\n\npostgres=# l\n List of databases\n Name\u00a0\u00a0\u00a0 |\u00a0 Owner\u00a0\u00a0 | Encoding | Collation\u00a0 |\u00a0\u00a0 Ctype\u00a0\u00a0\u00a0 |\u00a0\u00a0 Access privileges\u00a0 \u00a0\n-----------+----------+----------+------------+------------+-----------------------\n postgres\u00a0 | postgres | UTF8\u00a0\u00a0\u00a0\u00a0 | en_US.utf8 | en_US.utf8 | \n template0 | postgres | UTF8\u00a0\u00a0\u00a0\u00a0 | en_US.utf8 | en_US.utf8 | =c\/postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 +\n |\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 | postgres=CTc\/postgres\n template1 | postgres | UTF8\u00a0\u00a0\u00a0\u00a0 | en_US.utf8 | en_US.utf8 | =c\/postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 +\n |\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 | postgres=CTc\/postgres\n(3 rows)<\/pre>\n<h4>La proc\u00e9dure de d\u00e9sinstallation<\/h4>\n<p>La proc\u00e9dure de d\u00e9sinstallation est \u00e9galement graphique. Elle permet d&#8217;arr\u00eater le service, de supprimer les repertoires sauf celui contenant les donn\u00e9es mais ne supprime pas l&#8217;utilisateur postgres.<\/p>\n<p><strong>Remarque<\/strong> : l&#8217;outil fourni permet de faire l&#8217;installation en mode caract\u00e8re de mani\u00e8re interactive ou en mode silencieux.<\/p>\n<h3>R\u00e9f\u00e9rences documentaires<\/h3>\n<p><a href=\"http:\/\/docs.postgresql.fr\/\">http:\/\/docs.postgresql.fr\/<\/a><br \/>\n<a href=\"http:\/\/www.debianhelp.co.uk\/postgresql.htm\">http:\/\/www.debianhelp.co.uk\/postgresql.htm<\/a><br \/>\n<a href=\"http:\/\/www.enterprisedb.com\/resources-community\/pginst-guide\">http:\/\/www.enterprisedb.com\/resources-community\/pginst-guide<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans mon pr\u00e9c\u00e9dent article concernant PostgreSQL, j&#8217;ai annonc\u00e9 une serie d&#8217;article sur ce SGBDR, apr\u00e9s une courte introduction et avant de plonger dans le fonctionnement interne, l&#8217;architecture etc&#8230; je vous propose d&#8217;aborder l&#8217;installation du produit.<\/p>\n","protected":false},"author":28,"featured_media":2337,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[292,101,77],"type_dbi":[],"class_list":["post-2336","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-entreprisedb","tag-installation","tag-postgresql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>PostgreSQL: L&#039;installation - dbi Blog<\/title>\n<meta name=\"description\" content=\"Pierre Boizot, principal consultant vous propose \u00e0 travers cet article de d\u00e9couvrir comment installer une base de donn\u00e9es PostgreSQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: L&#039;installation\" \/>\n<meta property=\"og:description\" content=\"Pierre Boizot, principal consultant vous propose \u00e0 travers cet article de d\u00e9couvrir comment installer une base de donn\u00e9es PostgreSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-22T12:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png\" \/>\n\t<meta property=\"og:image:width\" content=\"710\" \/>\n\t<meta property=\"og:image:height\" content=\"342\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"headline\":\"PostgreSQL: L&#8217;installation\",\"datePublished\":\"2012-05-22T12:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/\"},\"wordCount\":805,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png\",\"keywords\":[\"EntrepriseDB\",\"Installation\",\"PostgreSQL\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/\",\"name\":\"PostgreSQL: L'installation - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png\",\"datePublished\":\"2012-05-22T12:00:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"description\":\"Pierre Boizot, principal consultant vous propose \u00e0 travers cet article de d\u00e9couvrir comment installer une base de donn\u00e9es PostgreSQL\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png\",\"width\":710,\"height\":342},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: L&#8217;installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"caption\":\"Open source Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL: L'installation - dbi Blog","description":"Pierre Boizot, principal consultant vous propose \u00e0 travers cet article de d\u00e9couvrir comment installer une base de donn\u00e9es PostgreSQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL: L'installation","og_description":"Pierre Boizot, principal consultant vous propose \u00e0 travers cet article de d\u00e9couvrir comment installer une base de donn\u00e9es PostgreSQL","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/","og_site_name":"dbi Blog","article_published_time":"2012-05-22T12:00:00+00:00","og_image":[{"width":710,"height":342,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png","type":"image\/png"}],"author":"Open source Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Open source Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"headline":"PostgreSQL: L&#8217;installation","datePublished":"2012-05-22T12:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/"},"wordCount":805,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png","keywords":["EntrepriseDB","Installation","PostgreSQL"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/","name":"PostgreSQL: L'installation - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png","datePublished":"2012-05-22T12:00:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"description":"Pierre Boizot, principal consultant vous propose \u00e0 travers cet article de d\u00e9couvrir comment installer une base de donn\u00e9es PostgreSQL","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Installer_gui.png","width":710,"height":342},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: L&#8217;installation"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","caption":"Open source Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2336"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2336\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2337"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2336"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}