Configure Cloud SQL (PostgreSQL) in Application Design Center

Preview

This product is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA products are available "as is" and might have limited support. For more information, see the launch stage descriptions.

Cloud SQL (PostgreSQL) is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud.

For more information, see the following:

• Cloud SQL overview
• About instance settings

Required configuration parameters

If your template includes a Cloud SQL (PostgreSQL) component, you must configure the following parameters before you deploy.

Feature	Parameter name	Description and constraint information	Background information
	Project ID	The App Hub service project where you want to manage the Cloud SQL resource.	Set up App Hub
	Name	name	Create a PostgreSQL instance
	Database Version	databaseVersion	Create a PostgreSQL instance
	Region	region	Manage instance locations

Optional configuration parameters

The following parameters are optional. To display advance parameters, in the Configuration area, select Show advanced fields.

Feature	Parameter name	Description and constraint information	Background information
	Zone	gceZone	Manage instance locations
	Edition	edition	Introduction to Cloud SQL for PostgreSQL editions
	Availability Type	availabilityType	Availability in Cloud SQL
	Enable Default Db	If selected, create a default database. In the Db Name field, enter the name of the default database.	Create a database on the Cloud SQL instance
	Enable Default User	If selected, create a default user. Enter a User Name and User Password for the default user.	Default PostgreSQL users
	Root Password	rootPassword	Initial root password when the instance is created.
	Database Deletion Policy	To allow the database to be abandoned rather than deleted, enter ABANDON.	PostgreSQL databases cannot be deleted if users other than cloudsqlsuperuser have access.
	Data Cache Enabled	Data cache	Data cache overview
	Tier	tier	Custom instance configurations
Disk Autoresize	Disk Autoresize	storageAutoResize	Enable automatic storage increases
	Disk Autoresize Limit	storageAutoResizeLimit	Automatic storage increase limit
	Disk Size	dataDiskSizeGb	Storage capacity
	Disk Type	The disk type for the Cloud SQL instance.	Storage type
	Pricing Plan	The pricing plan for the Cloud SQL instance.	SqlPricingPlan
Backup Configuration	Enabled	backupConfiguration	Create a PostgreSQL instance
	Start Time	BackupConfiguration	Create a PostgreSQL instance
	Region	location	Custom backup locations
	Zone	location	Custom backup locations
	Point in Time Recovery Enabled	pointInTimeRecoveryEnabled	Enable point-in-time recovery
	Transaction Log Retention Days	BackupConfiguration	Log retention period
	Retained Backups	transactionLogRetentionDays	Logs and disk usage
	Retention Unit	retentionUnit	Logs and disk usage
	Deletion protection	If selected, the Cloud SQL instance cannot be deleted.	Prevent deletion of an instance
Database flags	Name	databaseFlags	Configure database flags
	Value	databaseFlags	Configure database flags
	User Deletion Policy	To allow the user to be abandoned rather than deleted, enter ABANDON.	PostgreSQL users cannot be deleted if they have been granted SQL roles.
Additional Users	Name	Resource: User	About PostgreSQL users and roles
	Password	Enter a password, or select Random Password to generate a password.	About PostgreSQL users and roles
Additional Databases	Name	Resource: Database	Create and manage databases
	Collation	collation	Create and manage databases
	Master Instance Name	masterInstanceName	Create read replicas
	Instance Type	instanceType	SqlInstanceType
	Random Instance Name	Add a random suffix to the end of the instance name.
	Secondary Zone	The preferred zone for the replica instance.	secondaryZone
	Follow GAE Application	The App Engine application to follow. Must be in the same region as the Cloud SQL instance.	followGaeApplication
	Activation Policy	SqlActivationPolicy	Activation Policy
	Deletion Protection Enabled	deletionProtectionEnabled	Prevent deletion of an instance
	Read Replica Deletion Protection Enabled		Considering deletion protection for read replicas
Maintenance Window	Maintenance Window Day	day	About maintenance on Cloud SQL instances
	Maintenance Window Hour	hour	About maintenance on Cloud SQL instances
	Maintenance Window Update Track	updateTrack	About maintenance on Cloud SQL instances
User Labels	Key	Key label for the Cloud SQL instance	userLabels
	Value	Value label for the Cloud SQL instance	userLabels
Deny Maintenance Period	End Date	endDate	Configure a deny maintenance period
	Start Date	startDate	Configure a deny maintenance period
	Time	time	Configure a deny maintenance period
Insights Config	Query Plans Per Minute	queryPlansPerMinute	Use query insights to improve query performance
	Query String Length	queryStringLength	Use query insights to improve query performance
	Record Application Tags	recordApplicationTags	Enable query insights
	Record Client Address	recordClientAddress	Enable query insights
Password Validation Policy Config	Min Length	minLength	Set password policy
	Complexity	complexity	Set password policy
	Reuse Interval	reuseInterval	Set password policy
	Disallow Username Substring	disallowUsernameSubstring	Set password policy
	Password Change Interval	passwordChangeInterval	Set password policy
IP Configuration	Authorized Network Key	authorizedNetworks[]	Authorize with authorized networks
	Authorized Network Value	authorizedNetworks[]	Authorize with authorized networks
	IPv4 Enabled	ipv4Enabled	Configure Public IP
	Private Network	privateNetwork	Configure Private IP
	SSL Mode	sslMode	SSL mode
	Allocate IP Range	allocatedIpRange	Allocated IP address ranges for services
	Enable Private Path for Google Cloud Services	Private path for Google Cloud services	Create an instance that supports private services access and Private Service Connect
	PSC Enabled	PscConfig	Private Service Connect overview
	PSC Allowed Consumer Projects	PscConfig	Create an instance that supports private services access and Private Service Connect
Read Replicas	Read Replica Name Suffix	The optional suffix to add to the read instance name	Read replicas
	DB Charset	charset	Create a database on the Cloud SQL instance
	DB Collation	collation	Create a database on the Cloud SQL instance
IAM Users	ID	The IAM user's name	IAM authentication
	Email	The IAM user's email	Add an individual IAM user or service account to a Cloud SQL instance
	Type	SqlUserType	Add an individual IAM user or service account to a Cloud SQL instance
	Create Timeout	The optional timeout that is applied to limit long database creates.
	Update Timeout	The optional timeout that is applied to limit long database updates.
	Delete Timeout	The optional timeout that is applied to limit long database deletes.
	Encryption Key Name	diskEncryptionConfiguration	About client-side encryption
	Read Replica Deletion Protection	If selected, blocks Terraform from deleting replica SQL Instances.
	Enable Random Password Special	If selected, enables special characters in generated random passwords.
	Connector Enforcement	ConnectorEnforcement	Cloud SQL Language Connectors overview
	Enable Google ML Integration	enableGoogleMlIntegration	Build generative AI applications using Cloud SQL
	Database Integration Roles		Before you begin