Thread: BUG #7781: pgagent incorrect installation
The following bug has been logged on the website:
Bug reference: 7781
Logged by: Alexander Shniperson
Email address: alex.shniperson@gmail.com
PostgreSQL version: 9.1.7
Operating system: osx lion 10.7.5
Description: =
Hi.
Just installed last PostgreSQL 9.1.7 and installed pgAgent from Application
builder, but when i run pgAdmin no Jobs at all and even more in console i
have error "com.apple.launchd: (com.edb.launchd.pgagent[55389])
posix_spawn("/Library/pgAgent/bin/pgagent", ...): No such file or directory
"
fix it please, thanks.
On Thu, Jan 3, 2013 at 8:44 AM, <alex.shniperson@gmail.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7781
> Logged by: Alexander Shniperson
> Email address: alex.shniperson@gmail.com
> PostgreSQL version: 9.1.7
> Operating system: osx lion 10.7.5
> Description:
>
> Hi.
>
> Just installed last PostgreSQL 9.1.7 and installed pgAgent from Application
> builder, but when i run pgAdmin no Jobs at all and even more in console i
> have error "com.apple.launchd: (com.edb.launchd.pgagent[55389])
> posix_spawn("/Library/pgAgent/bin/pgagent", ...): No such file or directory
> "
> fix it please, thanks.
Please try the 3.3.0 update that was just released.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Fri, Jan 4, 2013 at 3:15 PM, Aleksander Shniperson <alex.shniperson@gmail.com> wrote: > I can't do that, every time i run ApplicationBuilder i see new version 3.3.0, then i chose "next next next" and nothingchanges. > Define "nothing changes" please. Do you mean it doesn't fix the problem? It works fine for me here: raptor:server dpage$ ps -ef |grep pgagent 502 87069 1 0 3:22pm ?? 0:00.08 /Library/pgAgent/bin/pgagent -f -l1 -s /var/log/pgagent.log host=localhost port=5434 dbname=postgres user=postgres 501 87102 87078 0 3:24pm ttys004 0:00.00 grep pgagent raptor:server dpage$ sudo launchctl unload /Library/LaunchDaemons/com.edb.launchd.pgagent.plist raptor:server dpage$ ps -ef |grep pgagent 501 87108 87078 0 3:24pm ttys004 0:00.00 grep pgagent raptor:server dpage$ sudo launchctl load /Library/LaunchDaemons/com.edb.launchd.pgagent.plist raptor:server dpage$ ps -ef |grep pgagent 502 87114 1 0 3:24pm ?? 0:00.04 /Library/pgAgent/bin/pgagent -f -l1 -s /var/log/pgagent.log host=localhost port=5434 dbname=postgres user=postgres 501 87117 87078 0 3:24pm ttys004 0:00.00 grep pgagent -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Fri, Jan 4, 2013 at 3:43 PM, Aleksander Shniperson <alex.shniperson@gmail.com> wrote: > Sorry. > > It does not fix the problem. > >> /Library/pgAgent > path not exists. So where did you install it if that path doesn't exist? My suggestion would be to figure that out, then uninstall the old version before starting over with the new - e.g. sudo open /Library/pgAgent/uninstall-pgagent.app -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
"e.g." means "for example". Once you've figured out where it is installed, you should substitute the correct path into the example I gave. On Fri, Jan 4, 2013 at 4:28 PM, Aleksander Shniperson <alex.shniperson@gmail.com> wrote: > LoL > > path /Library/pgAgent does not exists, i can't run uninstall > > 04.01.2013, =D0=B2 20:18, Dave Page =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0= =D0=BB(=D0=B0): > >> On Fri, Jan 4, 2013 at 3:43 PM, Aleksander Shniperson >> <alex.shniperson@gmail.com> wrote: >>> Sorry. >>> >>> It does not fix the problem. >>> >>>> /Library/pgAgent >>> path not exists. >> >> So where did you install it if that path doesn't exist? My suggestion >> would be to figure that out, then uninstall the old version before >> starting over with the new - e.g. >> >> sudo open /Library/pgAgent/uninstall-pgagent.app >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Fri, Jan 4, 2013 at 4:35 PM, Aleksander Shniperson <alex.shniperson@gmail.com> wrote: > sudo find / -name "uninstall-pgagent.app" > > gives no result. What's in /etc/postgres-reg.ini? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
sudo find / -name "uninstall-pgagent.app" gives no result. 04.01.2013, =D7 20:30, Dave Page =CE=C1=D0=C9=D3=C1=CC(=C1): > "e.g." means "for example". Once you've figured out where it is > installed, you should substitute the correct path into the example I > gave. >=20
Sorry for late answer Here is ini-file: [PostgreSQL/9.1] Branding=3DPostgreSQL 9.1 DataDirectory=3D/Library/PostgreSQL/9.1/data Description=3DPostgreSQL 9.1 DisableStackBuilder=3D0 InstallationDirectory=3D/Library/PostgreSQL/9.1 Locale=3Dru_RU.UTF-8 Port=3D5432 Serviceaccount=3Dpostgres ServiceID=3Dpostgresql-9.1 Shortcuts=3D1 Superuser=3Dpostgres Version=3D9.1.7.1 [PostgreSQL/9.2] Branding=3D DataDirectory=3D Description=3D DisableStackBuilder=3D InstallationDirectory=3D Locale=3D Port=3D Serviceaccount=3D ServiceID=3D Shortcuts=3D Superuser=3D Version=3D [sql-profiler/PG_9.1] Description=3D InstallationDirectory=3D Version=3D [TuningWizard] Branding=3D Description=3D InstallationDirectory=3D Username=3D Version=3D [pgAgent] Description=3DpgAgent is a job scheduler for PostgreSQL which may be = managed using pgAdmin. InstallationDirectory=3D/Library/pgAgent PGDATABASE=3Dpostgres PGHOST=3Dlocalhost PGPORT=3D5432 PGUSER=3Dpostgres ServiceManager=3Dpostgres UpgradeMode=3D0 Version=3D3.2.1-1 04.01.2013, =D7 20:53, Dave Page =CE=C1=D0=C9=D3=C1=CC(=C1): > On Fri, Jan 4, 2013 at 4:35 PM, Aleksander Shniperson > <alex.shniperson@gmail.com> wrote: >> sudo find / -name "uninstall-pgagent.app" >>=20 >> gives no result. >=20 > What's in /etc/postgres-reg.ini? >=20 >=20 > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake >=20 > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company
Sorry. It does not fix the problem. > /Library/pgAgent path not exists. 04.01.2013, =D7 19:25, Dave Page =CE=C1=D0=C9=D3=C1=CC(=C1): > On Fri, Jan 4, 2013 at 3:15 PM, Aleksander Shniperson > <alex.shniperson@gmail.com> wrote: >> I can't do that, every time i run ApplicationBuilder i see new = version 3.3.0, then i chose "next next next" and nothing changes. >>=20 >=20 > Define "nothing changes" please. Do you mean it doesn't fix the > problem? It works fine for me here: >=20 > raptor:server dpage$ ps -ef |grep pgagent > 502 87069 1 0 3:22pm ?? 0:00.08 > /Library/pgAgent/bin/pgagent -f -l1 -s /var/log/pgagent.log > host=3Dlocalhost port=3D5434 dbname=3Dpostgres user=3Dpostgres > 501 87102 87078 0 3:24pm ttys004 0:00.00 grep pgagent > raptor:server dpage$ sudo launchctl unload > /Library/LaunchDaemons/com.edb.launchd.pgagent.plist > raptor:server dpage$ ps -ef |grep pgagent > 501 87108 87078 0 3:24pm ttys004 0:00.00 grep pgagent > raptor:server dpage$ sudo launchctl load > /Library/LaunchDaemons/com.edb.launchd.pgagent.plist > raptor:server dpage$ ps -ef |grep pgagent > 502 87114 1 0 3:24pm ?? 0:00.04 > /Library/pgAgent/bin/pgagent -f -l1 -s /var/log/pgagent.log > host=3Dlocalhost port=3D5434 dbname=3Dpostgres user=3Dpostgres > 501 87117 87078 0 3:24pm ttys004 0:00.00 grep pgagent >=20 >=20 > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake >=20 > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company
LoL path /Library/pgAgent does not exists, i can't run uninstall 04.01.2013, =D7 20:18, Dave Page =CE=C1=D0=C9=D3=C1=CC(=C1): > On Fri, Jan 4, 2013 at 3:43 PM, Aleksander Shniperson > <alex.shniperson@gmail.com> wrote: >> Sorry. >>=20 >> It does not fix the problem. >>=20 >>> /Library/pgAgent >> path not exists. >=20 > So where did you install it if that path doesn't exist? My suggestion > would be to figure that out, then uninstall the old version before > starting over with the new - e.g. >=20 > sudo open /Library/pgAgent/uninstall-pgagent.app >=20 > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake >=20 > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company
I can't do that, every time i run ApplicationBuilder i see new version =
3.3.0, then i chose "next next next" and nothing changes.
i try to uninstall postgresql and install it again, does not help.
any suggestion?
thanks.
04.01.2013, =D7 15:39, Dave Page =CE=C1=D0=C9=D3=C1=CC(=C1):
> On Thu, Jan 3, 2013 at 8:44 AM, <alex.shniperson@gmail.com> wrote:
>> The following bug has been logged on the website:
>>=20
>> Bug reference: 7781
>> Logged by: Alexander Shniperson
>> Email address: alex.shniperson@gmail.com
>> PostgreSQL version: 9.1.7
>> Operating system: osx lion 10.7.5
>> Description:
>>=20
>> Hi.
>>=20
>> Just installed last PostgreSQL 9.1.7 and installed pgAgent from =
Application
>> builder, but when i run pgAdmin no Jobs at all and even more in =
console i
>> have error "com.apple.launchd: (com.edb.launchd.pgagent[55389])
>> posix_spawn("/Library/pgAgent/bin/pgagent", ...): No such file or =
directory
>> "
>> fix it please, thanks.
>=20
> Please try the 3.3.0 update that was just released.
>=20
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>=20
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
The ini file clearly says that the pgAgent has been installed in /Library/pgAgent. Can you please share install-pgagent.log from your system temp (/tmp)? On Sat, Jan 5, 2013 at 7:56 PM, Aleksander Shniperson < alex.shniperson@gmail.com> wrote: > Sorry for late answer > > Here is ini-file: > [PostgreSQL/9.1] > Branding=3DPostgreSQL 9.1 > DataDirectory=3D/Library/PostgreSQL/9.1/data > Description=3DPostgreSQL 9.1 > DisableStackBuilder=3D0 > InstallationDirectory=3D/Library/PostgreSQL/9.1 > Locale=3Dru_RU.UTF-8 > Port=3D5432 > Serviceaccount=3Dpostgres > ServiceID=3Dpostgresql-9.1 > Shortcuts=3D1 > Superuser=3Dpostgres > Version=3D9.1.7.1 > > [PostgreSQL/9.2] > Branding=3D > DataDirectory=3D > Description=3D > DisableStackBuilder=3D > InstallationDirectory=3D > Locale=3D > Port=3D > Serviceaccount=3D > ServiceID=3D > Shortcuts=3D > Superuser=3D > Version=3D > > [sql-profiler/PG_9.1] > Description=3D > InstallationDirectory=3D > Version=3D > > [TuningWizard] > Branding=3D > Description=3D > InstallationDirectory=3D > Username=3D > Version=3D > > [pgAgent] > Description=3DpgAgent is a job scheduler for PostgreSQL which may be mana= ged > using pgAdmin. > InstallationDirectory=3D/Library/pgAgent > PGDATABASE=3Dpostgres > PGHOST=3Dlocalhost > PGPORT=3D5432 > PGUSER=3Dpostgres > ServiceManager=3Dpostgres > UpgradeMode=3D0 > Version=3D3.2.1-1 > > 04.01.2013, =D0=B2 20:53, Dave Page =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0= =D0=BB(=D0=B0): > > On Fri, Jan 4, 2013 at 4:35 PM, Aleksander Shniperson > <alex.shniperson@gmail.com> wrote: > > sudo find / -name "uninstall-pgagent.app" > > > gives no result. > > > What's in /etc/postgres-reg.ini? > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > > --=20 Sandeep Thakkar Senior Software Engineer EnterpriseDB Corporation The Enterprise Postgres Company Phone: +91.20.30589523 Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.
On Mon, Jan 7, 2013 at 6:47 AM, Aleksander Shniperson <alex.shniperson@gmail.com> wrote: > There is no install-pgagent.log file. > Anyway i try to "sudo find" no result. > > 07.01.2013, =D0=B2 9:19, Sandeep Thakkar =D0=BD=D0=B0=D0=BF=D0=B8=D1=81= =D0=B0=D0=BB(=D0=B0): > > The ini file clearly says that the pgAgent has been installed in > /Library/pgAgent. Can you please share install-pgagent.log from your syst= em > temp (/tmp)? > >> [pgAgent] >> Description=3DpgAgent is a job scheduler for PostgreSQL which may be man= aged >> using pgAdmin. >> InstallationDirectory=3D/Library/pgAgent >> PGDATABASE=3Dpostgres >> PGHOST=3Dlocalhost >> PGPORT=3D5432 >> PGUSER=3Dpostgres >> ServiceManager=3Dpostgres >> UpgradeMode=3D0 >> Version=3D3.2.1-1 Sandeep is correct - it looks very much like the original installation has been manually, but partially removed. I would remove the pgAgent section from /etc/postgres-reg.ini, and try installing 3.3.0 again. That will make the installer run in installation mode instead of upgrade mode. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
There is no install-pgagent.log file. Anyway i try to "sudo find" no result. 07.01.2013, =D7 9:19, Sandeep Thakkar =CE=C1=D0=C9=D3=C1=CC(=C1): > The ini file clearly says that the pgAgent has been installed in = /Library/pgAgent. Can you please share install-pgagent.log from your = system temp (/tmp)? >=20 > On Sat, Jan 5, 2013 at 7:56 PM, Aleksander Shniperson = <alex.shniperson@gmail.com> wrote: > Sorry for late answer >=20 > Here is ini-file: > [PostgreSQL/9.1] > Branding=3DPostgreSQL 9.1 > DataDirectory=3D/Library/PostgreSQL/9.1/data > Description=3DPostgreSQL 9.1 > DisableStackBuilder=3D0 > InstallationDirectory=3D/Library/PostgreSQL/9.1 > Locale=3Dru_RU.UTF-8 > Port=3D5432 > Serviceaccount=3Dpostgres > ServiceID=3Dpostgresql-9.1 > Shortcuts=3D1 > Superuser=3Dpostgres > Version=3D9.1.7.1 >=20 > [PostgreSQL/9.2] > Branding=3D > DataDirectory=3D > Description=3D > DisableStackBuilder=3D > InstallationDirectory=3D > Locale=3D > Port=3D > Serviceaccount=3D > ServiceID=3D > Shortcuts=3D > Superuser=3D > Version=3D >=20 > [sql-profiler/PG_9.1] > Description=3D > InstallationDirectory=3D > Version=3D >=20 > [TuningWizard] > Branding=3D > Description=3D > InstallationDirectory=3D > Username=3D > Version=3D >=20 > [pgAgent] > Description=3DpgAgent is a job scheduler for PostgreSQL which may be = managed using pgAdmin. > InstallationDirectory=3D/Library/pgAgent > PGDATABASE=3Dpostgres > PGHOST=3Dlocalhost > PGPORT=3D5432 > PGUSER=3Dpostgres > ServiceManager=3Dpostgres > UpgradeMode=3D0 > Version=3D3.2.1-1 >=20 > 04.01.2013, =D7 20:53, Dave Page =CE=C1=D0=C9=D3=C1=CC(=C1): >=20 >> On Fri, Jan 4, 2013 at 4:35 PM, Aleksander Shniperson >> <alex.shniperson@gmail.com> wrote: >>> sudo find / -name "uninstall-pgagent.app" >>>=20 >>> gives no result. >>=20 >> What's in /etc/postgres-reg.ini? >>=20 >>=20 >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >>=20 >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >=20 >=20 >=20 >=20 > --=20 > Sandeep Thakkar > Senior Software Engineer > EnterpriseDB Corporation > The Enterprise Postgres Company > Phone: +91.20.30589523 >=20 > Website: www.enterprisedb.com > EnterpriseDB Blog: http://blogs.enterprisedb.com/ > Follow us on Twitter: http://www.twitter.com/enterprisedb >=20 > This e-mail message (and any attachment) is intended for the use of = the individual or entity to whom it is addressed. This message contains = information from EnterpriseDB Corporation that may be privileged, = confidential, or exempt from disclosure under applicable law. If you are = not the intended recipient or authorized to receive this for the = intended recipient, any use, dissemination, distribution, retention, = archiving, or copying of this communication is strictly prohibited. If = you have received this e-mail in error, please notify the sender = immediately by reply e-mail and delete this message.
Looks like worked, thanks! have a nice day. 07.01.2013, =D7 13:43, Dave Page =CE=C1=D0=C9=D3=C1=CC(=C1): > On Mon, Jan 7, 2013 at 6:47 AM, Aleksander Shniperson > <alex.shniperson@gmail.com> wrote: >> There is no install-pgagent.log file. >> Anyway i try to "sudo find" no result. >>=20 >> 07.01.2013, =D7 9:19, Sandeep Thakkar =CE=C1=D0=C9=D3=C1=CC(=C1): >>=20 >> The ini file clearly says that the pgAgent has been installed in >> /Library/pgAgent. Can you please share install-pgagent.log from your = system >> temp (/tmp)? >>=20 >>> [pgAgent] >>> Description=3DpgAgent is a job scheduler for PostgreSQL which may be = managed >>> using pgAdmin. >>> InstallationDirectory=3D/Library/pgAgent >>> PGDATABASE=3Dpostgres >>> PGHOST=3Dlocalhost >>> PGPORT=3D5432 >>> PGUSER=3Dpostgres >>> ServiceManager=3Dpostgres >>> UpgradeMode=3D0 >>> Version=3D3.2.1-1 >=20 > Sandeep is correct - it looks very much like the original installation > has been manually, but partially removed. I would remove the pgAgent > section from /etc/postgres-reg.ini, and try installing 3.3.0 again. > That will make the installer run in installation mode instead of > upgrade mode. >=20 > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake >=20 > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company