BUG #7781: pgagent incorrect installation

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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.

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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 написал(а):

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

--
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 написал(а):

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, в 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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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.shniperson@gmail.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs