2011/8/29 Rural Hunter <ruralhunter@xxxxxxxxx>: > Hi all, > I'm a newbie here. I'm trying to test pgsql with my mysql data. If the > performance is good, I will migrate from mysql to pgsql. > I installed pgsql 9.1rc on my Ubuntu server. I'm trying to import a large > sql file dumped from mysql into pgsql with 'plsql -f'. The file is around > 30G with bulk insert commands in it. It rans several hours and then aborted > with an "out of memory" error. This is the tail of the log I got: > INSERT 0 280 > INSERT 0 248 > INSERT 0 210 > INSERT 0 199 > invalid command \n > out of memory I'd look at what's leading to the invalid command \n up there. I doubt the out of memory is more than a symptom from that. I.e. some part of your inserts are improperly formatted and the machine is then trying to insert a row with what it thinks is a column of several gigabytes. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin