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 | CAL64pZPCZO9z+v8EyEGTQC6sY-C0JeTz8sXW_h-6CY23bh8XbQ@mail.gmail.com Whole thread Raw |
| In response to | Re: Transfer db from one port to another (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Responses |
Re: Transfer db from one port to another
(Adrian Klaver <adrian.klaver@aklaver.com>)
|
| List | pgsql-general |
On 23 December 2015 at 20:14, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/23/2015 11:09 AM, Killian Driscoll wrote:On 23 December 2015 at 20:07, Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:
On 12/23/2015 11:03 AM, Killian Driscoll wrote:
On 23 December 2015 at 16:02, Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
<mailto:adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>> wrote:
On 12/23/2015 06:50 AM, Killian Driscoll wrote:
On 23 December 2015 at 15:47, Adrian Klaver
<adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>
<mailto:adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.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?
Since I ran the restore the windows shell has been 'active' with codes lines running - I took that as being active.....!
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?
--
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
pgsql-general by date: