Thread: pgsql database size

pgsql database size

From
Pierre Ochsenbein
Date:
Dear all,

how we can set size limit for one database?

Re: pgsql database size

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



Re: pgsql database size

From
Mahmoud Moharam
Date:
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 <pierreochsenbein@gmail.com> wrote:
Dear all,

how we can set size limit for one database?

Re: pgsql database size

From
Pepe TD Vo
Date:
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 <mmoharam@lucidya.com> 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 <pierreochsenbein@gmail.com> wrote:
Dear all,

how we can set size limit for one database?


Re: pgsql database size

From
Shreeyansh Dba
Date:
Hi Pierre,
Please find answers in line

On Wed, Mar 27, 2019 at 5:36 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> 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