473,765 Members | 2,070 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

limit database size

exoskeleton
104 New Member
hi dear experts, pls help. i was asked by my boss to limit the size of the database to 10MB per account holder. how can this be done? any code will be greatly appreciated...i m using PHP and postgre database

pls help thank you...
Jan 24 '07 #1
4 1728
ronverdonk
4,258 Recognized Expert Specialist
I think this can better be answered by PostgreSQL experts. So I will move it to the PostgreSQL forum.

Ronald :cool:
Jan 24 '07 #2
michaelb
534 Recognized Expert Contributor
In addition to the answer to your duplicate posting -
http://www.thescripts.com/forum/thread592201.html
- you can consider using a file system facilities (that is if you' running on a UNIX platform which has a support for per-user disk quota)

Provided that /dbdata is a quota-enabled partition you can try something like this:
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLESPACE dbspace LOCATION '/dbdata'; 
  2. CREATE DATABASE db_dbuser OWNER dbuser TABLESPACE dbspace;  
  3.  
See the Postgres manual, CREATE TABLESPACE and CREATE DATABASE for details.

I don't like this approach, because if you run out of disk space and cannot commit a transaction you may have to do some work to recover the database.
Jan 24 '07 #3
exoskeleton
104 New Member
ok sir thank you.. i will read the manual for this command.
Jan 25 '07 #4
exoskeleton
104 New Member
I think this can better be answered by PostgreSQL experts. So I will move it to the PostgreSQL forum.

Ronald :cool:
thank you sir for moving to the right forum sir ronverdonk
Jan 25 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

17
2005
by: Gareth Tuckwell | last post by:
Does anyone if there is a limit on the number of fields or the number of tables in an Access97 database? My code suddenly won't compile after I have added a few fields in one table and I wonder if I have exceeded something? If Yes, then does anyone know any workarounds? GT.
2
6045
by: steve | last post by:
I am setting up a huge database in mysql, and I get the above error in Linux. I believe it is related to the size of one of my tables, which is 4,294,966,772 bytes in size. Can someone help. How can I break that barrier. A google search did not turn up anything useful. -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to usenet standards
7
5138
by: johnm | last post by:
We have a new CRM application that uses a DB2 7.2 database. Our users noted that the CRM application would not allow them to attach and store any documents over 2 meg in size. When asked, the vendor claims that this behavior is a limit of the DB2 system. We asked the vendor how we might get around this issue since most of our user's documents are over the 2 meg limit. The vendor said that by removing logging from the blob fields the 2...
1
3623
by: Danny | last post by:
I have one person who uses an access database for his billing info, and now he is way up there, maybe 20 thousand records.. 1. is there a limit to the size of an access database? 2. this is off topic. this is an access database being used in vb6, is there vb code I could use in vb6 app that will let them compact the database automatically? thanks in advance
4
8896
by: bdotson | last post by:
Does anyone know the record limit for a single table in Access 97? I have a client who has over 800,000 records in one table. They are experiencing math problems and timeouts when running reports. Microsoft's KB didn't seem to have a good answer. I'm going to try to get them to convert to an Access or custom VB front end and SQL on the backend, but for now, I need a justification as to the Access 97 problem. Thanks!
1
6675
by: Jan | last post by:
Is there a 2GB size limit on Access2003/XP ? If so, is there an easy way to span across more than one MDB file?
1
9320
by: orenbt | last post by:
Hi, I am new to SQL express and try to solve the 4GB size limitation. Is there a possibility to create a new database file every time I get to the limit? How can I do that with C#? how can I create new database file every time it gets full? Can I be connected to two database files at the same time (the full db and the new db)?
3
6831
by: John Taylor | last post by:
Tried to find any reference to this on the Microsoft help pages but can't find any reference - maybe I'm just not smart enough to find it. However; I have been working on a membership database where I "hold" a photograph in a table. All is working as would expect so I won't bore you with the details - it works almost identically to the Northwind sample database "employee" table. My problem that I get an error when I have about 30...
5
7497
by: Chuck | last post by:
If the max size of an Access DB is about 2gb, and the DB is split, does each item have its own 2 gb limit or does the combined size of linked tables add to the size of the FE to get to the limit? Chuck --
5
2143
by: bobh | last post by:
HI, I understand AccessXP file size has a 2 gig limit but I trying to understand the following I have a tab delimited data file that is 1.3 gigs big and I try to import it into an empty AccessXP database and it starts to import then stops, I look at the database size and it shows 1.99 gigs. AccessXP blots to almost twice the size of the import file??? is that
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9404
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10164
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10007
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8833
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7379
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5277
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
2806
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.