connect to dhis2 live db

Support - Assistance technique
1

How do i achieve connection to dhis2 live database using pgadmin postgreSQL

thanks

···

developer_lusaka_systems

2

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@gmail.com wrote:

How do i achieve connection to dhis2 live database using pgadmin postgreSQL

–
developer_lusaka_systems

thanks

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

3

For Dhis live, the dhis.conf file is in the conf folder, and you don’t need to set up DHIS_HOME

···

On Jan 22, 2018 11:43, “Stian Sandvold” stian@dhis2.org wrote:

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!

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Sun, Jan 21, 2018 at 10:38 AM, moses mwale isoftcom.ic@gmail.com wrote:

How do i achieve connection to dhis2 live database using pgadmin postgreSQL

–
developer_lusaka_systems

thanks

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

4

Thank you very much. let me have a try.

···

On Tue, Jan 23, 2018 at 12:52 AM, Knut Staring knutst@gmail.com wrote:

For Dhis live, the dhis.conf file is in the conf folder, and you don’t need to set up DHIS_HOME

–

On Jan 22, 2018 11:43, “Stian Sandvold” stian@dhis2.org wrote:

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!

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Sun, Jan 21, 2018 at 10:38 AM, moses mwale isoftcom.ic@gmail.com wrote:

How do i achieve connection to dhis2 live database using pgadmin postgreSQL

–
developer_lusaka_systems

thanks

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

developer_lusaka_systems