From: | Tim Frank <tfrank(at)registrar(dot)uoguelph(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Really Dumb Question...(Dumping db) |
Date: | 2001-03-21 04:44:43 |
Message-ID: | 20010321.4444384@cr625228-a.ktchnr1.on.wave.home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Joe,
If you have password authentication on for the other server as well try
this command instead,
psql -e worldwide -f worldwide.pgdump
where the -f switch tells psql to execute commands contained in a file.
I just fought with that one today for a bit until I remembered that
switch. You should then get a password prompt to enter your password.
Tim Frank
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 20/03/01, 6:18:02 PM, joe(at)jwebmedia(dot)com (Joseph Koenig) wrote
regarding Re: [GENERAL] Really Dumb Question...(Dumping db):
> 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 ownership to postgres.postgres, su to postgres and it
> says "permission denied" when I try to:
> psql -e worldwide < worldwide.pgdump
> What now? Thanks for the help :)
> On another note -- the docs for postgres seem to be a bit scarce for the
beginner...
> Joe
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-21 05:24:29 | Re: Upgrade 6.5 to 7.0.3 or 7.1 beta? |
Previous Message | Brian Baquiran | 2001-03-21 03:39:06 | Upgrade 6.5 to 7.0.3 or 7.1 beta? |