![]() This is the default behavior except when -schema, This option is similar to, but for historical reasons not identical to, specifying If that is not set, the user name specifiedĭump only the data, not the schema (data definitions). If this is not specified, theĮnvironment variable PGDATABASE is used. Specifies the name of the database to be dumped. The following command-line options control the content and format of the output. While running pg_dump, one should examine the output for any warnings (printed on standardĮrror), especially in light of the limitations listed below. The “directory” format is the only format that supports parallel dumps. Reordering of all archived items, support parallel restoration, and are compressed byĭefault. “custom” format ( -Fc) and the “directory” format ( -Fd). The most flexible output file formats are the Parts of the database are to be restored. pg_dump can be used to backup anĮntire database, then pg_restore can be used to examine the archive and/or select which Provides a flexible archival and transfer mechanism. ![]() When used with one of the archive file formats and combined with pg_restore, pg_dump The archive file formats are designed to be portable They allow pg_restore to be selective about what is restored, or even to reorder The alternative archive file formats must be used with pg_restore(1) to rebuild theĭatabase. Some modifications, even on other SQL database products. Script files canīe used to reconstruct the database even on other machines and other architectures with To restore from such a script, feed it to psql(1). Script dumps are plain-text filesĬontaining the SQL commands required to reconstruct the database to the state it was in at Objects that are common to all databases in a cluster (such as roles and tablespaces), useĭumps can be output in script or archive file formats. To back up an entire cluster, or to back up global ![]() pg_dump does not block other usersĪccessing the database (readers or writers). ![]() It makes consistent backupsĮven if the database is being used concurrently. Pg_dump is a utility for backing up a PostgreSQL database. Pg_dump - extract a PostgreSQL database into a script file or other archive file ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |