X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D79918B9F14 for ; Thu, 3 Feb 2005 19:05:31 +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 73433-09 for ; Thu, 3 Feb 2005 19:05:27 +0000 (GMT) Received: from lothos.nuvio.com (unknown [63.77.68.101]) by svr1.postgresql.org (Postfix) with ESMTP id 0C8148B9B72 for ; Thu, 3 Feb 2005 19:05:27 +0000 (GMT) Received: from [63.77.68.30] ([63.77.68.30]) by lothos.nuvio.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 3 Feb 2005 13:07:23 -0600 Mime-Version: 1.0 (Apple Message framework v619) In-Reply-To: <42024286.9000007@archonet.com> References: <74EFBC01-7557-11D9-AC7D-000D932ED682@nuvio.com> <6725.1107379479@sss.pgh.pa.us> <21AFCC70-75EE-11D9-AC7D-000D932ED682@nuvio.com> <42024286.9000007@archonet.com> Content-Type: multipart/alternative; boundary=Apple-Mail-14-301280303 Message-Id: <7FE55B6D-7616-11D9-AC7D-000D932ED682@nuvio.com> From: Bradley Miller Subject: Re: pg_restore problem Date: Thu, 3 Feb 2005 13:04:59 -0600 To: Postgres List X-Mailer: Apple Mail (2.619) X-OriginalArrivalTime: 03 Feb 2005 19:07:23.0281 (UTC) FILETIME=[978F4810:01C50A23] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.098 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/73 X-Sequence-Number: 20184 --Apple-Mail-14-301280303 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Interestingly, I made a new database on my test server and then was able to do a pg_dump from my mac box to the test server and I think it got just about everything . . . I've got some constraint issues and other oddities happening, but at least my functions came in fine. I used the pipe command to pipe it directly to the server rather than using pg_restore. Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com bmiller@nuvio.com --Apple-Mail-14-301280303 Content-Transfer-Encoding: 7bit Content-Type: text/enriched; charset=US-ASCII Interestingly, I made a new database on my test server and then was able to do a pg_dump from my mac box to the test server and I think it got just about everything . . . I've got some constraint issues and other oddities happening, but at least my functions came in fine. I used the pipe command to pipe it directly to the server rather than using pg_restore. Bradley Miller Arial1313,0000,FFFFNUVIO CORPORATIONArial Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 0000,0000,FFFFhttp://www.nuvio.com 0000,0000,FFFFbmiller@nuvio.com --Apple-Mail-14-301280303--