Thread: pgAgent absent from win32 beta distributions?
In both postgresql 8.4-beta1 and pgadmin3 1.10-beta2, I can't find a pgAgent executable. Any clues?
On Mon, Apr 20, 2009 at 4:32 PM, Kevin Field <kevinjamesfield@gmail.com> wrote: > In both postgresql 8.4-beta1 and pgadmin3 1.10-beta2, I can't find a > pgAgent executable. Any clues? It's a seperate download now: http://www.postgresql.org/ftp/pgadmin3/release/pgagent/ An installer based version should be available via StackBuilder in the not-to-distant future. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Apr 20, 12:05 pm, dp...@pgadmin.org (Dave Page) wrote: > On Mon, Apr 20, 2009 at 4:32 PM, Kevin Field <kevinjamesfi...@gmail.com> wrote: > > In both postgresql 8.4-beta1 and pgadmin3 1.10-beta2, I can't find a > > pgAgent executable. Any clues? > > It's a seperate download now:http://www.postgresql.org/ftp/pgadmin3/release/pgagent/ > > An installer based version should be available via StackBuilder in the > not-to-distant future. Ah, thanks, I was completely unaware. Now that I've installed it, I can't get the service to start. Well, it starts, but then it brings up a message saying that the service started and then stopped, possibly because it had nothing to do. I tried pgAgent DEBUG but it doesn't start, it just spits out the usage message, which AFAICS I'm following fine. Help?
On Apr 20, 2:28 pm, Kevin Field <kevinjamesfi...@gmail.com> wrote: > On Apr 20, 12:05 pm, dp...@pgadmin.org (Dave Page) wrote: > > > On Mon, Apr 20, 2009 at 4:32 PM, Kevin Field <kevinjamesfi...@gmail.com> wrote: > > > In both postgresql 8.4-beta1 and pgadmin3 1.10-beta2, I can't find a > > > pgAgent executable. Any clues? > > > It's a seperate download now:http://www.postgresql.org/ftp/pgadmin3/release/pgagent/ > > > An installer based version should be available via StackBuilder in the > > not-to-distant future. > > Ah, thanks, I was completely unaware. > > Now that I've installed it, I can't get the service to start. Well, > it starts, but then it brings up a message saying that the service > started and then stopped, possibly because it had nothing to do. I > tried pgAgent DEBUG but it doesn't start, it just spits out the usage > message, which AFAICS I'm following fine. Help? Oh, I also ran the code in pgagent_upgrade.sql.
On Apr 20, 2:34 pm, Kevin Field <kevinjamesfi...@gmail.com> wrote: > On Apr 20, 2:28 pm, Kevin Field <kevinjamesfi...@gmail.com> wrote: > > > > > On Apr 20, 12:05 pm, dp...@pgadmin.org (Dave Page) wrote: > > > > On Mon, Apr 20, 2009 at 4:32 PM, Kevin Field <kevinjamesfi...@gmail.com> wrote: > > > > In both postgresql 8.4-beta1 and pgadmin3 1.10-beta2, I can't find a > > > > pgAgent executable. Any clues? > > > > It's a seperate download now:http://www.postgresql.org/ftp/pgadmin3/release/pgagent/ > > > > An installer based version should be available via StackBuilder in the > > > not-to-distant future. > > > Ah, thanks, I was completely unaware. > > > Now that I've installed it, I can't get the service to start. Well, > > it starts, but then it brings up a message saying that the service > > started and then stopped, possibly because it had nothing to do. I > > tried pgAgent DEBUG but it doesn't start, it just spits out the usage > > message, which AFAICS I'm following fine. Help? > > Oh, I also ran the code in pgagent_upgrade.sql. Sorry, forgot to retitle.
On Mon, Apr 20, 2009 at 7:34 PM, Kevin Field <kevinjamesfield@gmail.com> wrote: > On Apr 20, 2:28 pm, Kevin Field <kevinjamesfi...@gmail.com> wrote: >> On Apr 20, 12:05 pm, dp...@pgadmin.org (Dave Page) wrote: >> >> > On Mon, Apr 20, 2009 at 4:32 PM, Kevin Field <kevinjamesfi...@gmail.com> wrote: >> > > In both postgresql 8.4-beta1 and pgadmin3 1.10-beta2, I can't find a >> > > pgAgent executable. Any clues? >> >> > It's a seperate download now:http://www.postgresql.org/ftp/pgadmin3/release/pgagent/ >> >> > An installer based version should be available via StackBuilder in the >> > not-to-distant future. >> >> Ah, thanks, I was completely unaware. >> >> Now that I've installed it, I can't get the service to start. Well, >> it starts, but then it brings up a message saying that the service >> started and then stopped, possibly because it had nothing to do. I >> tried pgAgent DEBUG but it doesn't start, it just spits out the usage >> message, which AFAICS I'm following fine. Help? > > Oh, I also ran the code in pgagent_upgrade.sql. What version did you get? Any messages in the event log? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Apr 21, 3:57 am, dp...@pgadmin.org (Dave Page) wrote: > > What version did you get? Any messages in the event log? 3.0.0, am I too bleeding edge? What's the difference between 2.0.1 and 3.0.0? If you mean the pgadmin logs, I have it on "errors only" and there was nothing.
On Tue, Apr 21, 2009 at 3:03 PM, Kevin Field <kevinjamesfield@gmail.com> wrote: > On Apr 21, 3:57 am, dp...@pgadmin.org (Dave Page) wrote: >> >> What version did you get? Any messages in the event log? > > 3.0.0, am I too bleeding edge? What's the difference between 2.0.1 > and 3.0.0? Support for executing job steps on remote databases. You can specify a connection string instead of just a database name. Also, there is improved error handling at startup and service management on Windows (hmm, that might now be until 3.0.1 though). > If you mean the pgadmin logs, I have it on "errors only" and there was > nothing. No, the Windows event log. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: > No, the Windows event log. Aha: "Couldn't create the primary connection (attempt 10): fe_sendauth: no password supplied" and nine other attempts, then finally, "Stopping pgAgent: Couldn't establish the primary connection with the database server."
On Wed, Apr 22, 2009 at 3:41 PM, Kevin Field <kevinjamesfield@gmail.com> wrote: > On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: >> No, the Windows event log. > > Aha: "Couldn't create the primary connection (attempt 10): > fe_sendauth: no password supplied" and nine other attempts, then > finally, "Stopping pgAgent: Couldn't establish the primary connection > with the database server." Create a pgpass file for your service user :-) http://www.postgresql.org/docs/8.4/static/libpq-pgpass.html -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Apr 22, 11:17 am, dp...@pgadmin.org (Dave Page) wrote: > On Wed, Apr 22, 2009 at 3:41 PM, Kevin Field <kevinjamesfi...@gmail.com> wrote: > > On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: > >> No, the Windows event log. > > > Aha: "Couldn't create the primary connection (attempt 10): > > fe_sendauth: no password supplied" and nine other attempts, then > > finally, "Stopping pgAgent: Couldn't establish the primary connection > > with the database server." > > Create a pgpass file for your service user :-) > > http://www.postgresql.org/docs/8.4/static/libpq-pgpass.html Gosh... Except now it's not starting at all, citing a logon failure, but that's odd, because it's the same pgpass file as the user I use all the time. Lemme try reinstalling and choosing the right user this time from the beginning...
On Apr 22, 11:34 am, Kevin Field <kevinjamesfi...@gmail.com> wrote: > On Apr 22, 11:17 am, dp...@pgadmin.org (Dave Page) wrote: > > > On Wed, Apr 22, 2009 at 3:41 PM, Kevin Field <kevinjamesfi...@gmail.com> wrote: > > > On Apr 21, 4:00 pm, dp...@pgadmin.org (Dave Page) wrote: > > >> No, the Windows event log. > > > > Aha: "Couldn't create the primary connection (attempt 10): > > > fe_sendauth: no password supplied" and nine other attempts, then > > > finally, "Stopping pgAgent: Couldn't establish the primary connection > > > with the database server." > > > Create a pgpass file for your service user :-) > > >http://www.postgresql.org/docs/8.4/static/libpq-pgpass.html > > Gosh... > > Except now it's not starting at all, citing a logon failure, but > that's odd, because it's the same pgpass file as the user I use all > the time. Lemme try reinstalling and choosing the right user this > time from the beginning... Oh, it's the service account password, not the pg user password. I thought I had it right because in the Services window it'll take any password and not complain, as long as the two match... Thanks for your patience and help!