humzakt commented on issue #1032: URL: https://github.com/apache/age/issues/1032#issuecomment-1646810567
Hi @patrond, There are a couple of steps you can follow when restoring a database with Apache AGE installed, specifically for the `ag_catalog` schema. - Backup your Database: Use the pg_dump command to backup your PostgreSQL database, this will also include AGE specific catalog data. ``` pg_dump -U [username] -d [database_name] > [backup_file.sql] ``` - Restore your Database: Once you have your backup file, you can restore it using psql. ``` psql -U [username] -d [database_name] < [backup_file.sql] ``` Please ensure that the database [database_name] you are restoring to, has AGE extension installed. If it's not, install AGE before you restore. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
