From: | sharilalipv <sharilalipv(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Fwd: restoring table |
Date: | 2014-01-02 06:52:49 |
Message-ID: | CA+i1o4ZhN1=mS8D29EGDGc=PeprGFqeBzDUb8bvuWa--gy-+Og@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
--
Sharil
From | Date | Subject | |
---|---|---|---|
Next Message | Doom.zhou | 2014-01-02 07:06:10 | Re: Fwd: restoring table |
Previous Message | sharilalipv | 2014-01-02 06:50:36 | restoring table |