Tool Installation
This blog guides you to install Postgre SQL DB and establish a connection with SQLectron to perform CRUD operations.
Download Links
Installation of PostgreSQL
- After Downloading the setup, let us run it and choose the installation directory.
![Downloading setup]()
- Then let’s select the components to download like cmd line tool etc.
![Select components]()
- Then select the data directory for the DB, even post uninstallation we can fetch our data from this folder.
![Data directory]()
- This is where we setup the DB password for incoming connections. Let’s set up a moderately complex password.
![Set password]()
- We will leave the port at 5432 and locale to use the system default locale.
![Port]()
![Advanced options]()
- Finally, we will review the installation information and once everything is perfect let’s complete the setup by clicking Next. It might take up to 30 minutes depending on your system.
![Pre installation Summary]()
![Completing the PostgreSQL Setup Wizard]()
Connecting the Database to SQLectron
- Once we install the SQLectron, find and click the Add button.
- Let us add the following details to establish a connection and click on Test:
-
- Name: Any name for reference
- Database Type: PostgreSQL
- Server Address: localhost
- Port: 5432
- User: postgres
- Password: Setup during installation
- Initial Database/Keyspace: postgres
![Connection Test]()
- Click on Save once the test connection is successful.
- Click Connect once we are back on the home screen.
![Learn SQL]()
- Once connected, we will be taken to this screen, where we can execute our commands and perform CRUD operations.
![Execute our commands and perform CRUD operations]()
The next article of the series