Skip to content

Latest commit

 

History

History
99 lines (65 loc) · 3.18 KB

guide.en-sg.md

File metadata and controls

99 lines (65 loc) · 3.18 KB
title excerpt updated
Getting started with PostgreSQL
Using Your Databases
2023-02-15

Do you want to use PostgreSQL? Learn how to easily manage your databases!

Overview

Prerequisites

What is a PostgreSQL database?

PostgreSQL is an object-relational database management system (ORDBMS). It's a reliable and extensible system, which can manipulate large volumes of data. It also has a very active community.

Logging in to the database

[!primary]

Please note that this service does not give you access to the Host but to the databases hosted on the Host. Generic SQL commands work with no issues, and HeidiSQL or SQuirreL SQL software is fully compatible.

To log in to your database, make sure that you have:

  • The address of your database instance
  • Your database port
  • Your database username
  • Your database password
  • Your database name

All this information is available in the Web Control Panel{.external}.

There is also a guide here: Getting started with the Web Cloud Databases service{.ref}

Connect via the command line

psql --host=server --port=port --user=user --password=password database_name

Connect from a PHP script

1. <?php
2. $myPDO = new PDO('pgsql:host=host;port=port;dbname=dbname', 'username', 'password');
3. ?>

Connect from software (SQuirreL SQL)

  • Launch SQuirreL SQL and click on Aliases{.action}, then on +{.action}

launch SQuirreL SQL{.thumbnail}

  • Fill in the fields below and then confirm by clicking OK{.action} :
    • Name: Choose a name
    • Driver: Choose "PostgreSQL"
    • URL: Enter the server address and port in the following form jdbc:postgresql://server:port/database
    • User Name: Enter the username
    • Password: Enter the password

config connection{.thumbnail}

  • Confirm again by clicking the button Connect{.action}

valid connection{.thumbnail}

You will now be connected to your database:

config connection{.thumbnail}

Connecting via phppgAdmin

Soon available in another guide.

Export a PostgreSQL database

Export your database via the command line

pg_dump --host=server --port=port --user=username --password=password database_name > database_name.sql

Import a PostgreSQL database

Import your database via the command line

psql --host=server --port=port --user=user --password=password database_name < database_name.sql

Go further

For specialised services (SEO, development, etc.), contact OVHcloud partners.

If you would like assistance using and configuring your OVHcloud solutions, please refer to our support offers.

Join our community of users.