On 4/20/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Mike Frysinger" <vapier.adi@gmail.com> writes:
> > $ pg_dump -F c -s -d database-server mydb > mydb.schema
> > $ psql -d mydb < mydb.schema
> > <error about users_idx not existing>
>
> pg_dump -Fc does not produce a file that psql can read directly.
> Is the above really what you did?
i was experimenting with using pg_dump/pg_restore and pg_dump/psql ...
when using psql to import, i didnt use -Fc ... but the errors were the
same regardless of whether i used pgsl or pg_restore ;(
-mike