On 12/23/2015 06:35 AM, Killian Driscoll wrote:
On 23 December 2015 at 15:30, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
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>
<mailto: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>>
<mailto: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.
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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>
--
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
