Thread: Can't drop a table ...

Can't drop a table ...

From
Bruno Mattarollo
Date:
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/
----------------------------------------------------




Re: Can't drop a table ...

From
Bruno Mattarollo
Date:
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/
----------------------------------------------------