danhuawang opened a new issue, #11112: URL: https://github.com/apache/gravitino/issues/11112
### What would you like to be improved? In Step 3, the PostgreSQL dump command uses -F c (custom binary format): ` pg_dump -U username -h hostname -d database_name -n schema_name -s -F c -f schema-x.y.z-postgresql.sql ` However, Step 4 asks users to compare the dumped schema against the official schema-x.y.z-postgresql.sql file in the repository. This comparison is impossible because -F c produces a binary file, not plain SQL text. Running diff on it yields: ` Binary files schema-x.y.z-postgresql_dump.sql and schema-x.y.z-postgresql.sql differ ` Additionally, Step 4 says "compare the contents" but gives no concrete instructions on how to actually perform the comparison — no command, no tool, no guidance on what differences are acceptable vs. problematic. ### How should we improve? 1. In Step 3, remove -F c from the PostgreSQL dump command so it outputs plain SQL text: ` pg_dump -U username -h hostname -d database_name -n schema_name -s -f schema-x.y.z-postgresql.sql ` 2. In Step 4, add concrete comparison instruction -- 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]
