Re: BUG #7781: pgagent incorrect installation

The following bug has been logged on the website:

Bug reference: 7781
Logged by: Alexander Shniperson
Email address: alex(dot)shniperson(at)gmail(dot)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(dot)shniperson(at)gmail(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7781
> Logged by: Alexander Shniperson
> Email address: alex(dot)shniperson(at)gmail(dot)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

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, в 15:39, Dave Page написал(а):

> On Thu, Jan 3, 2013 at 8:44 AM, <alex(dot)shniperson(at)gmail(dot)com> wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 7781
>> Logged by: Alexander Shniperson
>> Email address: alex(dot)shniperson(at)gmail(dot)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(dot)shniperson(at)gmail(dot)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.
>

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

Sorry.

It does not fix the problem.

> /Library/pgAgent
path not exists.

04.01.2013, в 19:25, Dave Page написал(а):

> On Fri, Jan 4, 2013 at 3:15 PM, Aleksander Shniperson
> <alex(dot)shniperson(at)gmail(dot)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.
>>
>
> 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(dot)shniperson(at)gmail(dot)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

LoL

path /Library/pgAgent does not exists, i can't run uninstall

04.01.2013, в 20:18, Dave Page написал(а):

> On Fri, Jan 4, 2013 at 3:43 PM, Aleksander Shniperson
> <alex(dot)shniperson(at)gmail(dot)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(dot)shniperson(at)gmail(dot)com> wrote:
> LoL
>
> path /Library/pgAgent does not exists, i can't run uninstall
>
> 04.01.2013, в 20:18, Dave Page написал(а):
>
>> On Fri, Jan 4, 2013 at 3:43 PM, Aleksander Shniperson
>> <alex(dot)shniperson(at)gmail(dot)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

sudo find / -name "uninstall-pgagent.app"

gives no result.

04.01.2013, в 20:30, Dave Page написал(а):

> "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:35 PM, Aleksander Shniperson
<alex(dot)shniperson(at)gmail(dot)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

Sorry for late answer

Here is ini-file:
[PostgreSQL/9.1]
Branding=PostgreSQL 9.1
DataDirectory=/Library/PostgreSQL/9.1/data
Description=PostgreSQL 9.1
DisableStackBuilder=0
InstallationDirectory=/Library/PostgreSQL/9.1
Locale=ru_RU.UTF-8
Port=5432
Serviceaccount=postgres
ServiceID=postgresql-9.1
Shortcuts=1
Superuser=postgres
Version=9.1.7.1

[PostgreSQL/9.2]
Branding=
DataDirectory=
Description=
DisableStackBuilder=
InstallationDirectory=
Locale=
Port=
Serviceaccount=
ServiceID=
Shortcuts=
Superuser=
Version=

[sql-profiler/PG_9.1]
Description=
InstallationDirectory=
Version=

[TuningWizard]
Branding=
Description=
InstallationDirectory=
Username=
Version=

[pgAgent]
Description=pgAgent is a job scheduler for PostgreSQL which may be managed using pgAdmin.
InstallationDirectory=/Library/pgAgent
PGDATABASE=postgres
PGHOST=localhost
PGPORT=5432
PGUSER=postgres
ServiceManager=postgres
UpgradeMode=0
Version=3.2.1-1

04.01.2013, в 20:53, Dave Page написал(а):

> On Fri, Jan 4, 2013 at 4:35 PM, Aleksander Shniperson
> <alex(dot)shniperson(at)gmail(dot)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

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(dot)shniperson(at)gmail(dot)com> wrote:

> Sorry for late answer
>
> Here is ini-file:
> [PostgreSQL/9.1]
> Branding=PostgreSQL 9.1
> DataDirectory=/Library/PostgreSQL/9.1/data
> Description=PostgreSQL 9.1
> DisableStackBuilder=0
> InstallationDirectory=/Library/PostgreSQL/9.1
> Locale=ru_RU.UTF-8
> Port=5432
> Serviceaccount=postgres
> ServiceID=postgresql-9.1
> Shortcuts=1
> Superuser=postgres
> Version=9.1.7.1
>
> [PostgreSQL/9.2]
> Branding=
> DataDirectory=
> Description=
> DisableStackBuilder=
> InstallationDirectory=
> Locale=
> Port=
> Serviceaccount=
> ServiceID=
> Shortcuts=
> Superuser=
> Version=
>
> [sql-profiler/PG_9.1]
> Description=
> InstallationDirectory=
> Version=
>
> [TuningWizard]
> Branding=
> Description=
> InstallationDirectory=
> Username=
> Version=
>
> [pgAgent]
> Description=pgAgent is a job scheduler for PostgreSQL which may be managed
> using pgAdmin.
> InstallationDirectory=/Library/pgAgent
> PGDATABASE=postgres
> PGHOST=localhost
> PGPORT=5432
> PGUSER=postgres
> ServiceManager=postgres
> UpgradeMode=0
> Version=3.2.1-1
>
> 04.01.2013, в 20:53, Dave Page написал(а):
>
> On Fri, Jan 4, 2013 at 4:35 PM, Aleksander Shniperson
> <alex(dot)shniperson(at)gmail(dot)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
>
>
>

--
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.

There is no install-pgagent.log file.
Anyway i try to "sudo find" no result.

07.01.2013, в 9:19, Sandeep Thakkar написал(а):

> 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(dot)shniperson(at)gmail(dot)com> wrote:
> Sorry for late answer
>
> Here is ini-file:
> [PostgreSQL/9.1]
> Branding=PostgreSQL 9.1
> DataDirectory=/Library/PostgreSQL/9.1/data
> Description=PostgreSQL 9.1
> DisableStackBuilder=0
> InstallationDirectory=/Library/PostgreSQL/9.1
> Locale=ru_RU.UTF-8
> Port=5432
> Serviceaccount=postgres
> ServiceID=postgresql-9.1
> Shortcuts=1
> Superuser=postgres
> Version=9.1.7.1
>
> [PostgreSQL/9.2]
> Branding=
> DataDirectory=
> Description=
> DisableStackBuilder=
> InstallationDirectory=
> Locale=
> Port=
> Serviceaccount=
> ServiceID=
> Shortcuts=
> Superuser=
> Version=
>
> [sql-profiler/PG_9.1]
> Description=
> InstallationDirectory=
> Version=
>
> [TuningWizard]
> Branding=
> Description=
> InstallationDirectory=
> Username=
> Version=
>
> [pgAgent]
> Description=pgAgent is a job scheduler for PostgreSQL which may be managed using pgAdmin.
> InstallationDirectory=/Library/pgAgent
> PGDATABASE=postgres
> PGHOST=localhost
> PGPORT=5432
> PGUSER=postgres
> ServiceManager=postgres
> UpgradeMode=0
> Version=3.2.1-1
>
> 04.01.2013, в 20:53, Dave Page написал(а):
>
>> On Fri, Jan 4, 2013 at 4:35 PM, Aleksander Shniperson
>> <alex(dot)shniperson(at)gmail(dot)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
>
>
>
>
> --
> 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(dot)shniperson(at)gmail(dot)com> wrote:
> There is no install-pgagent.log file.
> Anyway i try to "sudo find" no result.
>
> 07.01.2013, в 9:19, Sandeep Thakkar написал(а):
>
> 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)?
>
>> [pgAgent]
>> Description=pgAgent is a job scheduler for PostgreSQL which may be managed
>> using pgAdmin.
>> InstallationDirectory=/Library/pgAgent
>> PGDATABASE=postgres
>> PGHOST=localhost
>> PGPORT=5432
>> PGUSER=postgres
>> ServiceManager=postgres
>> UpgradeMode=0
>> Version=3.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

Looks like worked, thanks!

have a nice day.

07.01.2013, в 13:43, Dave Page написал(а):

> On Mon, Jan 7, 2013 at 6:47 AM, Aleksander Shniperson
> <alex(dot)shniperson(at)gmail(dot)com> wrote:
>> There is no install-pgagent.log file.
>> Anyway i try to "sudo find" no result.
>>
>> 07.01.2013, в 9:19, Sandeep Thakkar написал(а):
>>
>> 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)?
>>
>>> [pgAgent]
>>> Description=pgAgent is a job scheduler for PostgreSQL which may be managed
>>> using pgAdmin.
>>> InstallationDirectory=/Library/pgAgent
>>> PGDATABASE=postgres
>>> PGHOST=localhost
>>> PGPORT=5432
>>> PGUSER=postgres
>>> ServiceManager=postgres
>>> UpgradeMode=0
>>> Version=3.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