Re: Restore from pg_dumpall

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: "Buorn, Yoway" <Yoway(dot)Buorn(at)gd-ais(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restore from pg_dumpall
Date: 2005-08-16 16:29:24
Message-ID: 20050816162924.GD32695@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Aug 16, 2005 at 08:55:30AM -0700, Buorn, Yoway wrote:
> 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?

Not at all. What server version are you using? You can find out by
issuing

SELECT version();

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
One man's impedance mismatch is another man's layer of abstraction.
(Lincoln Yeoh)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2005-08-16 17:36:19 Re: Any way to see what queries are currently running?
Previous Message Amrit Angsusingh 2005-08-16 16:03:00 DBmirror from 64 bit to 32 bit