Re: Transfer db from one port to another

On 23 December 2015 at 16:02, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 12/23/2015 06:50 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 15:47, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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

>
>
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>