Re: Transfer db from one port to another

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

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.