Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/sql/docs/postgres/quickstart below:

Quickstart: Connect to Cloud SQL for PostgreSQL from Cloud Shell

This page shows you how to create and connect to a PostgreSQL instance and perform basic SQL operations by using the Google Cloud console and a client. The resources created in this quickstart typically cost less than a dollar, assuming you complete the steps, including the cleanup, in a timely manner.

1. Sign in to your Google Cloud account. If you're new to Google Cloud, create an account to evaluate how our products perform in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.

2. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

   Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

   Go to project selector

3. Make sure that billing is enabled for your Google Cloud project.

4. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

   Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

   Go to project selector

5. Make sure that billing is enabled for your Google Cloud project.

6. Enable the necessary Google Cloud APIs. Console

   In the Google Cloud console, go to the APIs page.

   Go to APIs

   Enable the Cloud SQL Admin API. gcloud

   Click the following button to open Cloud Shell, which provides command-line access to your Google Cloud resources directly from the browser. Cloud Shell can be used to run the gcloud commands presented throughout this quickstart.

   Open Cloud Shell

   Run the gcloud services enable command as follows using Cloud Shell to enable the APIs required for this quickstart.:

   gcloud services enable sqladmin.googleapis.com

   This command enables the following APIs:

   • Cloud SQL Admin API

7. Make sure that you have the following role or roles on the project: Cloud SQL Admin (roles/cloudsql.admin), Cloud SQL Viewer (roles/cloudsql.viewer)

   Check for the roles

   1. In the Google Cloud console, go to the IAM page.

      Go to IAM
   2. Select the project.

   3. In the Principal column, find all rows that identify you or a group that you're included in. To learn which groups you're included in, contact your administrator.

   4. For all rows that specify or include you, check the Role column to see whether the list of roles includes the required roles.
   Grant the roles

   1. In the Google Cloud console, go to the IAM page.

      Go to IAM
   2. Select the project.
   3. Click person_add Grant access.

   4. In the New principals field, enter your user identifier. This is typically the email address for a Google Account.

   5. In the Select a role list, select a role.
   6. To grant additional roles, click add Add another role and add each additional role.
   7. Click Save.

In this quickstart, you use the Google Cloud console. To use the gcloud CLI, cURL, or PowerShell, see Create instances.

1. In the Google Cloud console, go to the Cloud SQL Instances page.

   Go to Cloud SQL Instances

2. Click Create instance.
3. Click Choose PostgreSQL.
4. In the Instance ID field, enter myinstance.
5. In the Password field, enter a password for the postgres user.

6. Click Create instance.

   You're returned to the instances list. You can click the new instance right away to see the details, but it won't be available for other operations until it initializes and starts.

   Note: In this example, the instance is created using default settings, including a public IP address.

In this quickstart, we'll use the psql client in Cloud Shell to connect to your instance. Cloud Shell is a remote, sandboxed environment.

1. Optional: If you're running a local instance of PostgreSQL, stop it before connecting to your Cloud SQL instance. Otherwise, you might encounter errors such as address already in use.

2. In the Google Cloud console, click the Cloud Shell icon () in the upper right corner.

   When Cloud Shell finishes initializing, a message, such as the following one, appears:

   Welcome to Cloud Shell! Type "help" to get started.
   Your Cloud Platform project in this session is set to sample-project.
   Use "gcloud config set project [PROJECT_ID]" to change to a different project.
   username@sample-project:~ (sample-project)$
   

3. Optional: If you haven't authorized gcloud CLI to access the Google Cloud Platform with your Google user credentials, then use the gcloud auth login command.

4. At the Cloud Shell prompt, connect to your Cloud SQL instance. Use the gcloud sql connect command as follows. Replace the instance name if your instance name is different.

   gcloud sql connect myinstance --user=postgres

5. In the dialog, click Authorize to authorize Cloud Shell to make API calls.

   The following message appears:

   Allowlisting your IP for incoming connection for 5 minutes...done.
   

   This message indicates that the public IP address of your Cloud SQL instance is being allowed to have incoming connections. After this message, you're prompted to enter your password.

6. Enter your postgres password.

   The psql prompt appears.

1. Create a SQL database on your Cloud SQL instance:

   CREATE DATABASE guestbook;

2. Connect to the database by entering the following command and specifying your password.

   \connect guestbook;

3. Insert sample data into the database:

   CREATE TABLE entries (guestName VARCHAR(255), content VARCHAR(255),
                           entryID SERIAL PRIMARY KEY);
   INSERT INTO entries (guestName, content) values ('first guest', 'I got here!');
   INSERT INTO entries (guestName, content) values ('second guest', 'Me too!');

4. Retrieve the data:

   SELECT * FROM entries;

   The result is:

     guestname   |   content   | entryid
   --------------+-------------+---------
    first guest  | I got here! |       1
    second guest | Me too!     |       2
   (2 rows)
   postgres=>
   

To avoid incurring charges to your Google Cloud account for the resources used on this page, follow these steps.

1. In the Google Cloud console, go to the Cloud SQL Instances page.

   Go to Cloud SQL Instances

2. Select the myinstance instance to open the Instance details page.
3. In the icon bar at the top of the page, click Delete.
4. In the Delete instance window, type your instance's name and then click Delete.

If you're not using the APIs that were enabled as part of this quickstart, you can disable them.

• APIs that were enabled within this quickstart:
  • Cloud SQL Admin API

1. In the Google Cloud console, go to the APIs page.

   Go to APIs

2. Select the Cloud SQL Admin API and then click the Disable API button.

• Learn about creating Cloud SQL instances.

• Learn about creating PostgreSQL users and databases for your Cloud SQL instance.

• See the Cloud SQL pricing information.

• In this quickstart you connected to the instance by using Cloud Shell. Learn about all of the connectivity options in Cloud SQL. How you connect depends on your networking configuration, such as if your Cloud SQL instance has a public or private IP address. See how to configure your Cloud SQL instance with a public IP and a private IP address.

• Learn about connecting to a Cloud SQL instance from other Google Cloud applications:

  • From an application running on the App Engine standard environment
  • From an application running on Compute Engine
  • From an application running on GKE
  • From Cloud Run

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4