Articles

Backing up PostgreSQL databases using cron jobs

Automated backups are essential for protecting your data. On ruachost.com, you can schedule...
Connecting to PostgreSQL using Node.js

Node.js applications can interact with PostgreSQL databases using the node‑postgres (pg)...
Connecting to PostgreSQL using PHP

PHP provides built‑in functions and PDO (PHP Data Objects) for connecting to PostgreSQL...
Connecting to PostgreSQL using Perl

Perl provides robust database connectivity through the DBI (Database Interface) module and the...
Connecting to PostgreSQL using Python

Python provides multiple libraries for connecting to PostgreSQL databases. On ruachost.com, you...
Connecting to PostgreSQL using the command line

PostgreSQL provides a powerful interactive terminal called psql that allows you to connect to...
Determining the PostgreSQL and PostGIS versions

When working with PostgreSQL and PostGIS, it’s important to know which versions are installed on...
Determining the size of PostgreSQL databases and tables

PostgreSQL provides built‑in functions to check the size of databases and tables. On...
ECCN and HTS numbers for PostgreSQL

When exporting software such as PostgreSQL from the United States to other countries, you may...
Importing and exporting PostgreSQL databases

PostgreSQL provides built‑in tools for backing up and restoring databases. On ruachost.com, you...
Managing PostgreSQL databases and users from the command line

PostgreSQL includes powerful command‑line tools that allow administrators to create, modify, and...
Renaming a PostgreSQL database

You may need to rename a PostgreSQL database when migrating data, restructuring accounts, or...
Setting up a remote PostgreSQL connection

On ruachost.com, you can connect to your PostgreSQL databases remotely from your local computer....
Using PostgreSQL client applications

PostgreSQL client applications allow you to connect to and manage your databases. On...

Powered by WHMCompleteSolution