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 3852D5290D for ; Fri, 24 Jun 2005 18:27:07 -0300 (ADT) 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 34689-07 for ; Fri, 24 Jun 2005 21:26:58 +0000 (GMT) Received: from web32815.mail.mud.yahoo.com (web32815.mail.mud.yahoo.com [68.142.206.45]) by svr1.postgresql.org (Postfix) with SMTP id 85AA7528AD for ; Fri, 24 Jun 2005 18:26:56 -0300 (ADT) Received: (qmail 63442 invoked by uid 60001); 24 Jun 2005 21:26:58 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=g2RXlcjAfrSizTE4vjOlUdbLxOkqN+gxvyeJ63IUL6PrXgTpZUqC5N6WZdmtmQe7i1tv9oB7bwrjGyw49Puv0jNMNvuItAH4GAU+6itV6Jqg4GxPwjv76+fLcZ/M6ufrxDiexOo8/CmOvlUBawul6iAqHlGNXQ8wTAYCKsD3UKE= ; Message-ID: <20050624212658.63440.qmail@web32815.mail.mud.yahoo.com> Received: from [69.226.167.220] by web32815.mail.mud.yahoo.com via HTTP; Fri, 24 Jun 2005 14:26:58 PDT Date: Fri, 24 Jun 2005 14:26:58 -0700 (PDT) From: Puddle Subject: pg_dump and table backup To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.455 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_YAHOO_RCVD X-Spam-Level: ** X-Archive-Number: 200506/208 X-Sequence-Number: 17963 I've been reading about how to backup individual tables with pg_dump. I noticed the -t, but can you backup more then one table at a time with that flag? I have a devel box that gets updated tables pushed to the production. So, we're looking to drop x amount of tables and import that data to the production box. Would something like : pg_dump -O -f $DB_BACKUP_PATH/$BKUP_DAY/PostgreSQL-$BKUP_DATE.sql --clean -D \ -t table-1 \ -t table-2 \ -U dbuser db It doesn't seem to like the -t flag. Any help here would be appreciated. Thanks! -William __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com