dhis2-users team mailing list archive

[Yusuph Kassim <yusuphk@xxxxxxxxx>]

helllo again,

it depend if you already have a backup of the other database that you want
to work with or you want a complete new one, let me write both

1. using the backup if you have one from somewhere.

all you have to do is open pgadmin3, on databases right click on it and
create new database, you can give this database any name that you line but
preferably it should have the prefix of dhis,

after that just right click on the dhis database that you've created and
restore the backup. (it will open a popup and you should browse to folder
where the backup is locate and restore it).

if you want a new database just follow the steps above until the point you
create the database. and restart your computer (but remember to edit the url
string in the database to point to this new database)

NB. if you want to reuse the dataelement and orgunits for the first
database, you can go to import/ export and choose metadata export and choose
the specific meta data you want to re-use in the other database and export
them, then you can use this file to import in the new database

hope thats help.

cheers

On Wed, Mar 16, 2011 at 11:15 AM, Stephen M. Gbanyan, Jr. <
sgbanyan@xxxxxxxxxx> wrote:

>
> Hi All,
>
> Thanks very much for the prompt feedback.  I did see the
> hibernate.properties you can switch databases. But during the installation
> I
> installed only one of those databases and I need to have the other in the
> system so I can be able to switch from the hibernate.properties.  Can I get
> help how to put in the other database?
>
> Thanks
>
> Stephen
>
>
> -----Original Message-----
> From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx]
> Sent: Wednesday, March 16, 2011 6:29 PMs
> To: Yusuph Kassim
> Cc: Stephen M. Gbanyan, Jr.; dhis2-users@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Dhis2-users] using the new installer
>
> In the context of the installer, this file should be located at ( I think)
>
> c:\program files\dhis2-2.1\conf\hibernate.properties
>
>
>
> Regards,
> Jason
>
>
> On Wed, Mar 16, 2011 at 7:26 PM, Yusuph Kassim <yusuphk@xxxxxxxxx> wrote:
> > hello Stephen,
> > You can do this through changing the database name in the connection URL
> on
> > the hibernet,properties file.
> > find hibernate.connection.url = jdbc:postgresql:dhis2
> > note: change dhis2 to the name of the database you want to use,
> > cheers
> >
> > On Wed, Mar 16, 2011 at 8:30 AM, Stephen M. Gbanyan, Jr.
> > <sgbanyan@xxxxxxxxxx> wrote:
> >>
> >> Hi All
> >>
> >>
> >>
> >> I have now managed to have my dhis working now. What I did was just to
> >> restart and it is now ok.  What I do not know know is how to switch my
> >> databases.  I have two databases and I want to go to the other database
> to
> >> work in.
> >>
> >>
> >>
> >> Thanks
> >>
> >>
> >>
> >> Stephen
> >>
> >>
> >>
> >> From: Stephen M. Gbanyan, Jr. [mailto:sgbanyan@xxxxxxxxxx]
> >> Sent: Wednesday, March 16, 2011 5:08 AM
> >> To: 'dhis2-users@xxxxxxxxxxxxxxxxxxx'
> >> Subject: using the new installer
> >>
> >>
> >>
> >> Hi All,
> >>
> >>
> >>
> >> I have just used the dhis2-2.1 live and it install on my machine without
> >> any error message.  I now have my database in but my problem now is when
> I
> >> click on services and click on data entry my org unit and datasets are
> all
> >> available but when I click on a dataset and choose a period it just keep
> >> reading and not opening to the form.  Also at the bottom of the screen
> it
> >> says Error on page.
> >>
> >>
> >>
> >> Secondly I have two databases and I want to switch between them how do I
> >> go about doing that.
> >>
> >>
> >>
> >> Thanks
> >>
> >>
> >>
> >> Stephen
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-users
> >> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >
> >
> >
> > --
> > Yusuph Kassim Kulindwa,
> > University of Dar Es Salaam,
> > Department of Computer Science,
> > System Developer/ Research Assistant.
> >
> > Cell: +255 713 535648
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-users
> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
> >
> >
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260974901293
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Yusuph Kassim Kulindwa,
University of Dar Es Salaam,
Department of Computer Science,
System Developer/ Research Assistant.

Cell: +255 713 535648