# pg\_staging PostgreSQL backup restoration tool enters Debian's NEW queue

DevFeed: [pg\_staging PostgreSQL backup restoration tool enters Debian's NEW queue](<https://devfeed.tech/articles/yet-another-postgresql-tool-hits-debian-34356.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2009/11/yet-another-postgresql-tool-hits-debian/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2009-11-25T10:49:00Z

Content type: release

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Tool](<https://devfeed.tech/topics/tool.md>), [backups](<https://devfeed.tech/topics/backups.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Debian](<https://devfeed.tech/topics/debian.md>)

Tags: [backups](<https://devfeed.tech/tags/backups.md>), [commands](<https://devfeed.tech/tags/commands.md>), [databases](<https://devfeed.tech/tags/databases.md>), [debian](<https://devfeed.tech/tags/debian.md>), [pg-dump](<https://devfeed.tech/tags/pg-dump.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [server](<https://devfeed.tech/tags/server.md>), [snapshot](<https://devfeed.tech/tags/snapshot.md>), [staging](<https://devfeed.tech/tags/staging.md>)

## AI overview

The article introduces pg_staging, a PostgreSQL tool entering Debian's NEW queue. It provides commands for dumping and restoring databases and supports creating staging environments from backups for backup validation, development, integration, pre-live testing, and snapshots.

## Source excerpt

So there it is, this newer contribution of mine that I presented at PGDay is now in debian NEW queue. pg_staging will empower you with respect to what you do about those nightly backups ( pg_dump -Fc or something). The tool provides a lot of commands to either dump or restore a database. It comes with documentation covering about it all, except for the londiste support part, which will be there in time for 1.0.0 release. The Todo list is getting smaller and smaller, the version you'll soon find in debian sid is already called 0.9.