Skip to main content

Install PostgreSQL

Follow these steps to install PostgreSQL on your system:

Step 1: Update Your Package Lists (Linux)​

If you're using a Linux-based system, it's a good practice to update your package lists to ensure you are installing the latest version of PostgreSQL. Open your terminal and run:

sudo apt update

Step 2: Install PostgreSQL​

Now, you can install PostgreSQL. Use the following command for your specific operating system:

On Ubuntu and Debian-based Systems:​

 sudo apt-get install postgresql

On CentOS and RHEL-based Systems:​

sudo yum sudo apt-get install postgresql

On macOS (using Homebrew):​

If you're on macOS and use Homebrew, you can install PostgreSQL with:

brew install postgresql

Step 3: Start and Enable PostgreSQL Service​

After installation, you need to start and enable the PostgreSQL service to ensure it starts automatically on system boot. Use the following commands:

On Ubuntu and Debian-based Systems:​

sudo systemctl start postgresql
sudo systemctl enable postgresql

On CentOS and RHEL-based Systems:​

sudo systemctl start postgresql
sudo systemctl enable postgresql

On macOS (using Homebrew):​

If you're using Homebrew on macOS, PostgreSQL should start automatically upon installation. You can use the following commands to start or stop it:

brew services start postgresql

Step 4: Access PostgreSQL​

By default, PostgreSQL is configured to use the "postgres" user. You can access the PostgreSQL prompt with the following command:

sudo -u postgres psql

Step 5: Create a Table and Perform Queries​

Now that PostgreSQL is installed and you have access to the PostgreSQL prompt, let's create a sample table and perform some basic queries. You can create a table like this:

CREATE TABLE employees (
    employee_id INT PRIMARY KEY,
    first_name VARCHAR (50),
    last_name VARCHAR (50),
    department VARCHAR (50)
);

You can insert data into this table using the INSERT statement:

INSERT INTO employees (employee_id,first_name, last_name, department)
VALUES (1,'John', 'Doe', 'HR'),
       (2,'Jane', 'Smith', 'Marketing');

And you can query the data using the SELECT statement:

SELECT * FROM employees;

These are just simple examples to get you started with PostgreSQL. You can explore more complex SQL queries and database management tasks in the official PostgreSQL documentation.

That's it! You successfully installed PostgreSQL, created a table, and performed basic queries on it.

Connect PostgreSQL with RisingWave

RisingWave Cloud provides fully managed cloud hosted RisingWave, an easy-to-use, cost-efficient, secure, and highly scalable stream processing database with an intuitive and user-friendly interface, ensuring a seamless user experience.

Create a RisingWave cluster within RisingWave Cloud using RisingWave free-tier account. After succesfully deploying RisingWave cluster, create a source table in RisingWave SQL editor as:

CREATE TABLE employees (
    employee_id INT,
    first_name VARCHAR,
    last_name VARCHAR,
    department VARCHAR,
    PRIMARY KEY (employee_id)
)
WITH (
 connector = 'postgres-cdc',
 hostname = 'localhost'
 port = '5432',
 username = 'postgres',
 password = 'postgres',
 database.name = 'dev',
 schema.name = 'public',
 table.name = 'employees'
);

After successfully creating a source table in RisingWave, you can query it as:

SELECT * FROM employees;

Congratulations, you have successfully ingested data from PostgreSQL CDC, and then, query the data in the table.

For more detailed information related to PostgreSQL CDC, please refer to RisingWave Documentation.