Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature may not be available in some browsers.
weil Server anderes System als Client ist? Client ist vielleicht 42 Millionen km entfernt vom Server?warum hat der Serverprozess keinen zugriff ?
vermutlich von einer Stelle, die du uns nicht zeigst.woher kann der fehler kommen ?
%%bash
sudo docker run -d --rm \
--name dbis-postgres-db-1 \
--hostname dbis-postgres-db-1 \
-v "${HOST_DATA_PATH}:/mnt/workspace:ro" \
-e POSTGRES_PASSWORD=root \
-p 127.0.0.1:5432:5432 \
--network dbis-hadoop-cluster-network \
postgres:14.4
%%bash
sudo docker ps --filter "name=dbis-postgres-db-1" --format "table {{.Names}}\t{{.Status}}"
import psycopg
postgres_conn = None
postgres_cursor = None
try:
postgres_conn = psycopg.connect("host='dbis-postgres-db-1' dbname='satisfaction' user='postgres' password='root'")
postgres_cursor = postgres_conn.cursor()
except psycopg.DatabaseError:
print("No database connection!")
# ...
postgres_cursor.close()
postgres_conn.close()
%%bash
cat <<"EOF" | sudo docker exec -i dbis-postgres-db-1 psql -U postgres
DROP DATABASE IF EXISTS satisfaction;
CREATE DATABASE satisfaction;
\c satisfaction;
CREATE TABLE department (
id_dept SERIAL PRIMARY KEY,
dept VARCHAR(50) NOT NULL,
city VARCHAR(50) NOT NULL,
zip_code INTEGER NOT NULL
);
/COPY department
FROM '/home/heyoka/Schreibtisch/master/DE/data-engineering-infrastructure.git/workspace/data/departments.csv'
WITH (
FORMAT CSV,
DELIMITER ',',
HEADER false,
NULL ''
);
...
EOF