I believe you don`t need to recompile, just export PGDATA=/home/me/pgdata pg_initdb pg_ctl start and ready to go.
Laci
Rudi Starcevic wrote:
Hi Wim,
It is possible to compile PostgreSQL so that it can keep each users database in their home dir. ( or another dir. of your choice. )
Then you can put a quota on the user's home dir.
To do this the only way I know is to compile from source.
It was about 2 years ago I did this last so I've forgetten the compile flags which you need
to pass in to 'configure' or 'make'.
You'll need to search the online installation docs or perhaps someone on this list can point
out the required C flags.
I found this method works very well.
For Mysql we had to write scripts which regularly checked quota's and disk size which was
no where need as elegent at PostgreSQL.
Hope this helps Cheers Rudi.
Wim Bertels wrote:
Ola,
is it possible to limit the database size,
ie like for example i create a database and then limit somehow the maximum database size.
scripts for arranging this?
tnx,
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
