Hello,
I got a database from client to be migrated from 8.2.4 to 9.0 and I got an
error ERROR: could not open relation 1663/206914/10780: No such file or
directory.
When I checked pg_class for the oid it occured to be
information_schema.tables view. Is there anyway of restoring the view?
pgAdmin
No, all my index B-Tree Index
Thanks
Manoj K P
2011/12/18 杨晓青
> is your index a hash index? xlog does not include the changes on hash
> index,your must rebuild hash index after recovery from xlog.
>
>
> 2011/12/16 K P Manoj
>
>> Hi
>>
>> The details given below is for a test server, that I br
Lukasz Brodziak writes:
> I got a database from client to be migrated from 8.2.4 to 9.0 and I got an
> error ERROR: could not open relation 1663/206914/10780: No such file or
> directory.
> When I checked pg_class for the oid it occured to be
> information_schema.tables view. Is there anyway of r
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on postgres 9.1.1, running on Debian Squeeze.
On
On 12/19/11 10:04 AM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on
We have a function which checks if certain tables exist in tables view it
simply runs select over the view and if it returns no rows function creates
table. In this case it ends up with the error in subject.
Fortunately I managed to repair the db. PgAdmin did not show the create
script for the view
Hi guys
I have a 8.4 install that I am moving to a new DB server running 9.0. This
is all well and god for the most part, except when it comes to restoring the
data in several of the tables. See the problem is the old schema was an
ASCII neutral zone, and the new server has the schema set for U