Skip to main content

Restoration of Openbravo Environment

All of us depend on backup most of the time. Thats one side-effect of innovative product development. Sometimes when our imagination unfolds in the form of thousands of ideas, the first thing that suffers is the application coz its new for it and the last thing is you coz u got to restore it..:) Sometimes we do development in one environment and recreate the environment elsewhere. I will present how I did it for Openbravo in ubuntu. Openbravo in ubuntu has two parts. One if the folder structure and the other of course is the database. I use postgres as database because of the simple reason that its free. So the first step is i need a backup or a dump of the database. If you have pgadmin installed this is a easier task. Just right click on your database, and choose backup. In the options that present before you, choose the plain option. This option is to create a backup in plain text format that you can see. You can almost sense whats there in that dump with the plain format backup.

                          Now if you don't use pgadmin then use the command
"pg_dump  -U postgres dbname > nameofbackupfile" for more doubts in this, visit this link
                         We have our database copy now. Next step is copy your current folder structure and transfer it to the destination machine. Next step is restoring the database. This command is really simple..:)
"psql -U postgres -d newdb_name -f path_of_backupfile". Note that you need to create an empty database before restoring into that..:) i forgot his once, so only added this. Next thing there is option restore in Pgadmin but sadly that does not work for plain type database dump that we took.
                          So we now have a database and folder structure. next step is modify the openbravo properties file and set the source directory and database name accordingly...(refer obwiki for these stuffs if u have doubts, or i ll put another blog about openberavo properties..:) ). So after modifying the properties file, just go ahead and do a complete build and you have the openbravo ready in your new environment...revert back with questions if you have any, in fact i am waiting for many...:)


Popular posts from this blog

My 10 years in Application Development

It's been around 10 years since I started programming. May be a bit more, if I have to include my first attempts at C programming in school. But it would be a grave insult to call remembering ten lines of code and just replicating it to put a star on the screen. I also did a course on Visual basic, but it was more gimmicks that Application development. But it was truly in the year 2007 when I started my Master in Computer Applications that I found a new flare for developing applications. 
I was very late to computers in general and even when I joined my Masters, computers were not really accessible to me. But when I joined my Masters where one is actually expected to hone the skills which they already have, but in case it was were I was learning the skills, initially it was very difficult. I was not sure what computers had for me nor I had a natural flair for programming. But the thing about computers that attracted me was the visual medium it gave. Initially it was just a door t…

Changing Timezone in Postgresql, Ubuntu

Timezone and locale are integral concepts that one should be aware of when implementing a System. For example. if you create a database in PostgreSql, it will use the default System settings for the database. Lets say you have a server in UK and your client is US. If the client tries to retrieve the current date or time, it is going to show the UK time and not the US one.
Today I encountered a different issue in our client place where the Ubuntu timezone and PostgreSql timezone were showing a incorrect values. Instead of Indian Standard Time (IST) it was showing Pacific Daylight Time(PDT). These are the steps that I followed to change the timezone to IST in PostgreSql and Ubuntu.
Changing timezone in Ubuntu:
sudo dpkg-reconfigure tzdataYou will be prompted to choose the continent and then the area. Provided screen shots where we configure the location.
Use TAB key to navigate to the OK button and then press Enter.

The changes will get reflected immediately. To check it you can open a n…

கிறுக்கனின் கிறுக்கல்கள் - அழுகையின் சிறப்பு

அழுகை என்பதை வெறுத்தவன் நான்... என்னை ஒரு நாள் பிரிந்திருக்க முடியாமல் , கைப்பேசியில் நீ சிந்திய உன் கண்ணீர் ஓசை என் காதில் கேட்கும் வரை...

பின்குறிப்பு: கிறுக்கனின் கிறுக்கல்கள் எங்கிருந்தோ தழுவப்பட்டது போல் தோன்றினால் கிறுக்கன் ( நான் உண்மையை ஏற்றுக்கொள்பவன்..:) ) பொறுப்பல்ல. கிறுக்கனின் கிறுக்கல்களில் வரும் கிறுக்கல்கள் யாவும் என் சிறய மூளையில் உதித்ததே ஆகும்.  Inspirations could have been drawn from somewhere else, but its the execution that counts....Isn't it ?