Search Postgresql Archives

Re: Transfer db from one port to another

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/23/2015 06:50 AM, Killian Driscoll wrote:
On 23 December 2015 at 15:47, Adrian Klaver <adrian.klaver@xxxxxxxxxxx


             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







--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux