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.