Re: Transfer db from one port to another

[Melvin Davidson <melvin6925@xxxxxxxxx>]

>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@xxxxxxxxx> wrote:

On 23 December 2015 at 20:59, Melvin Davidson <melvin6925@xxxxxxxxx> 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 1
STATEMENT:  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@xxxxxxxxx> wrote:

On 23 December 2015 at 20:38, Melvin Davidson <melvin6925@xxxxxxxxx> 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@xxxxxxxxx> wrote:

On 23 December 2015 at 20:24, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

On 12/23/2015 11:17 AM, Killian Driscoll wrote:

On 23 December 2015 at 20:14, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
        <mailto:adrian.klaver@xxxxxxxxxxx
        <mailto:adrian.klaver@xxxxxxxxxxx>>
                 <mailto:adrian.klaver@xxxxxxxxxxx
        <mailto:adrian.klaver@xxxxxxxxxxx>
                 <mailto:adrian.klaver@xxxxxxxxxxx
        <mailto:adrian.klaver@xxxxxxxxxxx>>>




             --
             Adrian Klaver
        adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
        <mailto:adrian.klaver@xxxxxxxxxxx
        <mailto:adrian.klaver@xxxxxxxxxxx>>




    --
    Adrian Klaver
    adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

--

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.