On 23 December 2015 at 20:59, Melvin Davidson <melvin6...@gmail.com> wrote:
> >OK - I see the logs there - the last log was almost 12 hrs ago, so no > recent one. > > That's not very helpful. Depending on how you've configured the logging, > PostgreSQL may only create one log file a day. > I didn't change a configuration, so it is how it came 'out of the box' > > Conventional thinking is It's what is IN the log file that is important. > Apologies - I have looked, but what's in it doesn't appear to relate to the current pg_restore as it was logged many hours before so I didn't mention it, and its a 13mb file so I didn't attach it. One thing I see it says *ERROR: syntax error at or near "1" at character 1STATEMENT: 1 0106000020E61000000100000001030000000100000049000000A2EA743BD46B1DC0EC7756B43F1* with the latter part being similar to the alphanumeric I see currently running in the windows shell. This is all a bit above my pay grade as you've probably gathered.... > > On Wed, Dec 23, 2015 at 2:50 PM, Killian Driscoll < > killiandrisc...@gmail.com> wrote: > >> 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. >>> >> >> > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. >
