Choose a guide for the task you need to complete
The five tutorials below cover specific administration tasks. Each link includes a short explanation to help you choose where to start.
If you are new to PostgreSQL, start with the views guide, then read the export and restore guides as a pair. For Oracle, choose between managing Data Pump paths and checking data files with DBVERIFY.
Browse our database guides covering PostgreSQL backups, restores and views, alongside Oracle directory management and file integrity checks.
PostgreSQL and Oracle guides
- How to create a PostgreSQL backup with pg_dump
For preparing a logical export with
pg_dumpand recording its log. The example uses a custom archive and a schema filter, not a copy of the whole server. Identify the database and objects you need to export. - How to restore a PostgreSQL backup created with pg_dump
For understanding how to restore an archive with
pg_restore. Read it alongside the export guide and prepare a separate test destination. This tool restores supportedpg_dumparchive formats, not plain-text SQL scripts. - Viewing database views in PostgreSQL
For listing views, filtering by schema or owner, and exploring the tables they reference. It introduces PostgreSQL's catalogues through focused queries. Visible results can depend on the catalogue used and the user's permissions.
- Create, replace or remove a directory in Oracle
For managing a
DIRECTORYobject used by Data Pump. The object references a server path; creating it does not create the physical folder. Before changing it, review Oracle privileges, operating-system permissions and jobs using the object separately. - Check Oracle database file integrity using DBVerify
For checking the physical structures of a data file with
DBVERIFYand reviewing its log. The guide includes sample output and links to DBVerifyLog for working with several files. This check does not repair data or replace a recovery test.
Before applying the examples
- Identify the environment: database system and version, server, database, schema and installed tool. A database and a schema are not the same thing.
- Adapt paths and permissions: the articles include historical Windows examples. Check paths, users and filenames rather than copying them unchanged, and avoid overwriting backups or logs you need to keep.
- Separate practice from production: use test data and an isolated destination for restore exercises. Do not change archiving options or permissions on a live server simply to reproduce an example.
- Review the result: read the full log and check the recovered objects. Having a backup file alone does not prove that you can recover what you need.
Check parameters and requirements against the documentation for your version: pg_dump, pg_restore, Oracle 19c DIRECTORY and Oracle 19c DBVERIFY.
Index expanded on . This date refers to the guidance on this page, not to a new test of every linked tutorial.
Comments (0)
Comments are shown in their original language.
No comments have been published yet. Be the first to join the conversation.