From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Killian Driscoll <killiandriscoll(at)gmail(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Transfer db from one port to another |
Date: | 2015-12-23 19:14:37 |
Message-ID: | 567AF29D.2030602@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/23/2015 11:09 AM, Killian Driscoll wrote:
> On 23 December 2015 at 20:07, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 12/23/2015 11:03 AM, Killian Driscoll wrote:
>
> On 23 December 2015 at 16:02, 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>>> wrote:
>
> On 12/23/2015 06:50 AM, Killian Driscoll wrote:
>
> On 23 December 2015 at 15:47, 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>>
>
>
>
>
> So cd into:
>
> C:\Program Files\PostgreSQL\9.3\bin
>
> and try:
>
> pg_dump --help
>
> that will at least establish that the
> command is
> being found.
>
>
> OK - --help on the 9.3 lists help options
>
>
> In your original post you said you have a 9.3
> instance and
> a 9.4
> instance.
>
> >From your post I would say the 9.3 instance was
> installed
> by the
> one click installer from EDB and the 9.4 from
> Bitami, is
> that correct?
>
> Correct.
>
>
> So do you know where the 9.4 binaries are installed?
>
> If by binaries, you mean the program files they are
> installed
> C:\Bitnami\wappstack-5.5.30-0\postgresql\bin
>
>
> Per previous posts you want, whenever possible, to us a newer
> version of pg_dump to move a database from an older
> version(9.3) to
> a newer one(9.4). Therefore you should do your dump and restore
> using the pg_dump.exe and pg_restore.exe from the Bitanami bin
> directory. I would cd to the above directory and do:
>
> pg_dump -V
> pg_restore -V
>
> to make sure the programs are found and are the 9.4 versions.
>
> Then do:
>
> pg_dump -Fc -p 5432 -U postgres -f irll_project.out
> irll_project
>
> pg_restore -U postgres -p 5532 irll_project.out
>
>
> It appeared to work with this method, but it has now been
> running for
> almost 4 hours with no result. The db is not that large (probably v.
> small by most standards) and the .out file is ~200mb
>
>
> What is running, the dump or the restore?
>
> The restore - I can see the dump .out file that was created at 16hr in
> the postgresql/bin folder
So how are you determining it is running and that it is not doing anything?
What does the Postgres log for the 9.4 instance show?
>
>
>
>
>
>
>
>
>
>
> --
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Killian Driscoll | 2015-12-23 19:17:52 | Re: Transfer db from one port to another |
Previous Message | Killian Driscoll | 2015-12-23 19:09:23 | Re: Transfer db from one port to another |