[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[cobalt-users] Re: Rebuild PostgreSQL 'cobalt' database
- Subject: [cobalt-users] Re: Rebuild PostgreSQL 'cobalt' database
- From: Bruce Timberlake <bruce@xxxxxxxxxx>
- Date: Thu Jun 5 10:14:01 2003
- Organization: BRTNet.org
- List-id: Mailing list for users to share thoughts on Sun Cobalt products. <cobalt-users.list.cobalt.com>
> > 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 :)