Repository navigation
v.2.0.0
Parallel Cloning (v2.0.0)
Clone tables in parallel using multiple background workers:
-- Clone schema with 4 parallel workers
SELECT pgclone_schema_async(
'host=source-server dbname=mydb user=postgres',
'sales', true,
'{"parallel": 4}'
);
-- Combine parallel with other options
SELECT pgclone_schema_async(
'host=source-server dbname=mydb user=postgres',
'sales', true,
'{"parallel": 8, "conflict": "replace", "triggers": false}'
);Each table gets its own background worker. Track all workers via pgclone_jobs().
Materialized Views (v1.2.0)
Materialized views are now cloned automatically during schema clone, including their indexes and data. Disable with:
SELECT pgclone_schema(conn, 'analytics', true,
'{"matviews": false}');Exclusion Constraints (v1.2.0)
Exclusion constraints are now fully supported and cloned automatically alongside PRIMARY KEY, UNIQUE, CHECK, and FOREIGN KEY constraints.
Connection String Format
The source_conninfo parameter uses standard PostgreSQL connection strings:
host=hostname dbname=database user=username password=password port=5432
Or URI format:
postgresql://username:password@hostname:5432/database
Security Notes
- This extension requires superuser privileges to install and use
- Connection strings may contain passwords — consider using
.pgpassfiles
orPGPASSFILEenvironment variable instead - The extension connects to remote hosts using
libpq— ensure network
connectivity and firewall rules allow the connection