So, recently I had to reinstall my OS and I found myself struggling with setting up my development environment which includes PostgreSQL on the new installation and as you might have known, I work a lot with PostgreSQL and I had to install it before I could do anything.
Fortunately, I was able to set up everything perfectly and get my Django projects running within a short time.
SQL Databases like PostgreSQL store data in tables which are different items in an application. Tables have a fixed number of columns and a variable number of rows.
Below is a quick guide that should help anyone running on a Linux to get their PostgreSQL installation working with no hassles.
Please follow the steps carefully in order to avoid any error!
To Install Postgres on Ubuntu we need to run the following commands in our terminal.
$ sudo apt-get update
To install Postgres
$ sudo apt-get install postgresql postgresql-contrib libpq-dev
Enter y when prompted “Do you want to continue? [Y/n]” and wait as the installation completes.
Defining a user role
Postgres uses “roles” to aid in authentication and authorization. By default, Postgres creates a Postgres user and is the only user who can connect to the server.
We want to create our own superuser role to connect to the server.
For those running on elementary or parrot, run the following command first;
$ sudo -u postgres createuser --superuser $USER
Enter your desired password when prompted.
We then have to create a database with that
$USER login name, this is what Postgres expects as default.
$ sudo -u postgres createdb $USER
Navigate to your home directory and enter the following command to create the .psql_history in order to save your history:
$ touch .psql_history
You can now connect to the Postgres server by typing :
Homebrew makes it really easy to install Postgres. Just run:
$ brew install postgres
After it finishes installing, you’ll need to configure your computer a bit. First, you need to tell Postgres where to find the database cluster where your databases will be stored:
$ echo "export PGDATA=/usr/local/var/postgres" ~/.bash_profile
This command will help some programs find Postgres more easily:
$ echo "export PGHOST=/tmp" ~/.bash_profile
To load these configuration changes, run:
$ source ~/.bash_profile
To start the Postgres server, simply run:
You’ll have to leave that window open while you need the server. To stop the server, press Ctrl + C (not Cmd + C). If you want Postgres to boot at startup and run in the background, run:
$ ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
And to start it now (since it won’t boot automatically until you restart your computer), run:
$ pg_ctl start
create a default database with your computer’s username:
$ createdb $USER
And you’re done.