Re: Fwd: restoring table

["Doom.zhou" <zzepaigh@xxxxxxxxx>]

your server resource & your configure file ?

On Thu, Jan 2, 2014 at 2:52 PM, sharilalipv <sharilalipv@xxxxxxxxx> wrote:

Dear Team,

Postgresql Version:8.4

I could not  restore a table (4.1GB) in postgresql database server.

This is  the command I  used to  take table dump,

pg_dump   databasename  -t tablename  --format plain --data-only > ~/backup.sql

Restore command

 psql   -U  username  -d databasename -f  backup.sql

I  am  getting  below error,

2014-01-01 17:43:53 IST LOG:  autovacuum launcher started
2014-01-01 18:09:41 IST ERROR:  canceling autovacuum task
2014-01-01 18:09:41 IST CONTEXT:  automatic vacuum of table "tablename"
2014-01-01 18:12:31 IST LOG:  server process (PID 60667) was terminated by signal 9: Killed
2014-01-01 18:12:31 IST LOG:  terminating any other active server processes
2014-01-01 18:12:31 IST WARNING:  terminating connection because of crash of another server process
2014-01-01 18:12:31 IST DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2014-01-01 18:12:31 IST HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2014-01-01 18:12:31 IST LOG:  all server processes terminated; reinitializing
2014-01-01 18:12:32 IST LOG:  database system was interrupted; last known up at 2014-01-01 18:12:04 IST
2014-01-01 18:12:32 IST LOG:  database system was not properly shut down; automatic recovery in progress
2014-01-01 18:12:32 IST LOG:  redo starts at 5/2800EE48
2014-01-01 18:12:34 IST LOG:  unexpected pageaddr 5/13240000 in log file 5, segment 53, offset 2359296
2014-01-01 18:12:34 IST LOG:  redo done at 5/3523FFA8
2014-01-01 18:13:01 IST LOG:  database system is ready to accept connections
2014-01-01 18:13:01 IST LOG:  autovacuum launcher started

Sharil

--
Sharil