← Back to team overview

dhis2-devs team mailing list archive

Re: connect to dhis2 live db

 

Hi Moses Mwale.

If you want to access your database using PgAdmin, you need to connect to
your database. To do this, you can choose "Create -> Server". In the
version I am using of PgAdmin, this option is available by right-clicking
the "Prosgres" item in the menu. This might be different for the different
versions of PgAdmin.

If you want to connect DHIS2 to your database, you need to configure that
in the dhis.conf file, located in your DHIS2_HOME folder. For more
information about how to set up this, you should look at the implementation
docs:
https://docs.dhis2.org/master/en/implementer/html/dhis2_implementation_guide_full.html

In either case, you need to know the following information:
* Database hostname/address (If you have the database on the same server as
your dhis2 instance, you can use "localhost")
* Database port (The default is 5432)
* Database name
* Username (User must have access to the database you want to use)
* Password

Hope this helps!

On Sun, Jan 21, 2018 at 10:38 AM, moses mwale <isoftcom.ic@xxxxxxxxx> wrote:

> How do i achieve connection to dhis2 live database using pgadmin postgreSQL
>
> thanks
>
> --
> developer_lusaka_systems
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Stian Sandvold
Software developer, DHIS2
University of Oslo
http://www.dhis2.org

Follow ups

References