[ADMIN] Log's stopped.

2002-03-03 Thread Manuel Trujillo
On Fri, 2002-03-01 at 22:16, Tom Lane wrote: > Is the vacuum actually running (accumulating any CPU time)? Or is it > just waiting on a lock held by one of those other guys? > And what are they doing --- who started them, what query was sent to > 'em, etc? > If you haven't a clue, try attaching t

Re: [ADMIN] [SQL] thinking about versioning my database schema

2002-03-03 Thread Dan Langille
On 4 Mar 2002 at 8:10, Janning Vygen wrote: > So i am saving the schema version inside the databse. Is it a good > idea? or is it nonsens and there is a much better way how to do it? I have a system table. One of the fields is the database version. If I change the schema, I modify the versio

Re: [ADMIN] removing duplicated constraints

2002-03-03 Thread Stephan Szabo
On Sun, 3 Mar 2002, Dan Langille wrote: > On 2 Mar 2002 at 23:42, Stephan Szabo wrote: > > > > > > I found the list of duplicate constraints by eyeballing the files I > > > created using the methods mentioned in previous post (mainly grep and > > > sort). Then I would search in the original dump

Re: [ADMIN] removing duplicated constraints

2002-03-03 Thread Dan Langille
On 2 Mar 2002 at 23:42, Stephan Szabo wrote: > > > I found the list of duplicate constraints by eyeballing the files I > > created using the methods mentioned in previous post (mainly grep and > > sort). Then I would search in the original dump file for the the CREATE > > CONSTRAINT statement.