On Tue, Mar 23, 2004, at 14:57 PST, David Davis wrote:
> Has anybody successfully downgraded a postgres database's data, say from 
> 7.4 to 7.3 or 7.3 to 7.2 etc?
> 
> I'm trying to get data from a 7.4.2 database, using pg_dump, into a 
> 7.3.4 database on another server (via psql).  It seems like the 7.4.x 
> sql syntax to create SEQUENCES seems have changed and, of course, fails 
> on restore.

My advice would be to check the manuals on the web site.  Last I looked
you could look at all past versions docs.  Find out what the difference
between the syntax is, and I bet a short sed script could work it out.

-- 
Sam Phillips <[EMAIL PROTECTED]>                http://www.dasbistro.com
San Francisco                                                 California
_______________________________________________
RLUG mailing list
[EMAIL PROTECTED]
http://www.rlug.org/mailman/listinfo/rlug

Reply via email to