At this time.
We are going through the details related to troubleshooting and debugging issues.
Issues can be broadly grouped into three categories.
They are nothing but database connectivity issues.
Then syntax and semantic errors, then bugs in queries.
At this juncture, we are going through the details related to database connectivity issues.
When it comes to database connectivity issues, these are some of the most popular examples.
Connection timeout host unreachable, insufficient permissions or privileges, access denied, incorrect
username and password.
Even within these five issues, these too fall under one sub category.
These too will pop up when we are not able to talk to the server on which database is set up.
If you run into these issues, then you should be able to use a tool called as Telnet to troubleshoot
the issue in case if you are attempting to connect to Postgres database server on your PC and if you
are running into issues such as connection timeout host unreachable.
ET cetera, then you should have telnet setup on this PC.
If you are attempting to connect to database from app server, if you are running into these issues,
then you need to make sure you set up Telnet on the server where the app is going to be deployed.
When it comes to tools like Tableau, the issue can be troubleshooted in a different way because we
will not be able to set up tools like Telnet on top of tools like Tableau.
However, if you are actually trying to connect from the servers, then you should be able to have telnet
on the server using Telnet.
You should be able to troubleshoot these kind of issues.
The issues are nothing but connection.
Timeout host unreachable.
ET cetera.
When it comes to the current setup on our PC or Mac, we have Postgres database server in which databases
are set up.
Also we have Pgadmin which is set up on the same PC or Mac.
We will be able to connect to these databases using localhost.
Even here, if we have telnet, we should be able to troubleshoot some of these issues.
Let's make sure we confirm whether we have Telnet on our Mac or PC.
If we do not have Telnet.
We'll also go through the details about how to set up Telnet so that we can use it.
If you are using Mac, if you want to validate Telnet, you just launch our terminal.
Once the terminal is launched, you should be able to say Telnet like this and hit enter.
If Telnet is set up, you should be able to see the interface like this.
If you are not seeing something like this, if it is saying command not found, that means the Telnet
is not set up.
If you have brew setup then you should be able to use brew install Telnet.
It will take care of installing Telnet for you.
This is with respect to Mac.
You just have to validate by typing telnet like this.
Once you hit enter.
If it is taking you into this telnet cli you are good to go.
You can quit and come out of it.
If it complains saying no command found, then you need to make sure it is installed using brew or some
other alternative approach.
Now let me exit from here.
If you are using Windows, then you should be able to validate whether you have Telnet or not by launching
partial.
Partial is nothing but a DOS prompt or CLI in windows to interact with Windows file system using commands,
you should be able to validate whether you have telnet or not by typing telnet like this.
You see, it is saying the term telnet is not recognized as the name of a command let function, script
file or operable program.
You don't need to install anything when it comes to Windows 10 or 11.
You just have to search for Telnet here.
Then it will actually show this turn Windows features on or off control panel.
You have to click on it.
It will take you to control panel and then turn Windows features on or off.
These are alphabetically ordered.
If you scroll down and go for T, you see Telnet client here, you just have to select this so that
it is enabled.
Then you should be able to click on okay, it will take care of setting up telnet on your machine.
You don't need to explicitly install anything to have telnet set up on our windows machine.
Now I should be able to click on close.
If PowerShell is still active, it is better to close and start again.
In my case I have already closed.
Let me launch PowerShell once again.
Let me go to PowerShell.
Now let me say Telnet hit enter.
You see it have got into the telnet cli.
Now we should be able to say quit and come out of it.
This is how you should be able to take care of setting up telnet on your mac or PC.
I have demonstrated in both of these environments make sure you have telnet before going further.
We will actually see how to use Telnet to troubleshoot the issues such as connection, timeout or host
unreachable.
We will reproduce the issue and then we will see how to troubleshoot using Telnet.
We will also go through the details about how to fix.