[GitHub] [age] humzakt commented on issue #1032: Restore ag_catalog schema - empty table

["humzakt (via GitHub)" <gi...@apache.org>]

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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org