Per creare un database in un cluster AlloyDB, connetti un client psql all'istanza primaria del cluster ed esegui un comando CREATE
DATABASE PostgreSQL.
[[["Facile da capire","easyToUnderstand","thumb-up"],["Il problema è stato risolto","solvedMyProblem","thumb-up"],["Altra","otherUp","thumb-up"]],[["Difficile da capire","hardToUnderstand","thumb-down"],["Informazioni o codice di esempio errati","incorrectInformationOrSampleCode","thumb-down"],["Mancano le informazioni o gli esempi di cui ho bisogno","missingTheInformationSamplesINeed","thumb-down"],["Problema di traduzione","translationIssue","thumb-down"],["Altra","otherDown","thumb-down"]],["Ultimo aggiornamento 2025-09-03 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,["# Create a database\n\nThis 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\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---------\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."]]
