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
