psql<\/strong> command. To do so, use this command syntax in the client machine:<\/p>psql -h ip_address -p port -d database -U username<\/pre>For example, run this command to connect to the TheNewUser database hosted in a VPS with the 185.185.185.185 <\/strong>IP address using the TheNewUser<\/strong> account:<\/p>psql -h 185.185.185.185 -p 5432 -d TheNewUser -U TheNewUser<\/pre>Remember that the default PostgreSQL port is 5423<\/strong>. To verify if the connection is successful, run this command:<\/p>\\conninfo<\/pre>Once connected, you can send database queries to retrieve data. To enable PostgreSQL remote access in your application, install a database driver and import the module into your code.<\/p>
For this tutorial, we will show you how to do so in a Python application hosted in an Ubuntu 22.04<\/strong> VPS. After connecting via SSH, follow these steps:<\/p>\n- Install the pip package manager <\/strong>using this command. If you already have it, skip this step:<\/li>\n<\/ol>
sudo apt-get install python-pip<\/pre>\n- Download and install the psycopg2<\/strong> database driver using pip:<\/li>\n<\/ol>
pip install psycopg2-binary<\/pre>\n- Add the following line to your application code to import the module and establish a connection with the PostgreSQL database. Remember to change the value accordingly:<\/li>\n<\/ol>
import psycopg2\n# Connect your app to the remote database.\nconn = psycopg2.connect(host=\"182.182.182.182\", port=\"5432\", dbname=\"TestNewUser\", user=\"TestNewUser\", password=\"UserPassword\")\n# Open a cursor for database operations\ncur = conn.cursor()\n# Execute a query. Replace table with your own. \ncur.execute(\"SELECT * FROM table\")\n# Retrieve data\nrecords = cur.fetchall()<\/pre>9. Install pgAdmin<\/h3>
Install the pgAdmin<\/strong> web-based GUI to simplify your PostgreSQL database management tasks. We will use the APT package manager to install it:<\/p>\n- Run these commands individually to add the pgAdmin official repository:<\/li>\n<\/ol>
curl -fsSL https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo gpg --dearmor -o \/etc\/apt\/trusted.gpg.d\/pgadmin.gpg\n\nsudo sh -c 'echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main\" > \/etc\/apt\/sources.list.d\/pgadmin4.list'<\/pre>
![\"\"](\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/11\/Linux-cheat-sheet.png\/public\")
<\/a><\/figure><\/div>![\"The](\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2021\/10\/vps-ssh-username-and-ip-address-on-hpanel.png\/public\")