Re: Database size in Postgresql

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Kunal Gupta <kunalgupta(at)live(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database size in Postgresql
Date: 2008-06-20 00:18:14
Message-ID: 485AF746.4020100@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kunal Gupta wrote:
> Hi ,
>
> I have a question, I am suppose to create database with limited size. Is
> there any way I can set limit to my database created in postgresql.

Not reasonably no.

> - Since in postgresql (or may be other also), when a database is
> created, a path to a directory is given in which all data is stored.
> - If I restrict the size of this directory then by database size will be
> automatically controlled.

And you might possibly corrupt data when you hit the barrier.

Joshua D. Drake

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2008-06-20 04:19:29 where would I find the files I need?
Previous Message Joshua D. Drake 2008-06-19 23:51:17 Re: Warm-standby in 8.2