Re: Can't drop a table ...

Posting a followup .. After this error, I could do export of the database
using pg_dump... no problems so far ...

/B

On Thu, 15 May 2003, Bruno Mattarollo wrote:

> Hello,
>
> As a followup of my mail from yesterday, I am trying to export the second
> database and I have some problems with a table called "foo". The developer
> is telling me that I can drop that table so I try and I get this error:
>
> testivo=# drop table foo;
> FATAL 2:  open of /usr/local/pgsql/data/pg_clog/0773 failed: No such file
> or directory
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> !#
>
> The strange thing is that this file is present...:
>
> # ls -la 0773
> -rw-------    1 postgres postgres    98304 May 15 11:14 0773
> # pwd
> /usr/local/pgsql/data/pg_clog
>
> When I try to do a "pg_dump -C -f dump.sql testivo"
>
> I get this error after an export of 600MB so far...
>
> pg_dump: dumping out the contents of table foo
> pg_dump: ERROR:  stat failed on file '/usr/lib/pgsql/tsearch': No such
> file or directory
> pg_dump: lost synchronization with server, resetting connection
> pg_dump: SQL command to dump the contents of table "foo" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR:  stat failed on file
> '/usr/lib/pgsql/tsearch': No such file or directory
> pg_dump: The command was: COPY "foo" TO stdout;
> pg_dump: *** aborted because of error
>
> Would the recommendation be to install "tsearch"?
>
> /B
>
>

--

--- Bruno Mattarollo <bruno@web1.greenpeace.org> ---
    SysAdmin & TechLead - Greenpeace International
    http://www.greenpeace.org/
----------------------------------------------------