João Heron joaoheron

You have to do 2 things in order to allow your container to access your host's postgresql database

Make your postgresql listen to an external ip address
Let this client ip (your docker container) access your postgresql database with a given user

Obs: By "Host" here I mean "the server where docker is running on".

Make your postgresql listen to an external ip address

Find your postgresql.conf (in case you don't know where it is)

$ sudo find / -type f -name postgresql.conf

	#!/bin/bash

	PROJECT_ID="your-project-id"
	TAG_VALUE="tagValues/123456789"
	REGION="us"

	matching_resources=()

	for DATASET_ID in $(bq ls --max_results=1000 --project_id="$PROJECT_ID" \| awk 'NR>2 {print $1}'); do
	echo "--Checking dataset: $DATASET_ID"

	from os import path
	from argparse import ArgumentParser

	import psycopg2
	import pandas as pd
	from sqlalchemy import create_engine


	def main(source_uri, source_table, target_uri, target_table, if_exists='replace', method='multi', chunksize=5000, **kwargs):
	"""This main function extracts a table from a database and loads