best practice for updating postgres database schema

Posted on 2009-12-20
Medium Priority
Last Modified: 2012-05-08
Hello experts,
I am using postgres sql database in my application ( the database is distributed as a part of the app ), and I am looking for the best way to create update scripts for software updates.
Is there some kind of tool  to creates diff's between existing schema's so I can create a script that updates the previous schema to the new one ?

Question by:Iys

Author Comment

ID: 26094177
I found this tool:
But it doesn't support roles and privileges.
Does anyone have any experience with it ?
Is there a better way ?
LVL 36

Accepted Solution

Loganathan Natarajan earned 2000 total points
ID: 26094725

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question