From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | Daniel Phlander <phlander(at)friendnet(dot)org>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: db |
Date: | 2003-07-02 13:15:10 |
Message-ID: | Pine.LNX.4.33.0307020713220.19006-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Tue, 1 Jul 2003, Kris Jurka wrote:
>
>
> On Tue, 1 Jul 2003, Daniel Phlander wrote:
>
> >
> > Hello! I have a problem: I have installed PostgreSQL 7.3.3 and I have
> > also put in the db a ( /usr/local/pgsql/bin/pg_dumpall > backup.sql ),
> > which I made from a PostgreSQL 7.2.4. backup.sql; has uploaded with
> > no problem, but now in the applications on which I work I have to make
> > backup.sql from PgSQL 7.3.3 and to put into PgSQL 7.2.4., but I see
> > this is not working (I have errors). I want to know how can I put a
> > backup.sql made on a PgSQL 7.3.3 and to upload it into PgSQL 7.2.4. ?
> > I look forward to hear from you! Thanks. Daniel
>
> pg_dump only allows moving to an equal or greater version of postgresql,
> so you're kind of out of luck moving 7.3.3 -> 7.2.4
Note that standard operating procedure is to use the version of pg_dump
for the version of the database you're going to.
i.e. to dump a 7.3 db to 7.2, you need to use the pg_dump from 7.2.
This comes with the caveat that until version 7.4, no real effort was made
for pg_dumpall to handle different versions of your database, meaning
individual databases can be dumped like this, but not whole clusters.
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2003-07-02 13:37:02 | Re: Please help with binary file |
Previous Message | Fernando Nasser | 2003-07-02 12:58:53 | Re: Please help with binary file |