Re: Transfer db from one port to another

>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.

Conventional thinking is It's what is IN the log file that is important.

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.