Hello

I use OpenERP which requires Postgresql.

I had a dedicated server with OpenVZ and OpenERP had its own VPS with 4GB RAM. It worked.

I then had to move it to a new server (also with OpenVZ) so I VZDUMPed the OpenERP VPS and copied it to the new server.

I'm running Postgresql 9.1.9

psql --version
psql (PostgreSQL) 9.1.9

The new OpenERP VPS was initially given 4GB RAM. I have now increased it to 6GB RAM. I'm still getting out of memory errors.

I do not have any experience with Postgresql database. I only have MySQL database experience.

Can someone tell me how to troubleshoot this error.

Any help would be appreciated.
_________________________________________________________
2014-01-23 11:25:01 EST LOG: autovacuum launcher started
2014-01-23 11:25:01 EST LOG: database system is ready to accept connections
2014-01-24 13:37:15 EST LOG: could not fork new process for connection: Cannot allocate memory
2014-01-24 13:37:15 EST LOG: could not fork new process for connection: Cannot allocate memory
2014-01-24 13:37:15 EST LOG: could not fork new process for connection: Cannot allocate memory
2014-01-24 13:37:15 EST LOG: could not fork new process for connection: Cannot allocate memory
2014-01-24 13:37:16 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:17 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:18 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:19 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:20 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:21 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:22 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:23 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:23 EST LOG: out of file descriptors: Too many open files in system; release and retry
2014-01-24 13:37:23 EST STATEMENT: SELECT l.account_id as id, COALESCE(SUM(l.credit), 0) as credit, COALESCE(SUM(l.debit),0) - COALESCE(SUM(l.credit), 0) as balance, (SELECT CASE WHEN currency_id IS NULL THEN 0 ELSE COALESCE(SUM(l.amount_currency), 0) END FROM account_account WHERE id IN (l.account_id)) as foreign_balance, COALESCE(SUM(l.debit), 0) as debit FROM account_move_line l WHERE l.account_id IN (716) AND l.state <> 'draft' AND l.period_id IN (SELECT id FROM account_period WHERE fiscalyear_id IN (6,7,8)) GROUP BY l.account_id
2014-01-24 13:37:25 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:26 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:27 EST LOG: could not fork autovacuum worker process: Cannot allocate memory
2014-01-24 13:37:28 EST LOG: could not fork autovacuum worker process: Cannot allocate memory