pg_basebackup

See every discussion that mentions pg_basebackup

Brand Details

Type: Product

Description: pg_basebackup is a command-line utility included with PostgreSQL that creates backups of a PostgreSQL database cluster. It takes a binary copy of all database cluster files, without interrupting other database operations. These backups can be used for point-in-time recovery and setting up standby replica servers. Unlike `pg_dump`, which backs up individual databases, `pg_basebackup` backs up the entire cluster. The backup files can be restored by simply uncompressing and copying them to the database data directory. The utility also offers options for streaming logs and parallel compression for larger databases.

Website: https://www.postgresql.org/docs/current/app-pgbasebackup.html

Mention Analytics

Total Mentions: 5

Subreddit Mentions:

Positive Mentions: 4

Negative Mentions: 0

Sign up to filter, search, and track the sentiment of all brand mentions for pg_basebackup over time.

PositiveSoftware Recommendation

💬 12 comments

⬆︎ 12 upvotes

Suggested as a tool for creating a snapshot of the database.

Found in /r/PostgreSQL/
PositiveSoftware Recommendation

💬 20 comments

⬆︎ 23 upvotes

pg_basebackup is suggested as an out-of-the-box option for PostgreSQL backups, particularly suitable depending on data size and needs.

Found in /r/PostgreSQL/
PositiveSoftware Recommendation

💬 29 comments

⬆︎ 15 upvotes

pg_basebackup is recommended for physical replication, offering a potentially faster alternative if not upgrading PostgreSQL versions.

Found in /r/PostgreSQL/

Aug 19, 2024

How to backup big databases?

NeutralSoftware Recommendation

💬 22 comments

⬆︎ 6 upvotes

pg_basebackup is mentioned as the original method tried by the user and has issues restoring large databases.

Found in /r/PostgreSQL/

Jul 31, 2024

Migrate from 9.6 to 16 - Best option for minimal downtime?

PositiveSoftware Recommendation

💬 16 comments

⬆︎ 8 upvotes

pg_basebackup is mentioned for creating a standby server, facilitating a smoother upgrade process.

Found in /r/PostgreSQL/

Subscribe to our newsletter!

Stay up to date on how the latest changes in AI might impact your marketing plan.