> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/integrations/data-storages/postgresql.md).

# PostgreSQL

## Configure PostgreSQL connection

#### Accessing the PostgreSQL Connector

* Navigate to the **Connectors Page** from the main menu.
* Select **Add Storage** and choose **PostgreSQL** from the list of available connectors.

#### Connection Settings

* **Connection name.** Enter a unique name for this connection
* **Host.** Specify the hostname or IP address of your PostgreSQL server.
* **Port.** Enter the port number your PostgreSQL server is listening on. The default port for PostgreSQL is `5432`.
* **Username.** Enter the username that will be used to connect to your PostgreSQL database.
* **Password.** Enter the password associated with the provided username.
* **Database.** Provide the name of the database you wish to connect to within your PostgreSQL server.
* **Schema (optional).** Enter the schema name here if you need to set a specific schema as default. You can leave this field blank or select another schema in the Source node in the Flow Designer. 

#### Test and Save

* **Test connection.** Click this button to verify that the connection settings are correct. If successful, you will see a confirmation message. If there are issues, you will receive an error message detailing what needs to be corrected.
* **Save and Test.** This button allows you to save your settings and immediately test the connection. If the connection test is successful, the connector will be saved and ready for use.