On 23 December 2015 at 20:38, Melvin Davidson <melvin6...@gmail.com> wrote:
> You can rREDIRECT the output to a file! EG: psql -U postgres -p 5532 > > your_output.txt > then use notepad to see the result. > > But from your last reply, it looks like Postgres is finishing the restore > by VACUUMing the database. That means it has to vacuum every table. > Since you never told us the info about whether you have a 32 or 64 bit > system, how much memory, what processor speed, etc, it's hard to say how > long it will take. > But if you have no errors in the postgresql log (after the restore > completed), you should be fine. > It's usually located in<Bitnami dir>\data\pg_log > OK - I see the logs there - the last log was almost 12 hrs ago, so no recent one. > > On Wed, Dec 23, 2015 at 2:27 PM, Killian Driscoll < > killiandrisc...@gmail.com> wrote: > >> On 23 December 2015 at 20:24, Adrian Klaver <adrian.kla...@aklaver.com> >> wrote: >> >>> On 12/23/2015 11:17 AM, Killian Driscoll wrote: >>> >>>> On 23 December 2015 at 20:14, Adrian Klaver <adrian.kla...@aklaver.com >>>> <mailto:adrian.kla...@aklaver.com>> wrote: >>>> >>> >>> >>> >>>> >>>> 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.....! >>>> >>> >>> So what do they say? >>> >>> If I 'slow down' the code by using the scroll on the right I can see >> words from the db I recognise, but the rest is very long alphanumeric >> characters. >> >>> >>>> >>>> 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? >>>> >>> >>> My guess in the Bitnami directory tree under logs/ or something similar. >>> >> >> I can't see a log folder..... >> >>> >>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> Adrian Klaver >>>> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >>>> <mailto:adrian.kla...@aklaver.com >>>> <mailto:adrian.kla...@aklaver.com>> >>>> <mailto: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> >>>> <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 >>> >> >> > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. >