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. >
