digoal
2024-02-29
PostgreSQL , PolarDB , DuckDB , pg_dumpbinary
pg_dumpbinary is a program used to dump a PostgreSQL database with data dumped in binary format. The resulting dumps must be restored using pg_restorebinary.
cd /tmp
git clone --depth 1 https://github.com/lzlabs/pg_dumpbinary
cd /tmp/pg_dumpbinary
perl Makefile.PL
make
make install
未来可能会更多额外的扩展备份工具, 或者通过oss/http/ftp fdw, 支持更多的外部归档, 结合duckdb, parquet格式等实现高速分析.
https://commitfest.postgresql.org/47/4681/
Make COPY format extendable: Extract COPY TO format implementations
Background:
Currently, COPY TO/FROM supports only "text", "csv" and
"binary" formats. There are some requests to support more
COPY formats. For example:
- 2023-11: JSON and JSON lines [1]
- 2022-04: Apache Arrow [2]
- 2018-02: Apache Avro, Apache Parquet and Apache ORC [3]