PostgreSQL

Importing and Exporting Data in PostgreSQL

Introduction Effectively managing data is a key aspect of database administration. In PostgreSQL, scenarios often arise where data needs to be exported from one database and imported into another. This post will detail a practical approach to exporting data from a PostgreSQL table and then importing it into another database using command-line tools. Exporting Data

Importing and Exporting Data in PostgreSQL Read More »

How To Allow PostgreSQL Connection From Remote IP

In the last line, add the following details: Open postgresql.conf Find #listen_addresses = ‘localhost’, then uncomment and replace with the following values: listen_addresses = ‘*’ and save the file. What this does is, it opens connection for all IP range inside 10.116.0.0/20 subnet only. Next, let’s restart PostgreSQL service.

How To Allow PostgreSQL Connection From Remote IP Read More »

How To Install PostgreSQL On Ubuntu Linux

Postgres, also known as PostgreSQL, is a system for managing databases that uses the SQL language. It follows standard rules and offers advanced options like reliable transactions and the ability to handle multiple tasks simultaneously without causing reading delays. The tutorial explains how to set up Postgres on an Ubuntu 20.04 server. It covers the

How To Install PostgreSQL On Ubuntu Linux Read More »

Scroll to Top