> *ERROR: syntax error at or near "1" at character 1*
*That indicates a problem restoring data, but since it's probably from a previous restore attempt, and there is no time stamp, you might be able to ignore it.* *Do you have PgAdmin installed so you can look at the current contents of the restored database?* On Wed, Dec 23, 2015 at 3:06 PM, Killian Driscoll <killiandrisc...@gmail.com > wrote: > 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. >> > > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
