Postgres Database Server Setup

This document provides step-by-step instructions to help you set up Postgres database Server. We'll walk you through the necessary configurations to ensure a smooth and secure connection to your database.

Introduction

Postgres database Server setup involves configuring connection parameters correctly. This guide will help you set up and verify these configurations, ensuring your application can communicate with the Postgres database server.

Step 1: Set up PostgresSQL database

1. Update the Package List

sudo apt update

2. Install PostgreSQL

To install the latest version of PostgreSQL from the official repository:

sudo apt install postgresql postgresql-contrib

3. Start and Enable PostgreSQL Service

After installation, PostgreSQL should automatically start. You can check its status with:

sudo systemctl status postgresql

4. To ensure PostgreSQL starts on boot:

sudo systemctl enable postgresql

1. Download PostgreSQL Installer for Windows

   • Go to the official PostgreSQL download (opens new window) page.

   • On the download page, select Windows as the operating system.

   • You will be redirected to EnterpriseDB's download page. Click on the Download the Installer button for the latest stable version of PostgreSQL.

   • The .exe installer for Windows will start downloading.

2. Run the Installer

   • Once the installer is downloaded, locate the file and double-click it to begin the installation process.

   • A welcome screen will appear. Click Next to continue.

   • Choose an installation directory: By default, PostgreSQL will be installed in C:\Program Files\PostgreSQL\<version>. You can change this if desired. Click Next.

   • Select components: The installer will ask you which components you want to install. It’s recommended to leave the defaults selected (PostgreSQL Server, pgAdmin, Command Line Tools, etc.). Click Next.

   • Choose the data directory: This is where your PostgreSQL databases will be stored. By default, the installer will create a data folder under the PostgreSQL directory. You can change it, but it's generally fine to leave it as default. Click Next.

   • Set a password for the PostgreSQL superuser (postgres): This password is critical because it will be used to access and manage PostgreSQL. Make sure to remember it, as you will need it later.

   • Select port number: The default PostgreSQL port is 5432. Unless you have a specific reason to change it, leave this as the default. Click Next.

   • Choose locale: The installer will typically auto-detect your system locale. You can leave it as default unless you have a specific reason to change it. Click Next.

   • Ready to Install: Once you have reviewed the installation settings, click Next to start the installation.

3. Complete the Installation

The installer will now copy files and set up PostgreSQL on your system. This process may take a few minutes.

4. Verify PostgreSQL Installation

   • After the installation, you can verify that PostgreSQL is running by using the pgAdmin tool or the command line

   • To verify PostgreSQL is running from the command line:

     • Type psql -U postgres
     • Enter the password you created during installation. You should now be connected to the PostgreSQL command-line interface.

Step 2: Access PostgreSQL

1. By default, PostgreSQL uses the postgres role for administrative tasks. To switch to the postgres user:

sudo -i -u postgres

2. Now, you can access the PostgreSQL command line interface (CLI) by typing:

psql

Step 3: Create Database

1. It is necessary to create a database for functionalities to work. You can create a database name "ycrash" in the command line

CREATE DATABASE ycrash;

2. By default, the username and password are postgres and postgres

Note: This step is common to all platforms (Linux and Windows)

Step 4: Modify the database configuration file

After the above step, create connector-postgres.xml file, which should contain the Postgres DB connectivity details as shown below:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
	<comment>This is easy!</comment>
	<entry key="JDBC_URL">jdbc:postgresql://localhost:5432/ycrash</entry>
	<entry key="JDBC_USER">username</entry>
	<entry key="JDBC_PASSWORD">password</entry>
</properties>

Place this file in the Upload Directory of yCrash server.

With the above configurations, restart the yCrash server so that the application now will be configured to use the postgres database.