Re: Transfer db from one port to another - Mailing list pgsql-general
On 23 December 2015 at 20:59, Melvin Davidson <melvin6925@gmail.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 1
STATEMENT: 1 0106000020E61000000100000001030000000100000049000000A2EA743BD46B1DC0EC7756B43F1
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@gmail.com> wrote:On 23 December 2015 at 20:38, Melvin Davidson <melvin6925@gmail.com> wrote:It's usually located in<Bitnami dir>\data\pg_logBut if you have no errors in the postgresql log (after the restore completed), you should be fine.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 from your last reply, it looks like Postgres is finishing the restore by VACUUMing the database. That means it has to vacuum every table.You can rREDIRECT the output to a file! EG: psql -U postgres -p 5532 > your_output.txtthen use notepad to see the result.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.comMelvin 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.
pgsql-general by date: