Re: Transfer db from one port to another

>
*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 <killiandriscoll(at)gmail(dot)com
> wrote:

> On 23 December 2015 at 20:59, Melvin Davidson <melvin6925(at)gmail(dot)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 <
>> killiandriscoll(at)gmail(dot)com> wrote:
>>
>>> On 23 December 2015 at 20:38, Melvin Davidson <melvin6925(at)gmail(dot)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 <
>>>> killiandriscoll(at)gmail(dot)com> wrote:
>>>>
>>>>> On 23 December 2015 at 20:24, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>>>>> > wrote:
>>>>>
>>>>>> On 12/23/2015 11:17 AM, Killian Driscoll wrote:
>>>>>>
>>>>>>> On 23 December 2015 at 20:14, Adrian Klaver <
>>>>>>> adrian(dot)klaver(at)aklaver(dot)com
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Adrian Klaver
>>>>>>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>>>>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Adrian Klaver
>>>>>>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Adrian Klaver
>>>>>> adrian(dot)klaver(at)aklaver(dot)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.