current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I need to import my psql dump into my fresh psql database. When I execute the following command, I get errors.

psql -U user new_database < filename.sql

Error I got:

ERROR: out of memory DETAIL: Cannot enlarge string buffer containing 0 bytes by 1208975751 more bytes.

How do I fix this. Also, is there any method to log the import process? My database size is nearly 1.5 GB.

Thanks.

share|improve this question
    
You might want to first try an up-to-date version. 8.4 is no longer maintained. You didn't mention your exact 8.4 version, but did you check the latest patch version for 8.4? –  a_horse_with_no_name Nov 20 '14 at 11:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.