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:13 AM, Killian Driscoll wrote:
On 23 December 2015 at 14:56, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> wrote:

    On 12/23/2015 03:43 AM, Killian Driscoll wrote:

        On 23 December 2015 at 11:36, John R Pierce <pierce@xxxxxxxxxxxx
        <mailto:pierce@xxxxxxxxxxxx>
        <mailto:pierce@xxxxxxxxxxxx <mailto:pierce@xxxxxxxxxxxx>>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>




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