pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problem with pg_restore
6+ messages / 6 participants
[nested] [flat]

* problem with pg_restore
@ 2002-01-29 21:58  Srinivasa Rao Chava <s.chava@wcom.com>
  0 siblings, 1 reply; 6+ messages in thread

From: s.chava@wcom.com @ 2002-01-29 21:58 UTC (permalink / raw)
  To: pgsql-admin

Hi,
I have a problem with pg_restore. I have a database,  named DEPG. I
have taken backup with pg_dump and -Ft options. I created  another
database, named test. After this , I used the pg_restore command  to
restore the DEPG backup into test database. Then it is restoring upto
some point and failing giving the following error.

Below is the complete output:

$ pg_restore -v -Ft -d test 15:05-postgresql_database-DEPG-backup

Connecting to database for restore
Connecting to test as pgsql
Creating TABLE pgadmin_desc
Connecting to test as develop
Creating TABLE announce
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'announce_pkey' for table 'announce'
Creating ACL announce
Connecting to test as pgsql
Creating TABLE pgadmin_param
Creating ACL pgadmin_param
Creating TABLE pgadmin_rev_log
Creating ACL pgadmin_rev_log
Creating TABLE pgadmin_seq_cache
Creating ACL pgadmin_seq_cache
Creating TABLE pgadmin_table_cache
Creating ACL pgadmin_table_cache
Creating FUNCTION "pgadmin_get_desc" (oid)
Creating FUNCTION "pgadmin_get_pgdesc" (oid)
Creating FUNCTION "pgadmin_get_col_def" (oid,integer)
Creating FUNCTION "pgadmin_get_handler" (oid)
Creating FUNCTION "pgadmin_get_type" (oid)
Creating FUNCTION "pgadmin_get_rows" (oid)
Creating FUNCTION "pgadmin_get_sequence" (oid)
Creating ACL pgadmin_databases

Archiver(db): Could not execute query. Code = 7. Explanation from
backend: 'ERROR:  Relation 'pgadmin_databases' does not exist
'.


Actually, there is pgadmin_databases view in DEPG database and I took
the backup from it. Why it is giving this error and terminating the
restore operation, when i use pg_restore.

Any help is appreciated and thanks in advance.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: problem with pg_restore
@ 2002-01-29 22:36  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Srinivasa Rao Chava <s.chava@wcom.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2002-01-29 22:36 UTC (permalink / raw)
  To: s.chava@wcom.com; +Cc: pgsql-admin

s.chava@wcom.com (Srinivasa Rao Chava) writes:
> I have a problem with pg_restore. I have a database,  named DEPG. I
> have taken backup with pg_dump and -Ft options. I created  another
> database, named test. After this , I used the pg_restore command  to
> restore the DEPG backup into test database. Then it is restoring upto
> some point and failing giving the following error.

You need to update to 7.1.3; earlier 7.1.* pg_dumps have a problem with
the ordering of commands for GRANTs on views.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Problem with pg_restore
@ 2007-03-02 10:52  isk <isk@rdw.ru>
  0 siblings, 3 replies; 6+ messages in thread

From: isk @ 2007-03-02 10:52 UTC (permalink / raw)
  To: pgsql-admin

PostgreSQL version 8.1.4
Linux version 2.6.19-gentoo-r5 (gcc version 4.1.1 (Gentoo 4.1.1))

I make backup with commang:
pg_dump  -U postgres -h /tmp -Ft -b -C mydb > file.tar

When I want to restore from backup, i give error.

pg_restore -U postgres -d template1 -v -C < file.tar

error report:
    Command was: COPY sl_log_2 (log_origin, log_xid, log_tableid, log_actionseq, log_cmdtype, log_cmddata) FROM stdin;
pg_restore: [tar archiver] corrupt tar header found in 119 (expected 100, computed 40443) file position 4296575488
pg_restore: *** aborted because of error




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Problem with pg_restore
@ 2007-03-02 11:38  Michael Monnerie <michael.monnerie@it-management.at>
  parent: isk <isk@rdw.ru>
  2 siblings, 0 replies; 6+ messages in thread

From: Michael Monnerie @ 2007-03-02 11:38 UTC (permalink / raw)
  To: pgsql-admin

On Freitag, 2. März 2007 11:52 isk wrote:
> corrupt tar header found

I'd say your hardware is broken, either memory problem or disk problem.

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:        "curl -s http://zmi.at/zmi4.asc | gpg --import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F 1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID: 1C6FE6B0

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Problem with pg_restore
@ 2007-03-02 11:55  Vishal Arora <aroravishal22@hotmail.com>
  parent: isk <isk@rdw.ru>
  2 siblings, 0 replies; 6+ messages in thread

From: Vishal Arora @ 2007-03-02 11:55 UTC (permalink / raw)
  To: isk@rdw.ru; pgsql-admin


pg_restore -U postgres -d template0 -v -C < file.tar

try using this command
pg_dump  -U postgres -h /tmp -o -Ft -b -C mydb > file.tar

>From: isk <isk@rdw.ru>
>Reply-To: isk <isk@rdw.ru>
>To: pgsql-admin@postgresql.org
>Subject: [ADMIN] Problem with pg_restore
>Date: Fri, 2 Mar 2007 13:52:36 +0300
>
>PostgreSQL version 8.1.4
>Linux version 2.6.19-gentoo-r5 (gcc version 4.1.1 (Gentoo 4.1.1))
>
>I make backup with commang:
>pg_dump  -U postgres -h /tmp -Ft -b -C mydb > file.tar
>
>When I want to restore from backup, i give error.
>
>pg_restore -U postgres -d template1 -v -C < file.tar
>
>error report:
>     Command was: COPY sl_log_2 (log_origin, log_xid, log_tableid, 
>log_actionseq, log_cmdtype, log_cmddata) FROM stdin;
>pg_restore: [tar archiver] corrupt tar header found in 119 (expected 100, 
>computed 40443) file position 4296575488
>pg_restore: *** aborted because of error
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

_________________________________________________________________
The average US Credit Score is 675. The cost to see yours: $0 by Experian. 
http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVERAGE




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Problem with pg_restore
@ 2007-03-05 09:57  Ares <abaidulin@rambler.ru>
  parent: isk <isk@rdw.ru>
  2 siblings, 0 replies; 6+ messages in thread

From: Ares @ 2007-03-05 09:57 UTC (permalink / raw)
  To: pgsql-admin

sl_log_2 !!!??? Do you want to restore slony logs? For why!?


> error report:
>     Command was: COPY sl_log_2 (log_origin, log_xid, log_tableid,
log_actionseq, log_cmdtype,
> log_cmddata) FROM stdin;
> pg_restore: [tar archiver] corrupt tar header found in 119 (expected 100,
computed 40443) file position 4296575488
> pg_restore: *** aborted because of error
> 





^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2007-03-05 09:57 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-29 21:58 problem with pg_restore Srinivasa Rao Chava <s.chava@wcom.com>
2002-01-29 22:36 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-03-02 10:52 Problem with pg_restore isk <isk@rdw.ru>
2007-03-02 11:38 ` Re: Problem with pg_restore Michael Monnerie <michael.monnerie@it-management.at>
2007-03-02 11:55 ` Re: Problem with pg_restore Vishal Arora <aroravishal22@hotmail.com>
2007-03-05 09:57 ` Re: Problem with pg_restore Ares <abaidulin@rambler.ru>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox