Skip site navigation (1) Skip section navigation (2)

Database size in Postgresql

From: Kunal Gupta <kunalgupta(at)live(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Database size in Postgresql
Date: 2008-06-19 19:55:28
Message-ID: BLU126-W48DEEB352F79916DA1E598A9AA0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-admin
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.

As per my surfing through various blogs, I found, its not possible directly.This is my approach please let me know if I am going right:

- 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.

please let me know if this is right and is there any more simpler way to reach this approach?

Thanks,
Kunal

_________________________________________________________________
The i’m Talkathon starts 6/24/08.  For now, give amongst yourselves.
http://www.imtalkathon.com?source=TXT_EML_WLH_LearnMore_GiveAmongst

Responses

pgsql-admin by date

Next:From: Peter KovacsDate: 2008-06-19 21:05:13
Subject: Re: Readline support in psql -- worked earlier for me
Previous:From: Roberto GarciaDate: 2008-06-19 18:56:09
Subject: Re: Major upgrade advice

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group