Ok,
I didn't think you could do a restore as a non-superuser. I had
executed the command on the remote(cygwin) machine in this case. I
didn't specify a user to have it run as on the windows side (thought it
would default to postgres).
On the cygwin side I did execute it under a non-superuser
Mike G <[EMAIL PROTECTED]> writes:
> It looks like it started off as a permissions problem. I added the
> users to the database before trying again and this time it worked fine.
> I have attached the log from the original attempt if you wish to have a
> look.
As best I can tell, you ran the resto
It looks like it started off as a permissions problem. I added the
users to the database before trying again and this time it worked fine.
I have attached the log from the original attempt if you wish to have a
look.
Mike
On Fri, 2004-12-17 at 22:35, Tom Lane wrote:
> "Mike G." <[EMAIL PROTECT
"Mike G." <[EMAIL PROTECTED]> writes:
> In testing RC1 today I attempted to use pg_dump -h cygwin_box mydb | psql -h
> RC1_box mydb
> It started off ok but at somepoint while transferring data over in a table it
> went astray. I started getting rows and rows of syntax errors most of them
> say
