Postgres Pro
Downloads
Home   >   mailing lists

Re: Transfer db from one port to another - Mailing list pgsql-general

From Killian Driscoll
Subject Re: Transfer db from one port to another
Date
Msg-id CAL64pZNc0Se2o9g59fGx-=MVgzX5Yf4SnNcO-xSXMd1EEb7=pQ@mail.gmail.com
Whole thread Raw
In response to Re: Transfer db from one port to another  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Transfer db from one port to another  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
On 23 December 2015 at 20:38, Melvin Davidson <melvin6925@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 <killiandriscoll@gmail.com> wrote:
On 23 December 2015 at 20:24, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/23/2015 11:17 AM, Killian Driscoll wrote:
On 23 December 2015 at 20:14, Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
        <mailto:adrian.klaver@aklaver.com
        <mailto:adrian.klaver@aklaver.com>>
                  <mailto:adrian.klaver@aklaver.com
        <mailto:adrian.klaver@aklaver.com>
                 <mailto:adrian.klaver@aklaver.com
         <mailto:adrian.klaver@aklaver.com>>>




             --
             Adrian Klaver
        adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
        <mailto:adrian.klaver@aklaver.com
        <mailto:adrian.klaver@aklaver.com>>




    --
    Adrian Klaver
    adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>




--
Adrian Klaver
adrian.klaver@aklaver.com




--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Transfer db from one port to another
Next
From: Melvin Davidson
Date:
Subject: Re: Transfer db from one port to another