March 2008 Archives

Frustrations

| | Comments (0)

So you do some DBA work and one day realised that the worst has come true - the replication is just so broken you have to start all over. Usually there is always some kind of ground level when working with computers. If a program is badly broken try reinstalling it. If that does not work try reinstalling the OS maybe. If that does not work buy a new computer etc.

I had this situation on a system I am playing DBA on. Slony-I was badly broken so I had to restart from scratch. My ground zero was to drop the database and start over... But... what if you can't???

[postgres@A05L005 postgres]$ dropdb oasis
dropdb: database removal failed: ERROR: tuple already updated by self

Negative measure of productivity

| | Comments (0)

This is happening even today, but still so true...


-2000 Lines Of Code

Quick Gallery Links

| | Comments (0)

If you look to the top right of this page, you will see a new section titled Links. In there I will regularly place new links of various content. Feel free to explore the content.