On 23 December 2015 at 20:14, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 12/23/2015 11:09 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 20:07, Adrian Klaver <adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>> wrote: >> >> On 12/23/2015 11:03 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 16:02, Adrian Klaver >> <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> <mailto:adrian.kla...@aklaver.com >> <mailto: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 >> <mailto:adrian.kla...@aklaver.com> >> <mailto:adrian.kla...@aklaver.com >> >> <mailto: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 >> >> >> 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? > Since I ran the restore the windows shell has been 'active' with codes lines running - I took that as being active.....! > > What does the Postgres log for the 9.4 instance show? > Where is the log - here Control Panel\System and Security\Administrative Tools in event viewer or elsewhere? > > >> >> >> >> >> >> >> >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> <mailto:adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>> >> >> >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >