Do not stop the active restore. Just run psql from the command shell in the Bitnami binary directory and use -U postgres and -p 5532 flags.
On Wed, Dec 23, 2015 at 2:22 PM, Killian Driscoll <killiandrisc...@gmail.com > wrote: > On 23 December 2015 at 20:19, Melvin Davidson <melvin6...@gmail.com> > wrote: > >> It's possible the restore is still building indexes. >> >> What does it show when you run this query? >> > Where do I run this query? Do I stop the restore that is 'active'? > >> >> SELECT datname, >> pid as pid, >> client_addr, >> usename as user, >> query, >> CASE WHEN waiting = TRUE >> THEN 'BLOCKED' >> ELSE 'no' >> END as waiting, >> query_start, >> current_timestamp - query_start as duration >> FROM pg_stat_activity >> WHERE pg_backend_pid() <> pid >> ORDER BY datname, >> query_start; >> >> >> On Wed, Dec 23, 2015 at 2:14 PM, 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? >>> >>> What does the Postgres log for the 9.4 instance show? >>> >>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> 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 >>> >>> >>> -- >>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-general >>> >> >> >> >> -- >> *Melvin Davidson* >> I reserve the right to fantasize. Whether or not you >> wish to share my fantasy is entirely up to you. >> > > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
