{"id":32,"date":"2008-02-05T17:54:00","date_gmt":"2008-02-05T22:54:00","guid":{"rendered":"http:\/\/clusterbleep.net\/blog\/2008\/02\/postgresql-in-ubuntu-6-04-dapper-drake\/"},"modified":"2008-02-05T17:54:00","modified_gmt":"2008-02-05T22:54:00","slug":"postgresql-in-ubuntu-6-04-dapper-drake","status":"publish","type":"post","link":"http:\/\/clusterbleep.net\/blog\/2008\/02\/05\/postgresql-in-ubuntu-6-04-dapper-drake\/","title":{"rendered":"Postgresql in Ubuntu 6.04 Dapper Drake"},"content":{"rendered":"

This is the process I use to install and configure Apache2, Postgresql, PhpPgAdmin, and remote access for PgAdmin3 in Ubuntu Dapper.<\/p>\n

Install apache2, postgresql, and php-postgresql packages<\/h4>\n

sudo apt-get install apache2 postgresql-8.1 php5-pgsql<\/code><\/p>\n

Install phpPgAdmin<\/h4>\n

wget http:\/\/internap.dl.sourceforge.net\/sourceforge\/phppgadmin\/phpPgAdmin-4.1.3.tar.gz
tar -xzf phpPgAdmin-4.1.3.tar.gz
sudo mv phpPgAdmin-4.1.3 \/var\/www\/phpPgAdmin<\/code><\/p>\n

Configure phpPgAdmin<\/h4>\n

sudo nano -w t \/var\/www\/phpPgAdmin\/conf\/config.inc.php
change:<\/i>
  $conf['servers'][0]['host'] = '';
to:<\/i>
  $conf['servers'][0]['host'] = 'localhost';<\/code><\/p>\n

Set postgres password<\/h4>\n

sudo -u postgres psql template1
alter role postgres with password 'password';
\\q<\/code><\/p>\n

Enable remote access from LAN using password<\/h4>\n

sudo nano -w \/etc\/postgresql\/8.1\/main\/postgresql.conf
change:<\/i>
  addresses = 'localhost'
to:<\/i>
  listen_addresses = '*'
edit<\/i>
  \/etc\/postgresql\/8.1\/main\/pg_hba.conf
add:<\/i>
  host all all 192.168.0.0\/24 md5<\/code><\/p>\n

Access postgresql via phpPgAdmin<\/h4>\n

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

This is the process I use to install and configure Apache2, Postgresql, PhpPgAdmin, and remote access for PgAdmin3 in Ubuntu Dapper. Install apache2, postgresql, and php-postgresql packages sudo apt-get install apache2 postgresql-8.1 php5-pgsql Install phpPgAdmin wget http:\/\/internap.dl.sourceforge.net\/sourceforge\/phppgadmin\/phpPgAdmin-4.1.3.tar.gztar -xzf phpPgAdmin-4.1.3.tar.gzsudo mv … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6,5,7],"tags":[],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-linux","category-planet-ubuntu-users","category-tech"],"_links":{"self":[{"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/posts\/32","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":0,"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"wp:attachment":[{"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clusterbleep.net\/blog\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}