Fwd: restoring table

Поиск
Список
Период
Сортировка
От sharilalipv
Тема Fwd: restoring table
Дата
Msg-id CA+i1o4ZhN1=mS8D29EGDGc=PeprGFqeBzDUb8bvuWa--gy-+Og@mail.gmail.com
обсуждение исходный текст
Ответы Re: Fwd: restoring table  ("Doom.zhou" <zzepaigh@gmail.com>)
Re: Fwd: restoring table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: 9.1 to 9.2 upgrade surprises
Следующее
От: "Doom.zhou"
Дата:
Сообщение: Re: Fwd: restoring table