Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Mike Christensen
On Mon, Oct 18, 2010 at 3:37 AM, Dave Page wrote: > On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen wrote: >> On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote: >>> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen >>> wrote: Okay I found one that I can use.. One question..  

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Mike Christensen
On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote: > On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen wrote: >> Okay I found one that I can use.. >> >> One question..  Should the connection string in the script have the >> password for "root" hard coded in it?  Or will it use a password from >>

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen wrote: > On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote: >> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen >> wrote: >>> Okay I found one that I can use.. >>> >>> One question..  Should the connection string in the script have the >>> pas

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen wrote: > Okay I found one that I can use.. > > One question..  Should the connection string in the script have the > password for "root" hard coded in it?  Or will it use a password from > ~/.pgpass automatically?  If so, what user account will it

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Mike Christensen
On Mon, Oct 18, 2010 at 2:43 AM, Dave Page wrote: > On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen wrote: >> On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote: >>> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen >>> wrote: Sorry, it looks like it defaulted to the wrong DB.  I create

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen wrote: > On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote: >> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen >> wrote: >>> Sorry, it looks like it defaulted to the wrong DB.  I created the >>> schema in the "postgres" database and now I see

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Mike Christensen
On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote: > On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen wrote: >> Sorry, it looks like it defaulted to the wrong DB.  I created the >> schema in the "postgres" database and now I see a Jobs node.. > > :-) > >> One last question - How do I configure p

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen wrote: > Sorry, it looks like it defaulted to the wrong DB.  I created the > schema in the "postgres" database and now I see a Jobs node.. :-) > One last question - How do I configure pgAgent to start automatically? You'll need to put together

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Mike Christensen
On Mon, Oct 18, 2010 at 2:21 AM, Mike Christensen wrote: > On Mon, Oct 18, 2010 at 2:07 AM, Dave Page wrote: >> On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote: >>> Okay my required n00b question of the week, hopefully this'll be an easy >>> one.. >>> >>> I decided to give pgAgent a sho

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Mike Christensen
On Mon, Oct 18, 2010 at 2:07 AM, Dave Page wrote: > On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote: >> Okay my required n00b question of the week, hopefully this'll be an easy >> one.. >> >> I decided to give pgAgent a shot, because there's this stored sproc >> (sorry, function) I need

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen wrote: > Okay my required n00b question of the week, hopefully this'll be an easy one.. > > I decided to give pgAgent a shot, because there's this stored sproc > (sorry, function) I need to run nightly and I think spending hours > figuring out pgAg