postgres 프롬프트에서 \list를 입력하여 데이터베이스를 나열하고 소스 데이터베이스 인스턴스가 표시되는지 확인합니다.
postgres 프롬프트에서 \connect SOURCE_DB_NAME를 입력하고 메시지가 표시되면 비밀번호를 입력하여 데이터베이스 인스턴스에 연결하고 인스턴스와 연결된 테이블을 확인합니다. 프롬프트 이름이 postgres에서 SOURCE_DB_NAME으로 변경됩니다.
SOURCE_DB_NAME 프롬프트에서 \dt를 입력하여 이 인스턴스의 테이블을 확인합니다.
SOURCE_DB_NAME 프롬프트에서 이 사용자에게 인스턴스의 테이블에 있는 데이터에 액세스할 수 있는 권한을 부여하려면 GRANT alloydbexternalsync to USER;를 입력합니다. 또한 USER를 대상 데이터베이스 인스턴스에 연결하는 데 사용한 사용자 이름으로 바꿉니다.
SOURCE_DB_NAME 프롬프트에서 SELECT * from TABLE_NAME;을 입력하여 소스 데이터베이스 인스턴스의 테이블에서 복제된 정보를 확인합니다.
테이블에 올바른 정보가 표시되는지 확인합니다.
확인한 모든 항목이 예상대로 표시되면 Database Migration Service에서 데이터를 올바르게 마이그레이션한 것입니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-09-05(UTC)"],[[["\u003cp\u003eThis guide provides steps to verify that data has been correctly migrated from a source database instance to an AlloyDB database instance.\u003c/p\u003e\n"],["\u003cp\u003eThe minimum verification involves checking for the existence of the database instance and its tables within the AlloyDB instance.\u003c/p\u003e\n"],["\u003cp\u003eUsers can verify the migration by accessing the read replica of their migration job via the Google Cloud console and executing SQL commands in Cloud Shell.\u003c/p\u003e\n"],["\u003cp\u003eThe verification process includes listing databases, connecting to the source database, viewing its tables, granting access, and selecting data from a replicated table.\u003c/p\u003e\n"],["\u003cp\u003eSuccessful verification, evidenced by expected results, confirms that the Database Migration Service has accurately transferred the data.\u003c/p\u003e\n"]]],[],null,["# Verify a migration\n\n\u003cbr /\u003e\n\n[MySQL](/database-migration/docs/mysql/verify-migration \"View this page for the MySQL version of Database Migration Service.\") \\| [PostgreSQL](/database-migration/docs/postgres/verify-migration \"View this page for the PostgreSQL version of Database Migration Service.\") \\| PostgreSQL to AlloyDB\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\nVerifying a migration\n---------------------\n\nIn this page, you confirm that the migration job migrated data from your source database instance to the destination AlloyDB database instance correctly.\n\n\u003cbr /\u003e\n\nAt a minimum, verify that the database instance and its tables exist in the\nAlloyDB instance. You can also verify the tables' row counts or exact\ncontents.\n\n\nThe following steps show a minimal example:\n\n1. Go to the [AlloyDB clusters page](https://console.cloud.google.com/alloydb) in the Google Cloud console.\n2. Click the read replica entry of your migration job.\n3. Click the **Activate Cloud Shell** icon that appears in the upper-right region of the page.\n4. At the Cloud Shell prompt, press **Enter**.\n5. Optional: If an **Authorize Cloud Shell** dialog box appears, then click **Authorize**.\n6. At the **Enter password** prompt, enter the password that you either provided or that Database Migration Service generated for you in [Define and create the destination AlloyDB instance](/database-migration/docs/postgresql-to-alloydb/create-migration-job#dest).\n7. Run SQL commands to verify the migration. For example:\n 1. At the **postgres** prompt, enter `\\list` to list the databases and verify that you see your source database instance.\n 2. At the **postgres** prompt, enter `\\connect `\u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e, and enter the password when prompted, to connect to the database instance and see the tables associated with the instance. The name of the prompt changes from `postgres` to \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e.\n 3. At the \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e prompt, enter `\\dt` to see the tables of this instance.\n 4. At the \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e prompt, enter `GRANT alloydbexternalsync to `\u003cvar translate=\"no\"\u003eUSER\u003c/var\u003e`;` because you want to give this user permission to access the data in the tables of this instance. Also, replace \u003cvar translate=\"no\"\u003eUSER\u003c/var\u003e with the name of the user you used to connect to the destination database instance.\n 5. At the \u003cvar translate=\"no\"\u003eSOURCE_DB_NAME\u003c/var\u003e prompt, enter `SELECT * from `\u003cvar translate=\"no\"\u003eTABLE_NAME\u003c/var\u003e`;` to see the information that's replicated from a table in your source database instance.\n 6. Verify that you see the correct information in the table.\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\nIf everything you check is as you expect, then Database Migration Service has migrated the data correctly."]]
