On Thu, Jun 29, 2006 at 07:18:56AM -0700, [EMAIL PROTECTED] wrote:
> it doesn't seem even that: I tried to exclude all other parameters and
> leaving just:
> c:\> pg_restore script.sql
If that's just a straight SQL script produced by pg_dump, then you don't
need pg_restore, just "psql -f script.sq
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > C:\www\foo.com\trunk\db>pg_restore -h localhost -U postgres -W
> > mySecretPassword script.sql
>
> I don't think you're supposed to put the password on the command line
> like that. It's probably taking "mySecretPassword" as the file name
> to read.
[EMAIL PROTECTED] writes:
> C:\www\foo.com\trunk\db>pg_restore -h localhost -U postgres -W
> mySecretPassword script.sql
I don't think you're supposed to put the password on the command line
like that. It's probably taking "mySecretPassword" as the file name
to read.
rega
Hi all,
I'm not able to restore a pg 8.1 database. The dump has been generated
with pg_dump. I tried with both absolute and relative path but it
doesnt find the file. Any clue?
C:\www\foo.com\trunk\db>pg_restore -h localhost -U postgres -W
mySecretPassword script.sql
pg_restore: [archiver] could
