Hi
i am restoring a database of 1.8GB using the command “psql -U$USERNAME -d$DB_NAME -f $FILE_TO_RESTORE”, however, i get “out of memory” error.
Which PSQL variable do i need to look at?
Lungo
Dear, can you share more information displayed in the console?
···
2014-02-10 2:19 GMT+07:00 Juma Lungo jlungo@yahoo.com:
Hi
i am restoring a database of 1.8GB using the command “psql -U$USERNAME -d$DB_NAME -f $FILE_TO_RESTORE”, however, i get “out of memory” error.
Which PSQL variable do i need to look at?
Lungo
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
–
Thai Chuong
HCMUT - Computer science and engineering Faculty
Website: http://thuytruc.net
YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134
Thanks Thai
Problem solved. It was due to a corrupted dump file. I created another dump which solved the problem.
Lungo
Dear, can you share more information displayed in the console?
···
On Tuesday, February 11, 2014 9:55 AM, Thái Chương thaichuong159@gmail.com wrote:
2014-02-10 2:19 GMT+07:00 Juma Lungo jlungo@yahoo.com:
Hi
i am restoring a database of 1.8GB using the command “psql -U$USERNAME -d$DB_NAME -f $FILE_TO_RESTORE”, however, i get “out of memory” error.
Which PSQL variable do i need to look at?
Lungo
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
–
Thai Chuong
HCMUT - Computer science and engineering Faculty
Website: http://thuytruc.net
YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134