View As Table

PostgreSQL with Foreign Data Wrappers user guide

Platform/OS
Linux / Cross-platform (Server)
Category
Databases

PostgreSQL with Foreign Data Wrappers

PostgreSQL with Foreign Data Wrappers is a popular free database system that can reach out and work with data stored in many other places without copying it first.
PostgreSQL lets you run normal database queries that pull information from files sitting in cloud storage as if they were regular database tables. It uses Diskspace S3-compatible object storage by treating S3 buckets like a giant filing cabinet that it can open on demand to read spreadsheets, logs, or other files directly.
This means companies can analyze huge amounts of data kept cheaply in Diskspace without the expense and hassle of loading everything into the database. The real-world value is that you get powerful data insights while only paying for simple storage and avoiding slow data movement steps.

Connection / Setup

How to get your DiskSpace S3 credentials
New Accounts
  1. Create an account and log in to DiskSpace
  2. Click I'm ready to set up my storage
  3. Enter Bucket Name following the instructions
  4. Click Create Bucket and wait for it to be generated
  5. Find your Endpoint URL, Access Key, and Secret Key in the S3 Client Configuration section for use below
Existing Accounts
  1. Log in to DiskSpace
  2. Scroll to DiskSpace S3 Connection Info
  3. Find your Endpoint URL, Access Key, Secret Key, and Bucket Name for use below

Sign up or log in to set up your DiskSpace S3 Storage for PostgreSQL with Foreign Data Wrappers.