Search Postgresql Archives

Re: cant get pg_dump/pg_restore to behave

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 5/4/07, Tom Lane <tgl@xxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux