Re: Transfer db from one port to another - Mailing list pgsql-general

On 12/23/2015 11:09 AM, Killian Driscoll wrote:
> On 23 December 2015 at 20:07, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto: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>
>         <mailto: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>
>         <mailto: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

So how are you determining it is running and that it is not doing anything?

What does the Postgres log for the 9.4 instance show?

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


--
Adrian Klaver
adrian.klaver@aklaver.com