Re: [ADMIN] Deadlock like scenario

2011-11-10 Thread Robins Tharakan
http://www.postgresql.org/docs/8.4/static/sql-reindex.html -- Robins Tharakan On 11/11/2011 08:34 AM, Shridhar Polas wrote: Hi, I am experience the problem where locks acquired by postgres are NOT getting released. The use case is something like:- ·There is a table let’s say “A” and the trigg

Re: [ADMIN] version:8.2.6 pg_hda.conf problem

2008-02-28 Thread Robins Tharakan
To allow this ip address(192.168.2.1) to work without a password, you may want to try this instead: host all all 192.168.2.1/32 <http://192.168.2.1/254> trust *Robins Tharakan* On Fri, Feb 29, 2008 at 8:27 AM, 李国庆 <[EMAIL PROTECTED]> wrote: > Hi Everybody, >I sta

Re: [ADMIN] rename database

2008-02-06 Thread Robins Tharakan
Rightly as Guillaume said, tampering with a system table isn't a very good idea. This is what he suggested: 1. Lets say you are connected to Database A 2. Reconnect to Database B on the server (this database B could be any database other than A on the server) 3. Rename database A to C 4. Reconnect