<?xml version="1.0" encoding="UTF-8"?>
<post>
  <body>&lt;p&gt;Hi Sirs.&lt;/p&gt; &lt;p&gt;Now I am using &lt;a href=&quot;http://www.ubuntu.com/&quot;&gt;Ubuntu 7.10&lt;/a&gt; and my favorite Database Management System is &lt;a href=&quot;http://www.postgresql.org/&quot;&gt;Postgresql&lt;/a&gt;.&lt;/p&gt; &lt;p&gt;The best tutorial that I found is the Ubuntu tutorial about Postgresql and &lt;a href=&quot;http://www.pgadmin.org/&quot;&gt;pgAdmin&lt;/a&gt; installation.&lt;/p&gt; &lt;p&gt;Very easy to learn by every developer. This tutorial shows how to install both the Database Management System and the Administration and Development Platform.&lt;/p&gt; &lt;p&gt;&lt;a href=&quot;https://help.ubuntu.com/community/PostgreSQL&quot;&gt;https://help.ubuntu.com/community/PostgreSQL&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Easy to install and configure.&lt;/p&gt; &lt;p&gt;Just one line to install the 'Sophisticated open-source Object-Relational DBMS' and the 'graphical Open Source management, development and administration tool'.&lt;/p&gt; &lt;pre&gt;&lt;code&gt;$ sudo apt-get install postgresql pgadmin3&lt;/code&gt;&lt;/pre&gt; &lt;p&gt;Other two commands to configure your new account:&lt;/p&gt; &lt;pre&gt;&lt;code&gt;$ sudo -u postgres psql template1&lt;br /&gt;$ template1=# ALTER USER postgres WITH ENCRYPTED PASSWORD '&amp;lt;***password***&amp;gt;';&lt;/code&gt;&lt;/pre&gt; &lt;p&gt;I recommend this tutorial =]&lt;/p&gt; &lt;p&gt;See you.&lt;/p&gt;</body>
  <created-at type="datetime">2007-12-16T21:19:54Z</created-at>
  <id type="integer">6</id>
  <permalink>installing-postgresql-on-ubuntu-7-10</permalink>
  <title>Installing Postgresql on Ubuntu 7.10</title>
  <updated-at type="datetime">2008-10-25T02:24:15Z</updated-at>
  <user-id type="integer">3</user-id>
</post>
