Re: converting an old databaes to postgresql 8.1
| От | Sean Davis |
|---|---|
| Тема | Re: converting an old databaes to postgresql 8.1 |
| Дата | |
| Msg-id | 264855a00908031456v4197283bn181b3eca8d1e933e@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: converting an old databaes to postgresql 8.1 (Frank Bax <fbax@sympatico.ca>) |
| Список | pgsql-novice |
On Mon, Aug 3, 2009 at 5:46 PM, Frank Bax <fbax@sympatico.ca> wrote:
Just a detail, but if I am not mistaken, you should use the pg_dump from the NEW version (the target version) running against the database running on the older version. In other words, reinstall the old version and get it up and running. Then use the pg_dump from the NEW version to do the pg_dump. Stop the old server, start the new server, and do the restore using the new server.
Sean
Roger D Vargas wrote:After a reinstall, I lost my most recent backup in sql format and
instead I have the database directory. The big problem is that it is in
some old format, 8.1 doesnt accept it and 8.0.15 neither. Is there any
way to convert such database files to the recent format?
YES, install the same version that was used to create the database; then create another backup. The database directory should have a file called PG_VERSION which contains this version number.
Just a detail, but if I am not mistaken, you should use the pg_dump from the NEW version (the target version) running against the database running on the older version. In other words, reinstall the old version and get it up and running. Then use the pg_dump from the NEW version to do the pg_dump. Stop the old server, start the new server, and do the restore using the new server.
Sean
В списке pgsql-novice по дате отправления: