Results of 1 - 8 of about 8 for hostname (0.002 sec.)
- Quack Remote Protocol 12254
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...CH requests, optionally parallelized on multiple threads. Default port: 9494 . All URIs use the quack: scheme, e.g., quack:hostname:port with the port defaulting to 9494 . Server-Side Usage Starting a Server A server is started from an existing DuckDB se...nect to one with -connect . See Command Line Arguments . By default the server refuses to bind anything other than a local hostname. To listen on an externally-reachable address, pass allow_other_hostname = true : {:.codebox-server} CALL quack_serve('qua...ck:0.0.0.0:9494', allow_other_hostname = true); Non-local servers serve HTTPS by default, using a self-signed certificate unless you pass ssl_cert_file and ssl_k... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Reference 11856
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...ting key files are not overwritten. Returns the file paths and the certificate fingerprint. quack_identify(name, provider, hostname, region, meta) Set this node's whoami identity fields. Any subset can be supplied. whoami() Table macro returning identity...Parameter Type Default Description listen_uri VARCHAR quack:localhost Positional. The Quack URI to listen on. allow_other_hostname BOOLEAN false Allow binding to a non-local hostname, e.g., 0.0.0.0 . token VARCHAR (generated) Authentication token client...empty) Human-readable node name. whoami_provider VARCHAR (empty) Deployment provider ( ec2 , docker , local , ...). whoami_hostname VARCHAR (empty) Network hostname / public address. whoami_region VARCHAR (empty) Deployment region. whoami_started_at VARC... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- PostgreSQL Extension and the Secret Manager 9145
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...ID OAUTH_CLIENT_SECRET OAUTH_SCOPE The following options are renamed to the corresponding keys: DATABASE – alias to DBNAME HOSTNAME – alias to HOST USERNAME – alias to USER Instead of separate connection options, the full connection URI can be specified...m" psql "host=$RDSHOST port=5432 dbname=postgres user=postgres sslmode=require password=$(aws rds generate-db-auth-token --hostname $RDSHOST --port 5432 --username postgres --region eu-west-1)" Configuring Secrets for IAM Authentication Authentication fr... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Connect 7988
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...onn = DriverManager.getConnection("jdbc:duckdb:"); Statement stmt = conn.createStatement()) { stmt.execute("ATTACH 'quack:⟨hostname⟩' AS remote_db (TOKEN '⟨MY_QUACK_TOKEN⟩')"); try (ResultSet rs = stmt.executeQuery("SELECT count(*) FROM remote_db.events"...f the ATTACH statement: stmt.execute("CREATE SECRET (TYPE quack, TOKEN '⟨MY_QUACK_TOKEN⟩')"); stmt.execute("ATTACH 'quack:⟨hostname⟩' AS remote_db"); Once attached, remote tables behave like local ones, so the whole JDBC API applies to them. Run CONNECT... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- ODBC Extension 7790
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...r};Server=tcp:127.0.0.1,1433;UID=sa;PWD=pwd;TrustServerCertificate=Yes;Database=test_db; DB2: Driver={IBM DB2 ODBC DRIVER};HostName=127.0.0.1;Port=50000;Database=testdb;UID=db2inst1;PWD=pwd; PostgreSQL: Driver={PostgreSQL Unicode};Server=127.0.0.1;Port=5... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Securing DuckDB 7790
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...nds to localhost by default; for remote access, put it behind a TLS-terminating reverse proxy instead of using allow_other_hostname . Note that duckdb -serve stores its token in a persistent (unencrypted) quack secret. For authentication and authorizatio... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Security 7790
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...supplied by a quack secret, the server generates a random token at startup. The server binds to localhost only, non-local hostnames require an explicit allow_other_hostname = true . The server does not use TLS for local URIs, as TLS for localhost commun... - https://man.mtool.work/duckdb/2.0/quack/security.html
- PostgreSQL Extension 7591
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...stgresscanner host=localhost port=5432 dbname=mydb connect_timeout=10 Name Description Default dbname Database name [user] host Name of host to connect to localhost hostaddr Host IP address localhost passfile Name of file passwords are stored in ~/.pgpas...eSQL password (empty) port Port number 5432 user PostgreSQL user name current user An example URI is postgresql://username@hostname/dbname . Configuring via Secrets PostgreSQL connection information can also be specified with secrets , see details on the... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work