| Lists: | pgsql-general |
|---|
| From: | "Bilicki Vilmos" <bilickiv(at)inf(dot)u-szeged(dot)hu> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3. |
| Date: | 2004-10-23 08:10:41 |
| Message-ID: | 20041023081041.D1C0423959@mail.inf.u-szeged.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi all,
I have upgraded my cygwin installation and it has replaced my old 7.3
postgresql.
My questions are the following:
How can I use the old files with the newer version?
If this is not possible, how can I migrate my database to a newer version
without the old database engine?
If this is not possible how can I downgrade the postgresql to an appropriate
version? (The setup utility provides only the 7.4 version)
Many thanks for helping me,
Vilmos
| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Bilicki Vilmos <bilickiv(at)inf(dot)u-szeged(dot)hu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3. |
| Date: | 2004-10-23 23:27:55 |
| Message-ID: | 20041023232755.GC11915@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Sat, Oct 23, 2004 at 10:10:41 +0200,
Bilicki Vilmos <bilickiv(at)inf(dot)u-szeged(dot)hu> wrote:
> Hi all,
>
> I have upgraded my cygwin installation and it has replaced my old 7.3
> postgresql.
>
> My questions are the following:
>
> How can I use the old files with the newer version?
> If this is not possible, how can I migrate my database to a newer version
> without the old database engine?
> If this is not possible how can I downgrade the postgresql to an appropriate
> version? (The setup utility provides only the 7.4 version)
>
> Many thanks for helping me,
The normal procedure is to do a dump before shutting the current server
down (though using the newer pg_dumpall client is recommended if you
both the new and old versions installed at the same time). Then after
shutting the old server down and starting the new one up, you import
the dump file.
| From: | stig erikson <stigerikson_nospam_(at)yahoo(dot)se> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: The data directory was initialized by PostgreSQL version 7.3, |
| Date: | 2004-10-24 15:13:59 |
| Message-ID: | clggr7$1mv0$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Bilicki Vilmos wrote:
> Hi all,
>
> I have upgraded my cygwin installation and it has replaced my old 7.3
> postgresql.
>
> My questions are the following:
>
> How can I use the old files with the newer version?
> If this is not possible, how can I migrate my database to a newer version
> without the old database engine?
> If this is not possible how can I downgrade the postgresql to an appropriate
> version? (The setup utility provides only the 7.4 version)
>
> Many thanks for helping me,
>
> Vilmos
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
see:
http://www.postgresql.org/docs/7.4/static/install-upgrading.html