Re: How to secure PostgreSQL Data for distribute?

Premsun,

>      I need to distribute my application that use PostgreSQL as database to
> my customer. But I still have some questions in my mind on database
> security. I understand that everybody  who get my application database will
> be have a full control permission on my database in case that PostgreSQL
> already installed on their computer and they are an administrator on
> PostgreSQL. So that mean data, structure and any ideas contain in database
> will does not secure on this point. Is my understanding correct?
>
>      What is the good way to make it all secure? Please advise.

I think you have a different definition of "security" from most of us.   There 
are techniques you could use that would prevent your customer from having 
easy direct access to the database on his machine -- but they would also 
prevent him from making backups or recovering from a computer problem.  
They'd also require a lot of work on your part.

Overall, if your goal is to prevent your customer from having control of their 
own data, I don't think an open-source database is the best choice for 
you.  ;-b

-- 
Josh Berkus
Aglio Database Solutions
San Francisco