On 4/20/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Mike Frysinger" <vapier(dot)adi(at)gmail(dot)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