![]() ![]() Click the Backup button and wait until the process is finished. ![]() Important: Do not use Plain as the format, as you will not be able to restore the backup using pgAdmin (it can be restored only using psql). On the General tab, set the filename path: click the Select file button (Browse), and in the new window select a folder, add the filename.A notification window will be displayed in the lower-right corner showing the progress, which has the option to display more details.īacking up and restoring a table in pgAdmin Click the Restore button and wait until the process is finished.Go to the Restore options tab, scroll down to the Queries section, and enable the Clean before restore option.Browse to the location of the backup and select the filename.In the new Restore dialog, on the General tab, set the format to Custom or tar.Right-click a database and select Restore.A notification window will be displayed in the lower-right corner showing the progress, which has the option to display more details. Go to the Dump options tab, scroll down to the Queries section, and enable the Include CREATE DATABASE statement option.Necessary: Do not use Plain as the format, as you will not be able to restore the backup using pgAdmin (it can be restored only using psql). On the General tab, set the filename path: click the Select file button (Browse), and in the new window, select a folder and add the filename.įor the Format, select backup, and then click Create.For details, see How to access the embedded Content Store database. You need to be connected to the DataClarity PostgreSQL DB. Backing up and restoring a table in pgAdmin.Backing up and restoring a DB in pgAdmin. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |