PortuguêsInglês
INPE
Search
  • 5. Why can´t TerraAmazon list the existing databases?

    There are several situations that can cause TerraAmazon not to connect to the databases or even show the list of the existing ones.

    a. The server is down

    When the server´s service is stoped it is not possible to access the databases. There are several situations that can stop the service, such as an undesired restart on the server due to power failure, Windows automatic updates and so on. To start the service again, locate PostgreSQL on the start menu and click on Start Server. It is necessary to login directly on the server computer to be able to do this.

    b. The firewall is blocking the port used by the DBMS

    When first installing a DBMS on the server, it might be needed to configure the Firewall not to block the port used by the DBMS. When working with PostgreSQL, this port is defined during the installation. To find the port number, open pgAdmin and locate the server in the servers tree: the port number is informed along with the database name and host.

    Access the Windows Firewall and configure it to open the port by informing it´s number. Each Windows has a different way to do that, please refer to Windows´ help pages for the procedures. It is necessary to login directly on the server computer to be able to do this.

    c. Network connection is down

    When working on corporate environment, network configurations can be very complex. At first, check if the network cable is correctly plugged in. If so, contact IT personnel to locate possible failures. When working locally, with both client and server applications running on the same machine, disconsider this situation.

    d. For other situations, please refer to the DBMS´s help pages.

    Created on 20/11/2013 in FAQ Terra Amazon - Site

    Was this helpful?