Re: Transfer db from one port to another

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

>
>
>

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