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 67A5C52905 for ; Tue, 16 Aug 2005 19:42:23 -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 24092-09 for ; Tue, 16 Aug 2005 22:42:20 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 955F052971 for ; Tue, 16 Aug 2005 19:42:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7GMg1vp007410; Tue, 16 Aug 2005 18:42:03 -0400 (EDT) To: "Buorn, Yoway" Cc: pgsql-admin@postgresql.org Subject: Re: Restore from pg_dumpall In-reply-to: <21A801CCBAC79545878E3C1137912E410112D029@CAMV02-MAIL01.ad.gd-ais.com> References: <21A801CCBAC79545878E3C1137912E410112D029@CAMV02-MAIL01.ad.gd-ais.com> Comments: In-reply-to "Buorn, Yoway" message dated "Tue, 16 Aug 2005 08:55:30 -0700" Date: Tue, 16 Aug 2005 18:42:01 -0400 Message-ID: <7409.1124232121@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/204 X-Sequence-Number: 18523 "Buorn, Yoway" writes: > No, I'm not trying to back-port a dump. I simply followed the > instructions in the section 2.3.4 of the gforge manual which tells me to > go into the db/ folder and apply the schema changes in order for all sql > files dated after the existing installation. So I started with > 20050312.sql and it gave me this parse error near "CASCADE". > You mention there's nothing wrong with this. Does this mean the message > is not really an error and I can safely ignore it? What that probably means is that you need a newer version of Postgres before trying to install gforge. It would seem that you have PG 7.2 or before. I don't know what gforge's minimum requirement for PG version is, but certainly 7.2 is pretty ancient. regards, tom lane