AI Rumman wrote: > I modified the > shared_buffer=50 MB > and > maintenance_work_mem = 50 MB > > But still getting the same error. I hope you restarted the PostgreSQL server? If so, pg_restore might just need more RAM than that machine has to deal with that particular database. You might try a text dump, loaded by psql instead. -Kevin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general