[pgadmin-support] running jobs on a distant machine
Hello
I have installed postgresql on a machine (lets call it A), in order to run jobs
In that machine all is right, i lunch pgadmin, install the service, and i could
run the jobs
My problem is when i wanted to execute jobs in a distant machine, lets call it B
So I have installed pgadmin, install the service as : "c:/program files/pgadmin
III/1.8/ pgAgent INSTALL pgAgent -u user -p password hostaddr=127.0.0.1
dbname=postgres user=postgres"
In the machine A which contains the base i created a job. This job is supposed
to execute a script in the machine B.
So i put the path of this script in Defenition ("C:\test.bat"), and i Put the
IP of the machine B in the field Host Agent
But That did not work.
I am using 2 windows, No pb of connection since i can see and open the jobs
database from the pgadmin of the machine B
I am using Pgadmin 1.8.4 In Machine A and 1.8.3 in B
Thank you for help
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] running jobs on a distant machine
On Tue, Jan 6, 2009 at 9:23 AM, houssem jemel wrote:
> Hello
>
> I have installed postgresql on a machine (lets call it A), in order to run
> jobs
> In that machine all is right, i lunch pgadmin, install the service, and i
> could run the jobs
> My problem is when i wanted to execute jobs in a distant machine, lets call
> it B
> So I have installed pgadmin, install the service as : "c:/program
> files/pgadmin III/1.8/ pgAgent INSTALL pgAgent -u user -p password
> hostaddr=127.0.0.1 dbname=postgres user=postgres"
> In the machine A which contains the base i created a job. This job is
> supposed to execute a script in the machine B.
> So i put the path of this script in Defenition ("C:\test.bat"), and i Put the
> IP of the machine B in the field Host Agent
> But That did not work.
The Host Agent field needs a hostname, not an IP address. With pgAgent
running on machine B, run the following query on machine A in the
database containing the pgAgent schema:
select jagstation from pgagent.pga_jobagent;
That will show you the hostnames of each agent as pgAgent sees them.
Use the appropriate one in the host agent field.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] Import: how to display warnning & error message
Hi, all I got a free license of DialogBlocks to design UI. Thank Julian Smart and his company: Anthemion Software Ltd. Question: In import wizard, it is needed to display messages. 1. How to add status bar to wxWizard? Like other UI, put wxStatusBar at the bottom of window. I had tried to put wxWizard and wxStatusBar to wxPanel, but it can't work properly. 2. Add a status bar to wxWizardPage? The UI will get bad look and can't follow common style. 3. Use wxMessageBox? The end user will suffer from lots of message dialog. Can someone give me a suggestion and a solution? --- Quan Zongliang quanzongli...@gmail.com CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Import: how to display warnning & error message
Sorry, my fault. It should be sent to hackers mailing-list. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re : Re : [pgadmin-support] running jobs on a distant machine
Yes i changed the hostaddr to thi IP of B, i got then the entrie of B The job on B is now runninig Thank you for Help - Message d'origine De : Dave Page À : houssem jemel Envoyé le : Mardi, 6 Janvier 2009, 12h16mn 01s Objet : Re: Re : [pgadmin-support] running jobs on a distant machine [Please keep replies on-list] On Tue, Jan 6, 2009 at 11:07 AM, houssem jemel wrote: > the command show only one entrie wihch is of the machine A > Also i tried to do a telnet on 5432 from A to B but failed, is it normal > can you also verify the command i put in B > c:/program files/pgadmin III/1.8/ pgAgent INSTALL pgAgent -u user -p password > hostaddr=127.0.0.1 dbname=postgres user=postgres > in service pgAgent is marked started Shouldn't hostaddr= have the address of machine A, and not the loopback address? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re : Re : Re : [pgadmin-support] running jobs on a distant machine
sorry i wanted to say: i changed the hostaddr to thi IP of A not B - Message d'origine De : houssem jemel À : Dave Page Cc : pgadmin-support@postgresql.org Envoyé le : Mardi, 6 Janvier 2009, 15h02mn 02s Objet : Re : Re : [pgadmin-support] running jobs on a distant machine Yes i changed the hostaddr to thi IP of B, i got then the entrie of B The job on B is now runninig Thank you for Help - Message d'origine De : Dave Page À : houssem jemel Envoyé le : Mardi, 6 Janvier 2009, 12h16mn 01s Objet : Re: Re : [pgadmin-support] running jobs on a distant machine [Please keep replies on-list] On Tue, Jan 6, 2009 at 11:07 AM, houssem jemel wrote: > the command show only one entrie wihch is of the machine A > Also i tried to do a telnet on 5432 from A to B but failed, is it normal > can you also verify the command i put in B > c:/program files/pgadmin III/1.8/ pgAgent INSTALL pgAgent -u user -p password > hostaddr=127.0.0.1 dbname=postgres user=postgres > in service pgAgent is marked started Shouldn't hostaddr= have the address of machine A, and not the loopback address? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] CLUSTER info
Is there a place in pg-admin that shows what index (if any) a table is clustered on? If not, could it be added? Mike -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] CLUSTER info
Mike Blackwell a écrit : > Is there a place in pg-admin that shows what index (if any) a table is > clustered on? If not, could it be added? > I don't think this kind of info are available on the table. But they are on the Index properties. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
