From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Daniel Phlander <phlander(at)friendnet(dot)org>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: db |
Date: | 2003-07-02 13:48:19 |
Message-ID: | Pine.LNX.4.33.0307020945140.3542-100000@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Wed, 2 Jul 2003, scott.marlowe wrote:
> 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.
Clearly not
./pg72/bin/pg_dump template1
pg_dump: server version: PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled
by GCC gcc (GCC) 3.3 (Debian); pg_dump version: 7.2.3
pg_dump: aborting because of version mismatch (Use the -i option to proceed
anyway.)
./pg72/bin/pg_dump -i template1
pg_dump: server version: PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled
by GCC gcc (GCC) 3.3 (Debian); pg_dump version: 7.2.3
pg_dump: proceeding despite version mismatch
pg_dump: query to obtain list of data types failed: ERROR: Attribute
"typprtlen" not found
Kris Jurka
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2003-07-02 13:53:00 | Re: Please help with binary file |
Previous Message | Fernando Nasser | 2003-07-02 13:39:17 | Re: Please help with binary file |