pgsql database size

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

pgsql database size

Pierre Ochsenbein-2
Dear all,

how we can set size limit for one database?
Reply | Threaded
Open this post in threaded view
|

Re: pgsql database size

gilberto.castillo
El 2019-03-27 08:06, Pierre Ochsenbein escribió:
> Dear all,
>
> how we can set size limit for one database?
Why?


Reply | Threaded
Open this post in threaded view
|

Re: pgsql database size

Mahmoud Moharam
In reply to this post by Pierre Ochsenbein-2
if you ask for postgresql.conf file options
use this site :-
https://pgtune.leopard.in.ua/#/

On Wed, Mar 27, 2019 at 2:06 PM Pierre Ochsenbein <[hidden email]> wrote:
Dear all,

how we can set size limit for one database?
Reply | Threaded
Open this post in threaded view
|

Re: pgsql database size

Pepe TD Vo
thank you for posting this url.  Pretty helpful.

have a good day all.
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Wednesday, March 27, 2019 8:33 AM, Mahmoud Moharam <[hidden email]> wrote:


if you ask for postgresql.conf file options
use this site :-
https://pgtune.leopard.in.ua/#/

On Wed, Mar 27, 2019 at 2:06 PM Pierre Ochsenbein <[hidden email]> wrote:
Dear all,

how we can set size limit for one database?


Reply | Threaded
Open this post in threaded view
|

Re: pgsql database size

Shreeyansh dba
In reply to this post by Pierre Ochsenbein-2
Hi Pierre,
Please find answers in line

On Wed, Mar 27, 2019 at 5:36 PM Pierre Ochsenbein <[hidden email]> wrote:
Dear all,

how we can set size limit for one database?

PostgreSQL does not impose a limit on the total size of a database.
You can set trigger approach and locking databases for writing when it goes over the threshold value.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com