Skip to main content

Post-installation procedures

In this tutorial, we will walk through the various post-installation procedures you need to carry out after successfully installing PostgreSQL on your system. The tutorial is designed to be beginner-friendly and will cover topics such as setting up the database, creating users, and setting appropriate permissions.

Setting Up the Initial Database​

After successful installation, the first step is to set up the initial PostgreSQL database. To do this, we will use the initdb command. This command initializes the database in a specified directory.

initdb -D /usr/local/pgsql/data

In this example, /usr/local/pgsql/data is the directory where the database will be initialized. You can replace it with the directory of your choice.

Starting the PostgreSQL Server​

To start the PostgreSQL server, use the pg_ctl command. The -D option specifies the location of the database storage area.

pg_ctl -D /usr/local/pgsql/data start

Creating a Database​

To create a new database, you can use the createdb command. In the following example, we are creating a database named mydb.

createdb mydb

Accessing the Database​

You can access or connect to your newly created database using the psql command followed by the name of the database.

psql mydb

Creating a User​

PostgreSQL allows you to create users to manage your databases. The createuser command lets you create a new user. In this example, we are creating a user named myuser.

createuser myuser

Setting User Permissions​

You can also set permissions for your users. For instance, you can give a user the ability to create databases.

alter user myuser createdb;

In this command, alter user is used to change the attributes of a PostgreSQL user, myuser is the name of the user, and createdb is the attribute we are setting, allowing the user to create databases.

Conclusion​

Congratulations on completing the post-installation procedures for PostgreSQL! You've initialized your database, started your server, created a new database and user, and set permissions. These fundamental steps provide a solid foundation as you continue to explore and utilize PostgreSQL.

Remember, the commands provided here should be run in your system's command line interface. If you encounter any issues, make sure to check your commands for any spelling errors or incorrect paths. Happy computing!