From: Colin R. <du...@ha...> - 2005-10-17 09:26:47
|
Greetings all, I just installed 2.6.1 (via setup.pl) and got it up and running. It's on a FreeBSD server in the house, which also handles mail etc, so the box is visible to the world. --------------------------- Side note: A most useful general tip BTW, is to *additionally* password protect the entire sql-ledger directory using .htaccess. More information on .htaccess protection, and how to implement it, can be found here: http://www.freewebmasterhelp.com/tutorials/htaccess/1 And additional reading here: http://www.apacheweek.com/features/userauth --------------------------- OK my question concerns "datasets". In my scenario I intend to create a valid company db *and* a test company. The purpose of the test company is to create a valid environment to test stuff without risking actual company data. (I assume "dataset" in our context refers to a db populated with necessary tables and skeleton data based on preferences) My problem is that I cannot see how to easily create additional datasets. Should I: 1) create a db first in postgresql admin (webmin in this case) and then go ahead and attempt to create a dataset? I ask this because I have one (fairly obvious from the FAQ) user 'sql-ledger'... Or should I: 2) create another db_user for the second dataset and *THEN* "Create Dataset" in admin.pl? The README is sort of ambiguous on this point. Sorry for the exceptionally basic nature of the questions, and TIA for any advice and suggestions from the gurus. Regards, -Colin |