Re: [ADMIN] Problem with the conection

2009-03-15 Thread Tommy Cheng
try adding these few lines: hostdatabase user 161.0.0.0/8md5 hostdatabase user 161.0.0.0/8trust # "local" is for Unix domain socket connections only local all all trust make sure other "public" 161.x.x.x ip cannot access your server b

Re: [ADMIN] turn off auto index for foreign key

2008-06-09 Thread Tommy Cheng
um...Your soln is possible. But if the user created an unique index using constraint name __key5, it will not be able to distinguish it from other auto index. On Tue, Jun 10, 2008 at 12:58 PM, Alex Hunsaker <[EMAIL PROTECTED]> wrote: > On Mon, Jun 9, 2008 at 10:17 PM, Tommy Chen

Re: [ADMIN] turn off auto index for foreign key

2008-06-09 Thread Tommy Cheng
t; On Mon, Jun 9, 2008 at 8:48 PM, Tommy Cheng <[EMAIL PROTECTED]> wrote: > > Hi admins, > > I would like to turn off the auto index for child table's foreign key. > It > > is because i want to read the information_schema for table, column, > index, > > un

[ADMIN] turn off auto index for foreign key

2008-06-09 Thread Tommy Cheng
e and user created index? Thanks Tommy Cheng

[ADMIN] How to identify the current WAL segment file

2007-12-03 Thread Tommy Cheng
Hi everyone, I am new to postgresql. So point me to somewhere else if you got the right direction. i am using PostgreSQL 8.1.9 on a linux system and i want to setup PITR. i found that the segment size is too large that the copying frequency is not high enough. So, i want to set up a cron job tha