[[["이해하기 쉬움","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-08-25(UTC)"],[[["\u003cp\u003eThis guide outlines the process of creating a PostgreSQL database within an AlloyDB cluster.\u003c/p\u003e\n"],["\u003cp\u003eDatabase creation requires connecting a \u003ccode\u003epsql\u003c/code\u003e client to the primary instance of the AlloyDB cluster.\u003c/p\u003e\n"],["\u003cp\u003eYou need specific IAM roles, such as \u003ccode\u003eroles/alloydb.admin\u003c/code\u003e, \u003ccode\u003eroles/owner\u003c/code\u003e, or \u003ccode\u003eroles/editor\u003c/code\u003e, to perform this task.\u003c/p\u003e\n"],["\u003cp\u003eThe process involves executing a \u003ccode\u003eCREATE DATABASE\u003c/code\u003e command at the \u003ccode\u003epsql\u003c/code\u003e prompt, adhering to PostgreSQL naming conventions.\u003c/p\u003e\n"]]],[],null,["This page describes how to create a PostgreSQL database in\nAlloyDB for PostgreSQL. Before you can create a database, you must [create a\ncluster and its primary instance](/alloydb/docs/cluster-create).\n\nTo create a database in an AlloyDB cluster, you connect a `psql`\nclient to the cluster's primary instance and then run a PostgreSQL `CREATE\nDATABASE` command.\n\n\nBefore you begin\n\n- The Google Cloud project you are using must have been [enabled to access AlloyDB](/alloydb/docs/project-enable-access).\n- You must have one of these IAM roles in the Google Cloud project you are using:\n - `roles/alloydb.admin` (the AlloyDB Admin predefined IAM role)\n - `roles/owner` (the Owner basic IAM role)\n - `roles/editor` (the Editor basic IAM role)\n\n If you don't have any of these roles, contact your Organization Administrator to request\n access.\n\n\u003cbr /\u003e\n\nProcedure\n\n1. Connect a `psql` client to the cluster's primary instance, as described in [Connect a psql client to an\n instance](/alloydb/docs/connect-psql).\n2. At the `psql` command prompt, enter a `CREATE\n DATABASE` command, as described in the [PostgreSQL\n documentation](https://www.postgresql.org/docs/16/sql-createdatabase.html). For example: \n\n ```sql\n CREATE DATABASE DATABASE_NAME;\n ```\n\n Follow the PostgreSQL rules in\n [Identifiers\n and Key Words](https://www.postgresql.org/docs/16/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS) when you create your database name."]]
