Google Drive storage

To keep your backups in Google Drive, you need to create a Google Cloud project to access the Google Drive API, then sign in via your Google Account.

Create Google Cloud project

1. Create new project

Go to https://console.cloud.google.com/ and choose "new project" (top left).

2. Enable Google Drive API

Go to "API & Services" tab, then to "API library". Choose Google Drive API and enable it:

Enable Google Drive API

Go to "Credentials" "Create credentials" "Configure consent screen" and fill any data there:

Configure consent screen

4. Create OAuth client ID

Go to "Credentials" "Create credentials" "OAuth client ID":

Create OAuth client ID

5. Configure application settings

Fill the following data:

  • Application type: Web application
  • Authorized JavaScript origins: https://postgresus.com
  • Authorized redirect URIs: https://postgresus.com/storages/google-oauth

Then copy the credentials:

Configure application settings - part 1Configure application settings - part 2

6. Add scope

Go to "Data Access" and add scope "/auth/drive.file":

Add scope

7. Publish the app

Go to "Audience" and publish the app:

Publish the app

Sign in via Google account

1. Fill credentials data

Fill the credentials from the previous steps in Postgresus:

Fill credentials data

2. Choose your account

Choose your Google account to sign in.

3. Handle security warning

If you see a warning, click "Advanced" (left bottom corner) and choose "Proceed anyway".

Note: This warning appears because your app is not yet verified by Google. It's safe to proceed for your own application.

That's it! Your Google Drive is now connected to Postgresus and ready to store your PostgreSQL backups.