During the time of this article, the instructions on the Ubuntu wiki were pretty light and from what I can see not quite complete. These instructions are currently written for PostgreSQL 8.x. and 9.x.
Installing PostgreSQL
Ensure UTF-8 Encoding is Set
If you did not follow the Bonsai Framework to setup Ubuntu yourself, make sure that your operating system has the right encoding set as explained in the "Select Locale" part of my Ubuntu Linux Base Server article.
Install
The Ubuntu install is simply,
...
By default, the master account in the database postgres does not have a password. We want to set this up so that we can provide access to a dba without the dba requiring sudo access to the operating system. Also, leaving at is makes postgres open to any user with sudo privileges.
Change the Default postgres Database User Account
The first step, is to launch the postgresql shell.
...
All commands are prefixed by the the \. So to change the postgres account password. In the Bonsai Framework, we use the selected password algorithm with derived from the server name.
| Code Block | ||
|---|---|---|
| ||
postgres=# \password postgres |
...
- Using the pgAdmin III installed on the same system as Postgresql.
- From another machine using an SSH Tunnel.
Further Reading
| Page Tree | ||
|---|---|---|
|