​

External PostgreSQL Metadata (Recommended)

If —pg is specified, the metadata will be stored in the specified external PostgreSQL database. Below shows how to back up and restore the Bytebase metadata, let’s assume the metadata is stored in metadb.

​

Back up the metadata

pg_dump -h <<host>> -p <<port>> -U <<user>> -d metadb > metadb.sql

​

Restore Option 1 - Restore to the same metadb

​

Step 1 - Restore metadata to a temporary db

Create a new db metadb_new:

psql -h <<host>> -p <<port>> -U <<user>> metadb -c "CREATE DATABASE metadb_new"

Restore metdata to the new db:

psql -h <<host>> -p <<port>> -U <<user>> metadb_new < metadb.sql

​

Step 2 - Swap the existing metadata db with the temporary db

Rename existing metadb to metadb_old:

psql -h <<host>> -p <<port>> -U <<user>> postgres -c "ALTER DATABASE metadb RENAME TO metadb_old"

Rename metadb_new to the metadb, which will serve as the new metadata db:

psql -h <<host>> -p <<port>> -U <<user>> postgres -c "ALTER DATABASE metadb_new RENAME TO metadb"

​

Step 3 - Drop the old metadata db

Restart Bytebase and verify the metadata is restored properly. Afterwards, you can drop the old database:

psql -h <<host>> -p <<port>> -U <<user>> postgres -c "DROP DATABASE metadb_old"

​

Restore Option 2 - Restore to a different database metadb2

​

Step 1 - Modify the dump file

The dump file records the Bytebase metadata schema change history, and it’s database specific. So we need to change the existing record value from metadb to metadb2 first, which means to transfer the change history to metadb2.

Locate the migration_history table in the dump file, and for each record, find the value metadb which corresponds to the namespace column, change each occurrence from metadb to metadb2.

​

Step 2 - Restore metadata to metadb2

Create a new db metadb2:

psql -h <<host>> -p <<port>> -U <<user>> metadb -c "CREATE DATABASE metadb2"

Restore metdata to the new db:

psql -h <<host>> -p <<port>> -U <<user>> metadb2 < metadb.sql

​

Step 3 - Drop the old metadata db

Restart Bytebase and verify the metadata is restored properly. Afterwards, you can drop the old database:

psql -h <<host>> -p <<port>> -U <<user>> postgres -c "DROP DATABASE metadb"

​

Embedded PostgreSQL Metadata

If External PostgreSQL is not configured, then Bytebase will store the metadata under the —data directory. You can back up the --data directory or the pgdata subfolder.