Re: [ADMIN] pg_autovacuum entries

2009-10-30 Thread Alvaro Herrera
Anj Adu escribió: > Is there a way to create an entry for a table that does not exist yet? No, you will have to have "INSERT INTO pg_autovacuum" statements alongside your table creation. I don't see that this is a lot of trouble though, you can simply do CREATE TABLE whatever ( ... ); INSERT IN

[ADMIN] pg_autovacuum entries

2009-10-30 Thread Anj Adu
We are running a mix postgres 8.1.2 and 8.1.9 on several boxes. I would like to use the pg_autovacuum table to skip vacuuming certain tables that get dropped regularly (partitions) Is there a way to create an entry for a table that does not exist yet? Reason I ask is we have several "daily" parti

[ADMIN] Enabling Server Instrumentation on 8.4.1

2009-10-30 Thread Arnold, Sandra
I am in the process of trying to enable Server Instrumentation on Postgresql 8.4.1. I installed the software using the Linux one-click-installer. I have looked for the sql file that is shown on the screen that comes up when I try to use the Server Status tool in PGAdminIII but cannot find it.

Re: [pgadmin-hackers] [ADMIN] pgAdmin 1.10, OSX 10.6 problem

2009-10-30 Thread Dave Page
On Fri, Oct 30, 2009 at 1:20 PM, David Lazar wrote: > Hi, > > Preferences for Snow Leopard for me match your advice Mr. Page. Full > Keyboard Access, All Controls not sure what to try now... sure would be > sweet to get that cycling option with the KB... It works fine for me if I turn on all

Re: [pgadmin-hackers] [ADMIN] pgAdmin 1.10, OSX 10.6 problem

2009-10-30 Thread David Lazar
Hi, Preferences for Snow Leopard for me match your advice Mr. Page. Full Keyboard Access, All Controls not sure what to try now... sure would be sweet to get that cycling option with the KB... Thanks! On Fri, Oct 30, 2009 at 4:59 AM, Dave Page wrote: > On Fri, Oct 30, 2009 at 8:00 AM,

Re: [pgadmin-hackers] [ADMIN] pgAdmin 1.10, OSX 10.6 problem

2009-10-30 Thread Dave Page
On Fri, Oct 30, 2009 at 8:00 AM, Guillaume Lelarge wrote: > Le vendredi 30 octobre 2009 à 02:37:04, David Lazar a écrit : >> Hi, >> >> On Linux version of pgAdmin, in an edit grid, with a boolean column, I >>  could hammer the space bar key and cycle through True, False and the other >>  one... wh

Re: [ADMIN] pgAdmin 1.10, OSX 10.6 problem

2009-10-30 Thread Guillaume Lelarge
Le vendredi 30 octobre 2009 à 02:37:04, David Lazar a écrit : > Hi, > > On Linux version of pgAdmin, in an edit grid, with a boolean column, I > could hammer the space bar key and cycle through True, False and the other > one... whatever... > > With OSX version if I hit spacebar I get True... b