Database Design Question
От
Carlos Mennens
Тема
Database Design Question
Дата
Msg-id
AANLkTimMEqnjuDUaRcGApS0C8OM83M8i68qssAJYRUfi@mail.gmail.com
Список
Дерево обсуждения
Database Design Question Carlos Mennens <carlos.mennens@gmail.com>
Re: Database Design Question John R Pierce <pierce@hogranch.com>
Re: Database Design Question "David Johnston" <polobo@yahoo.com>
Re: Database Design Question "Joshua D. Drake" <jd@commandprompt.com>
Re: Database Design Question John R Pierce <pierce@hogranch.com>
Re: Database Design Question Martijn van Oosterhout <kleptog@svana.org>
Re: Database Design Question Gary Chambers <gwchamb@gwcmail.com>
Re: Database Design Question Sim Zacks <sim@compulab.co.il>
Re: Database Design Question Carlos Mennens <carlos.mennens@gmail.com>
I was sitting down thinking the other day about when is it good to generate a new database or just use an existing one. For example, lets say my company name is called 'databasedummy.org' and I have a database called 'dbdummy'. Now I need PostgreSQL to manage several applications for my company: - webmail - software - mediawiki - phpbb forum Now what I've been doing is just creating multiple tables in the 'dbdummy' database but each table is owned by different users depending on their role. Is this bad? Should I be creating new databases for each application above rather than one single company database? Just trying to understand good DBA design practice. This is obviously a very general question but any feedback on what good or bad issues would come from me dumping all my tables for applications in one database or spread out across multiple databases on PostgreSQL. Thank you!
В списке pgsql-general по дате отправления
От: Chris Browne
Дата:
От: John R Pierce
Дата: