Re: cant get pg_dump/pg_restore to behave

On 5/4/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> There are several obvious things wrong with that (eg, psql cannot read
> -Fc format dumps) so I suppose it's an editorialization on what you
> really typed.

right, what i posted was a typo, what i ran did not have the -Fc

> Perhaps the problem is hidden there. Can you show us an
> *exact* transcript of a failing session?

[postgres(at)backup 0 ~]$ psql -q
postgres=# DROP DATABASE gforge5;
postgres=# CREATE DATABASE gforge5 WITH TEMPLATE = template0 ENCODING = 'UTF8';
postgres=#
[postgres(at)backup 0 ~]$ psql -d gforge5 -f gforge.schema
SET
SET
SET
COMMENT
CREATE LANGUAGE
SET
psql:gforge.schema:31: ERROR: could not access file
"$libdir/tsearch2": No such file or directory
psql:gforge.schema:34: ERROR: function public.gtsvector_in(cstring)
does not exist
psql:gforge.schema:42: ERROR: type gtsvector does not exist
...
-mike