On 23 December 2015 at 16:02, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 12/23/2015 06:50 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 15:47, Adrian Klaver <adrian.kla...@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 > > >> >> >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >