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

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>> 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>>> 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.

>
>
>     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>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com