From: | Killian Driscoll <killiandriscoll(at)gmail(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Transfer db from one port to another |
Date: | 2015-12-23 20:06:01 |
Message-ID: | CAL64pZMHjuTkkBJTbAqGkhuMc_KYPAv72UMrT6j5viS89Lutng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Killian Driscoll | 2015-12-23 20:08:18 | Re: Transfer db from one port to another |
Previous Message | Melvin Davidson | 2015-12-23 19:59:00 | Re: Transfer db from one port to another |