Installing EDB Postgres Extended Server on Ubuntu 22.04 x86_64 v17

Prerequisites

Before you begin the installation process:

• Set up the EDB repository.

  Setting up the repository is a one-time task. If you already set up your repository, you don't need to perform this step.

  To determine if your repository exists, enter:

  apt-cache search enterprisedb

  If no output is generated, the repository is installed.

  To set up the EDB repository:

  1. Go to EDB repositories.

  2. Select the button that provides access to the EDB repository.

  3. Select the platform and software that you want to download.

  4. Follow the instructions for setting up the EDB repository.

Install the package

sudo apt-get -y install edb-postgresextended-17

Initial configuration

This section steps you through getting started with your cluster including logging in, ensuring the installation was successful, connecting to your cluster, and creating the user password.

First, you need to initialize and start the database cluster. The edb-pge-17-setup script creates a cluster.

sudo PGSETUP_INITDB_OPTIONS="-E UTF-8" /usr/lib/edb-pge/17/bin/edb-pge-17-setup initdb

sudo systemctl start edb-pge-17

To work in your cluster, log in as the postgres user. Connect to the database server using the psql command-line client. Alternatively, you can use a client of your choice with the appropriate connection string.

sudo -iu postgres

psql postgres

The server runs with the peer or ident permission by default. You can change the authentication method by modifying the pg_hba.conf file.

Before changing the authentication method, assign a password to the database superuser, postgres. For more information on changing the authentication, see Modifying the pg_hba.conf file.

ALTER ROLE postgres with PASSWORD 'password';

Experiment

Now you're ready to create and connect to a database, create a table, insert data in a table, and view the data from the table.

First, use psql to create a database named hr to hold human resource information.

# running in psql
CREATE DATABASE hr;

CREATE DATABASE

Connect to the hr database inside psql:

\c hr

You are now connected to database "hr" as user "postgres".

Create columns to hold department numbers, unique department names, and locations:

CREATE TABLE public.dept (deptno numeric(2) NOT NULL CONSTRAINT dept_pk
PRIMARY KEY, dname varchar(14) CONSTRAINT dept_dname_uq UNIQUE, loc
varchar(13));

CREATE TABLE

Insert values into the dept table:

INSERT INTO dept VALUES (10,'ACCOUNTING','NEW YORK');

INSERT 0 1

INSERT into dept VALUES (20,'RESEARCH','DALLAS');

INSERT 0 1

View the table data by selecting the values from the table:

SELECT * FROM dept;

deptno  |   dname    |   loc
--------+------------+----------
10      | ACCOUNTING | NEW YORK
20      | RESEARCH   | DALLAS
(2 rows)