On Wed, 21 Mar 2001, Tim Frank wrote:
> John,
>
> Thanks for mentioning that fix :) I'm sure one could run sed or
> something similar to remove that line at the top of the file after the
> backup has completed (I shall have to try that sometime).
It's probably easier to set PGUSER and PGP
the development docs for 7.1 which can be
read here
http://www.postgresql.org/devel-corner/docs/admin/backup-file.html so I
won't repeat it myself.
Tim Frank
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<
3/20/2001 11:23:19 AM, Joseph Koenig <[EMAIL PROTECTED]> wrote:
>Alright, Next question. I got the dump out (thanks for all the help).
>Now I can't get it back in on the other server! It keeps telling me
>permission denied to the file itself. I even tried chmod'ing it to 777
>and changing the own
> ok, makes sense, so how would I get around it? Thanks,
You type in the username/password as if the prompts were there. :)
John
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ok, makes sense, so how would I get around it? Thanks,
Joe
John Madden wrote:
>
> > All I want to do is dump the db, which should be easy, right? If I do:
> > pg_dump -u worldwide > worldwide.pgdump
>
> pg_dump, with the -u, expects you to enter your username/password to
> stdin or something.
> All I want to do is dump the db, which should be easy, right? If I do:
> pg_dump -u worldwide > worldwide.pgdump
pg_dump, with the -u, expects you to enter your username/password to
stdin or something. (guys, print the prompts to STDERR instead?) The
problem is that stdout is redirected into
