...
Ensure UTF-8 Encoding is Set
Make 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. In the case of my Ubuntu server it was installed with the minimal configuration and was missing the utf-8 locale.
Install
The Ubuntu install is simply,
...
That's all there is for the installation. Ubuntu apt-get makes it easy and does all the hard work for you.
Further Details
You might also be interested to know that Ubuntu's apt-get installer does a number of other things you would have had to manually configure if you installed manually,
- Initialize a database storage area on disk called the database cluster.
- ...
| Warning |
|---|
In order to complete this section I need to figure out how to do a configured portable setup of PostgreSQL. |
Secure Master Account
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.
...