Fix documentation

[ckunki]

1. broken link in file README.md: Find all the documentation in the [Virtual Schemas project][vs-doc].
2. add prefix comment --/ to SQL script ending with slash / (required for DbVisualizer)
3. add documentation of PostgreSQL specifics: remote connections, create table, catalog, upper / lowercase, schema, database

• Gettingstarted
• create table etc.

Make portgres service listen to remote connections, see

• allow remote connection
• fix pg_hba.conf

Edit file /etc/postgresql/10/main/postgresql.conf (sudo vi) and add line

listen_addresses = '*'

Edit file /etc/postgresql/10/main/pg_hba.conf (sudo vi) and add line

# TYPE DATABASE USER CIDR-ADDRESS  METHOD
host  all  all 0.0.0.0/0 md5

restart postgres service to read changed configuration

sudo service postgresql restart

Try remote access

psql -h <REMOTE HOST> -p <REMOTE PORT> -U <DB_USER> <DB_NAME>

upload driver to bucket fs

curl -X PUT -T postgresql-42.4.2.jar  http://w:$BUCKETFS_PASSWORD@localhost:2580/default/postgresql-42.4.2.jar

Driver for ExaLoader

https://github.com/exasol/docker-db/#installing-custom-jdbc-drivers

File settings.cfg:

DRIVERNAME=POSTGRES_JDBC_DRIVER
JAR=postgresql-42.4.2.jar
DRIVERMAIN=org.postgresql.Driver
PREFIX=jdbc:postgresql:
FETCHSIZE=100000
INSERTSIZE=-1

Upload

curl -v -X PUT -T postgresql-42.4.2.jar  http://w:$BUCKETFS_PASSWORD@localhost:$BUCKETFS_PORT/default/drivers/jdbc/postgresql-42.4.2.jar
curl -v -X PUT -T settings.cfg  http://w:$BUCKETFS_PASSWORD@localhost:$BUCKETFS_PORT/default/drivers/jdbc/settings.cfg

or use https://github.com/exasol/bucketfs-client