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

[cobalt-users] Re: Rebuild PostgreSQL 'cobalt' database



> > section (spread over 2-3 lines)
> > - -  Remove the 'COPY "quota" FROM stdin;' line (end of schema file)
> > - -  Exit editor and save changes
>
>   I am not sure this is necessary.
>   last time I tried it, (yestereday on an XTR) I got errors.
>   so I left it in and it worked OK.
>   Maybe a postgre guru can comment on this!

Not a guru, but if you don't delete it, a partial quota table is recreated 
when the db is rebuilt, rather than letting the swatch process do it.  
I've never *not* removed the quota table section from the schema file.

>   I have never used the procedure you posted, so I really
>   can't comment on it....

I think it's the one I posted to the list, and which has been mirrored 
around on some other sites I think.

I use it "all the time" and it works fine for me... YMMV :)