Install PostgreSQL

Install

Follow the instructions on Digital Ocean’s Website.

One thing I did notice during the install:

Data page checksums are disabled.

I remember something about “the checksums require more processing power but insure data integrity” or something like that.

Since this is a dev/test system, I’m not going to worry too much about that.

Creating a New Role and Database

Create a new role

Follow the Digital Ocean instruction BUT use your “normal” userid you created when you installed the OS and say “y” to make it a “superuser”.

Create a base database for the new role

At the command line, run: createdb <userid> replacing <userid> with your “normal” userid.

If you do not create this database, when you try to execute psql as the normal user, you will get an error message.