CODEWITHSUNDEEP
postgresql
Alex Bran
Alex Bran

Reputation: 463

What is the best way to restrict size of database in PostgreSQL 13.0?

I am trying to restrict the maximum size of my postgreSQL databases.

I have read that there is no build in method (or at least yet), in order to do this, so it would be possible to create a tablespace with size limitation and then create the db there (though, I have also read that it is not necessarily recommended to do this).

I am using PostgreSQL 13.0 (Ubuntu 13.0-1.pgdg18.04+1) running on Ubuntu 18.04.

Are there any other ways?

Upvotes: 0

Views: 944

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246268

You have to create a tablespace of limited size for each database. There is no problem with that.

Upvotes: 3

Related Questions