PostgreSQL Data Extraction and Replication
Use Skippr as a Postgres-to-warehouse pipeline without maintaining custom replication code. Connect with host credentials, sync selected schemas, and let Skippr handle discovery, cleansing, and load.
Capabilities
- Extraction from Postgres schemas, tables, and nominated relations
- Deterministic schema discovery from PostgreSQL catalogs and samples
- Incremental and full-refresh sync modes
- Automatic data cleansing and dead letter handling
- Load into 9 supported data warehouses
CLI
bash
skippr connect source postgres-source \
--host localhost --port 5432 \
--user myuser --password mypass \
--database mydb \
--tables public.customers,public.ordersSample config
yaml
data_sources:
source:
Postgres:
host: localhost
port: 5432
user: myuser
password: mypass
database: mydbFull connector reference: postgres.
