X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5DCFBDB202 for ; Thu, 10 Nov 2005 16:28:32 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77342-09 for ; Thu, 10 Nov 2005 20:28:29 +0000 (GMT) X-Greylist: delayed 03:01:42.791125 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 59FE0DB1D0 for ; Thu, 10 Nov 2005 16:28:27 -0400 (AST) Received: from cougar.DIT.UMontreal.CA (chene.DIT.UMontreal.CA [132.204.246.20]) by svr2.postgresql.org (Postfix) with ESMTP id F1800F0DA2 for ; Thu, 10 Nov 2005 17:26:45 +0000 (GMT) Received: from chene.dit.umontreal.ca(132.204.246.20) by cougar.DIT.UMontreal.CA via csmap id 2ab35c24_520f_11da_987f_0002b39fa8dc_29035; Thu, 10 Nov 2005 12:26:46 -0500 (EST) Received: from cougar.DIT.UMontreal.CA (gw-mail.LEXUM.UMontreal.CA [132.204.136.52]) by chene.DIT.UMontreal.CA (8.13.1/8.13.1) with ESMTP id jAAHQgsx023517 for ; Thu, 10 Nov 2005 12:26:42 -0500 Received: from gw-mail.lexum.umontreal.ca(132.204.136.52) by cougar.DIT.UMontreal.CA via csmap id 28c98aa0_520f_11da_88dd_0002b39fa8dc_29007; Thu, 10 Nov 2005 12:26:42 -0500 (EST) Received: from [192.168.4.171] ([::ffff:192.168.4.171]) (AUTH: PLAIN mederyf, SSL: TLSv1/SSLv3,256bits,AES256-SHA) by mail.lexum.umontreal.ca with esmtp; Thu, 10 Nov 2005 12:20:31 -0500 id 0000008B.4373815F.00005796 Message-ID: <437382D2.7050508@lexum.umontreal.ca> Date: Thu, 10 Nov 2005 12:26:42 -0500 From: FM User-Agent: Mozilla Thunderbird 1.0.7-1.4.1 (X11/20050929) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mailing List Postgres-Admin Subject: backup restore of DB + LO X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-NAI-Spam-Score: 0.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.025 required=5 tests=[AWL=0.025] X-Spam-Score: 0.025 X-Spam-Level: X-Archive-Number: 200511/127 X-Sequence-Number: 19500 Hello everybody, I'm trying backup restore of DB with LO. I backuped using as superuser : pg_dump -d -o -F t -b -u database --file=database.tar Because the superuser is not the DB owner, I create the DB on another server (same os ans same version of PGSQL which is 7.4.8 ) : CREATE DATABASE database with owner database_owner encoding='utf8'; Now, I'm trying to restore it to this second server using : pg_restore -U dbadmin -O -x -v -o -d database database.tar But I received : (...) pg_restore: restoring large object OID 2798405 pg_restore: restored 64069 large objects pg_restore: creating COMMENT SCHEMA public pg_restore: creating TABLE jpox_tables pg_restore: restoring data for table "jpox_tables" pg_restore: [tar archiver] could not find header for file 99.dat in tar archive What is the good way to backup/restore db with LO ? Thanks