Re: Transfer db from one port to another

Поиск
Список
Период
Сортировка
От Killian Driscoll
Тема Re: Transfer db from one port to another
Дата
Msg-id CAL64pZM-4rBaeOBGw6fceTwJaJD2wjUM-cdWLPuwGfDi1N3qUg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Transfer db from one port to another  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Transfer db from one port to another  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On 23 December 2015 at 20:07, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/23/2015 11:03 AM, Killian Driscoll wrote:
On 23 December 2015 at 16:02, Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

    On 12/23/2015 06:50 AM, Killian Driscoll wrote:

        On 23 December 2015 at 15:47, Adrian Klaver
        <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>




                      So cd into:

                      C:\Program Files\PostgreSQL\9.3\bin

                      and try:

                      pg_dump --help

                      that will at least establish that the command is
        being found.


                 OK - --help on the 9.3 lists help options


             In your original post you said you have a 9.3 instance and
        a 9.4
             instance.

              >From your post I would say the 9.3 instance was installed
        by the
             one click installer from EDB and the 9.4 from Bitami, is
        that correct?

        Correct.


             So do you know where the 9.4 binaries are installed?

        If by binaries, you mean the program files they are installed
        C:\Bitnami\wappstack-5.5.30-0\postgresql\bin


    Per previous posts you want, whenever possible, to us a newer
    version of pg_dump to move a database from an older version(9.3) to
    a newer one(9.4). Therefore you should do your dump and restore
    using the pg_dump.exe and pg_restore.exe from the Bitanami bin
    directory. I would cd to the above directory and do:

    pg_dump -V
    pg_restore -V

    to make sure the programs are found and are the 9.4 versions.

    Then do:

    pg_dump -Fc -p 5432 -U postgres -f irll_project.out irll_project

    pg_restore -U postgres -p 5532 irll_project.out


It appeared to work with this method, but it has now been running for
almost 4 hours with no result. The db is not that large (probably v.
small by most standards) and the .out file is ~200mb

What is running, the dump or the restore?
The restore - I can see the dump .out file that was created at 16hr in the postgresql/bin folder 









    --
    Adrian Klaver
    adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>




--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Transfer db from one port to another
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Transfer db from one port to another