0

I had created one PostgreSQL instance under gcloud database.

Using default user (postgres) i want to create a tablespace but its not allowing me to create, says permission doesn't exist

Can we create custom tablespaces with gcloud database instances ?

saikiran
  • 1

1 Answers1

1

Can we create custom tablespaces with gcloud database instances ?

The short answer is no. To create custom tablespaces within Cloud SQL instances running PostgreSQL you will need to have SUPER USER permissions.

The reason why you can not give to yourself SUPER USER permission is because Cloud SQL instances are fully managed.

As seen here you have some restrictions since you can not give to yourself the permission specified.

Nonetheless, if you would like to have tablespaces you could setup your own PostgreSQL database within GCE instances.

Here you could see a tutorial on how to set up PostgreSQL on Compute Engine. Doing so will give you complete control over everything regarding PostgreSQL and the underlying instance running it.

I hope this helps.

Christopher Rodriguez Conde
  • 111
  • 1