X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4ED308B9E69 for ; Sat, 5 Feb 2005 04:29:16 +0000 (GMT) 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 76494-07 for ; Sat, 5 Feb 2005 04:29:09 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id CEAC98BA074 for ; Sat, 5 Feb 2005 04:29:09 +0000 (GMT) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 4CFE912B13D for ; Sat, 5 Feb 2005 00:29:09 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76270-06 for ; Sat, 5 Feb 2005 04:28:55 +0000 (GMT) Received: from ganymede.hub.org (blk-224-186-245.eastlink.ca [24.224.186.245]) by hub.org (Postfix) with ESMTP id 2D23D12B00E for ; Sat, 5 Feb 2005 00:28:55 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id E6C393DA93; Sat, 5 Feb 2005 00:28:53 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id E2B7F3D903 for ; Sat, 5 Feb 2005 00:28:53 -0400 (AST) X-Return-Path: X-Received: from localhost ([unix socket]) by ganymede.hub.org (Cyrus v2.2.10) with LMTPA; Fri, 04 Feb 2005 17:21:30 -0400 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 2251F3C391 for ; Fri, 4 Feb 2005 17:20:37 -0400 (AST) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5) for scrappy@localhost (single-drop); Fri, 04 Feb 2005 17:20:37 -0400 (AST) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.10) with LMTPA; Fri, 04 Feb 2005 21:19:58 +0000 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2FF4B8B9F5E for ; Fri, 4 Feb 2005 21:19:58 +0000 (GMT) X-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 47397-09 for ; Fri, 4 Feb 2005 21:19:47 +0000 (GMT) X-Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id E4F818B9F24 for ; Fri, 4 Feb 2005 21:19:46 +0000 (GMT) thread-index: AcUK/21f9K24fSnlSt6Gm66aAo8m6Q== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Content-Class: urn:content-classes:message Importance: normal X-Received: from [10.4.13.50] ([66.194.26.150]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 4 Feb 2005 16:21:00 -0500 Message-ID: <4203E71C.8060401@sermonaudio.com> Date: Fri, 04 Feb 2005 16:20:28 -0500 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 1.0 (X11/20041227) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Subject: pg_restore question X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 04 Feb 2005 21:21:01.0250 (UTC) FILETIME=[6D0E0220:01C50AFF] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-DCC: : X-Spam-Pyzor: ReSent-Date: Sat, 5 Feb 2005 00:28:37 -0400 (AST) Resent-From: "Marc G. Fournier" Resent-To: pgsql-admin@postgresql.org ReSent-Subject: pg_restore question ReSent-Message-ID: <20050205002837.B62562@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.946 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/59 X-Sequence-Number: 16227 I am having an issue with postgres 7.3.4 and pg_restore. I have a pg_dump archive that I made with the following command: pg_dump -p -h -Fc -Z9 -f db.dmp -v However, when I try to do a pg_restore for a specific table, it is not restoring the permission to the table. Is there a way to have pg_restore restore a specific table w/ the permissions? Here was my restore command: pg_restore -Fc -v -p -h -d -t db.dmp Thanks for any help, Chris