Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| system_administration:networking:powerbi_connection_to_postgres [2023/07/31 12:32] – created nadir | system_administration:networking:powerbi_connection_to_postgres [2023/08/11 11:13] (current) – aziz | ||
|---|---|---|---|
| Line 7: | Line 7: | ||
| * Open your docker-compose.yml file for editing (you can use any text editor you are comfortable with). | * Open your docker-compose.yml file for editing (you can use any text editor you are comfortable with). | ||
| * Find the section for your PostgreSQL service in the docker-compose.yml file and add the ports. It should look something like this: | * Find the section for your PostgreSQL service in the docker-compose.yml file and add the ports. It should look something like this: | ||
| - | < | + | < |
| db: | db: | ||
| image: postgres | image: postgres | ||
| Line 30: | Line 30: | ||
| * Run the following command to allow incoming traffic to the PostgreSQL port (5432): | * Run the following command to allow incoming traffic to the PostgreSQL port (5432): | ||
| <cli> | <cli> | ||
| - | $ iptables -t nat -A PREROUTING -p tcp --dport 7*** -j DNAT --to-destination < | + | $ iptables -t nat -A PREROUTING |
| </ | </ | ||
| Line 46: | Line 46: | ||
| * Click on "Get Data" from the Home tab. | * Click on "Get Data" from the Home tab. | ||
| * In the "Get Data" window, select " | * In the "Get Data" window, select " | ||
| - | * Enter the IP address of your Server in the " | + | * Enter the IP address of your Server in the " |
| - | | + | < |
| * In the " | * In the " | ||
| * Enter the PostgreSQL username and password you defined in the docker-compose.yml file. | * Enter the PostgreSQL username and password you defined in the docker-compose.yml file. | ||