patrond commented on issue #1032: URL: https://github.com/apache/age/issues/1032#issuecomment-1635434026
I have a working source database with a graph: `SELECT table_catalog, table_schema, table_name, table_type FROM information_schema.tables WHERE table_schema = 'iam' ORDER BY table_name ASC; --33 rows` the second query: `select * from ag_catalog.ag_label; --33 rows` I need to dump the whole database and create a second one from this dump. I use the command: `pg_dump -Fc -Upostgres <dbname> -f /<path>/<dump_filename>` and: `pg_restore -Upostgres -C -dpostgres /<path>/<dump_filename>` I run the queries again, in the new (destination) database: `SELECT table_catalog, table_schema, table_name, table_type FROM information_schema.tables WHERE table_schema = 'iam' ORDER BY table_name ASC; --33 rows` and the second one: the second query: `select * from ag_catalog.ag_label; --0 rows` tables in the ag_catalog schema are empty. thanks -- 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]
