restoring table

From: sharilalipv <sharil(at)posibolt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: restoring table
Date: 2014-01-02 06:50:36
Message-ID: CA+i1o4ZDnbXmqvGnWbWByY24=t6jT1DhAf9XeOyEQT3jsjip1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sharilalipv 2014-01-02 06:52:49 Fwd: restoring table
Previous Message David Johnston 2014-01-01 16:34:43 Re: 9.1 to 9.2 upgrade surprises