Re: cant get pg_dump/pg_restore to behave

On 5/4/07, Tom Lane <tgl@sss.pgh.pa.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@backup 0 ~]$ psql -q
postgres=# DROP DATABASE gforge5;
postgres=# CREATE DATABASE gforge5 WITH TEMPLATE = template0 ENCODING = 'UTF8';
postgres=#
[postgres@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