importing sql file in postgresql database

hi,

I want to import sql file into postgresql database that I want to use in dhis2 2.14 live in local, but I have tried many ways I failed to import it in postgresql.
Could someone help me on this issue?

best regards,

Franck

Hi @Hakizimana

firstly, we must create a blank database in pgadmin3. Then type the following command in the psql command prompt:

psql-d NAME_DATABASE-U-f NAME_USER PATH_FILE_SQL

···

2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck francescohaki@gmail.com:

hi,

I want to import sql file into postgresql database that I want to use in dhis2 2.14 live in local, but I have tried many ways I failed to import it in postgresql.

Could someone help me on this issue?

best regards,

Franck


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

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

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

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


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

In the attached excerpt from my command prompt. You have to reassure you that you have configured the postgresql environment variable. for the psql commands can be recognized in your command prompt.

image

···

2014-03-04 9:03 GMT+01:00 riddy ndoma riddyndoma@gmail.com:

Hi @Hakizimana

firstly, we must create a blank database in pgadmin3. Then type the following command in the psql command prompt:

psql-d NAME_DATABASE-U-f NAME_USER PATH_FILE_SQL


Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)

2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck francescohaki@gmail.com:

hi,

I want to import sql file into postgresql database that I want to use in dhis2 2.14 live in local, but I have tried many ways I failed to import it in postgresql.

Could someone help me on this issue?

best regards,

Franck


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

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

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

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

Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/


Vous servir est mon désire (Serving you is my desire)

Hi @Hakizimana

firstly, we must create a blank database in pgadmin3. Then type the following command in the psql command prompt:

psql-d NAME_DATABASE-U-f NAME_USER PATH_FILE_SQL

···

2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck francescohaki@gmail.com:

hi,

I want to import sql file into postgresql database that I want to use in dhis2 2.14 live in local, but I have tried many ways I failed to import it in postgresql.

Could someone help me on this issue?

best regards,

Franck


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

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

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

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

Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/


Vous servir est mon désire (Serving you is my desire)

Hello, could you please clarify how did you import thing and what is the error you face?

How did you have you sql backup?

Normally we can import as previous reply

···

2014-03-04 8:58 GMT+01:00 HAKIZIMANA Franck francescohaki@gmail.com:

hi,

I want to import sql file into postgresql database that I want to use in dhis2 2.14 live in local, but I have tried many ways I failed to import it in postgresql.

Could someone help me on this issue?

best regards,

Franck


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

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

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

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

Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma

Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/


Vous servir est mon désire (Serving you is my desire)