Re: [cobalt-users] POSTGRES Cobalt - Rebuild indexes

[Frederic <journal@xxxxxxxxxx>]

Hello

ok I found this
http://gke.sun.com/cobalt/coPortal_details.jsp?metadata=METADATA_409418
in order to solve my problem


but when I make the dump I've got a error  :

SQL query to dump the contents of Table 'quota' did not execute.
Explanation from backend: 'ERROR:  cannot find attribute 1 of relation
quota '. The query was: 'COPY "quota" TO stdout; '.

After I don't find "create_table for quota" in the dump just

CREATE TABLE "quota" (
        );

before destroy cobalt database, I build a new (test) database cobalt2 and when I try to restore with
cobalt.dump this error comes :


CREATE TABLE "quota" (         );
ERROR:  DefineRelation: please inherit from a relation or define an attribute
.../...

CREATE TABLE "quota" (
        );
ERROR:  DefineRelation: please inherit from a relation or define an attribute

.../...

COPY "quota" FROM stdin;
ERROR:  COPY command failed.  Class quota does not exist.

***/****/***/***/**/***

Could I create the table quota BY hand ??
Could someone post the psql structure ?

Could I restore the cobalt database without quota table ??


Please HELP needed


Fred


F> I try to connect to cobalt postgress database and obviously there is
F> some mistakes are into the quota table on the postgres Cobalt database
F> on my Raq.

cobalt=>> select * from quota;
F> ERROR:  cannot find attribute 1 of relation quota

F> Before I try anyhing, I dumped the database

F> pg_dump -D -u -f dump.psql cobalt

F> but if necessary I notice there is no pg_restore on the cobalt ??

F> QUESTION 1 : HOW COULD I RESTORE FROM THE DUMP IF NECESSARY ?

F> QUESTION 2 : could I do this :

F> /usr/bin/psql -D /home/pgsql/base/ -O -P cobalt -o reindex_psql.log

F> without any problem ???


F> Maybe you have solved this problem before and you can send solution.


F> THANKS IN ADVANCE


F> Frederic


F> _____________________________________
F> cobalt-users mailing list
F> cobalt-users@xxxxxxxxxxxxxxx
F> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
F> http://list.cobalt.com/mailman/listinfo/cobalt-users