PostgreSQL – v12 – Importing data from previous version

Background Let us import data from PostgreSQL Version 11 into Version 12. Lineage PostgreSQL – v12 – Installation/Upgrade on MS Windows Link   Outline Previous Instance Start previous Instance Export Data Options pg_dumpall Using pg_dumpall, export data Stop previous Instance New Instance Start new Instance Import Data Options psql Using psql, import data Review imported … Continue reading PostgreSQL – v12 – Importing data from previous version

PostgreSQL :- Permit Network Access

Background It is time to allow network access to our PostgreSQL server. Outline Server Configuration ( Files ) postgresql.conf IP Interface ( Listen address ) Port Number Default :- 5432 pg_hba.conf ( PostgreSQL Client Authentication Configuration File ) Rules Firewall Host Firewall Network Firewall Reload Configuration pg_hba configuration Either of these options Command Line Shell … Continue reading PostgreSQL :- Permit Network Access

PostgreSQL :- psql :- \dt => Did not find any relations

Background Playing around with PostgreSQL. psql I have PostgreSQL installed on my laptop and so thankful I have psql, a terminal mode interface loaded, as well. Commands \dt Googled for how to list tables. And, was told to use the \dt command. Command Command - Sample Output Output - Image Output - Textual Explanation Upon … Continue reading PostgreSQL :- psql :- \dt => Did not find any relations