Re: Transfer db from one port to another - Mailing list pgsql-general

On 12/23/2015 06:35 AM, Killian Driscoll wrote:
> On 23 December 2015 at 15:30, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 12/23/2015 06:13 AM, Killian Driscoll wrote:
>
>         On 23 December 2015 at 14:56, 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 03:43 AM, Killian Driscoll wrote:
>
>                  On 23 December 2015 at 11:36, John R Pierce
>         <pierce@hogranch.com <mailto:pierce@hogranch.com>
>                  <mailto:pierce@hogranch.com <mailto:pierce@hogranch.com>>
>                  <mailto:pierce@hogranch.com
>         <mailto:pierce@hogranch.com> <mailto:pierce@hogranch.com
>         <mailto:pierce@hogranch.com>>>> wrote:
>
>                       On 12/23/2015 2:25 AM, Killian Driscoll wrote:
>
>                           Sorry, forgot to add: once I get the warning
>         that the
>                      Pg_dump
>                           can't be found there is then a password
>         prompt; I tried
>                      the db
>                           password and the pc password but both fail:
>
>                           Password:
>                           pg_dump: [archiver (db)] connection to database
>                      "irll_project"
>                           failed: FATAL:  p
>                           assword authentication failed for user "killian"
>
>
>                       note that databases don't have passwords, database
>         USERS have
>                       passwords.  'killian' probably doesn't have a database
>                  user, and
>                       since you didn't specify a user, it defaulted to
>         your system
>                       username (expecting that user to have been created in
>                  postgres, and
>                       wanting that probably non-existant postgres users
>         passsword)
>
>                       so, ok, try the command with -U postgres, as *
>                       *
>
>                           *pg_dump -Fc -p 5432 **-U postgres
>         **irll_project |
>                  pg_restore
>                           -U postgres -p 5532*
>
>                  OK - I did the dir and it shows that the dump and
>         restore.exe
>                  are there,
>                  but running the above gives the below errors
>
>                  09/06/2014  08:35           381,952 pg_dump.exe
>
>                  09/06/2014  08:35           180,224 pg_restore.exe
>
>                  C:\Users\killian>path "C:\Program
>         Files\PostgreSQL\9.3\bin";%path%
>
>                  C:\Users\killian>pg_dump -Fc -p 5432 -U postgres
>         irll_project |
>                  pg_restore -U po
>                  stgres -p 5532
>                  ccoulould not findd a n "pg_restore" to executeot find a
>                  "pg_dump" to
>                  execute
>
>                  pg_restore: [archiver] did not find magic string in
>         file header
>                  pg_dump: [custom archiver] could not write to output file:
>                  Invalid argument
>
>
>
>              Try breaking the above down into two steps:
>
>              pg_dump -Fc -p 5432 -U postgres -f irll_project.out
>         irll_project
>
>
>         Doing this step I get response
>         could not find a "pg_dump" to execute
>
>
>     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?

So do you know where the 9.4 binaries are installed?

>
>
>
>
>              pg_restore -U postgres -p 5532 irll_project.out
>
>
>
>
>                       if/when it prompts for a password, thats the
>         password of the
>                       'postgres' database user, as configured in the
>         postgres
>                  servers.
>
>                       note it will prompt for the password a couple
>         times,  once for
>                       postgres on port 5432, and again for postgres on
>         port 5532,
>                  at least
>                       if both database services are configured to require
>                  passwords for
>                       local connections.
>
>
>                       --
>                       john r pierce, recycling bits in santa cruz
>
>
>
>
>              --
>              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