> On Sat, Jun 28, 2008 at 1:54 PM, Guillaume Lelarge
> > Nothing is really simple on pgAdmin's coding (says the guy who tries
> hardly
> > to compile it under Windows since last evening... grmbl... :) ).
>
> That shouldn't be hard - what was the problem?
You really think so? Getting pgAdmin to
Our naming standard here is first_name.last_name so my username at work
is jon.roberts. When I look at the DDL script created by pgAdmin, it
doesn't format my name properly for the grants. It does format it
properly for the owner.
Example:
-- Table: jon.part_test
-- DROP TABLE jon.part_test;
> On Sun, Apr 20, 2008 at 6:00 PM, Dave Page <[EMAIL PROTECTED]> wrote:
> > On Fri, Apr 18, 2008 at 7:30 PM, Roberts, Jon
<[EMAIL PROTECTED]>
> wrote:
> >
> > I'm awaiting confirmation from the lead architect, but I believe
that
> > a single connect
With pgAdmin, every window is a new connection to the database and this
alone wastes resources when you have lots of users.
select count(distinct usename) as unique_users,
count(*) as total_count,
count(*)/cast(count(distinct usename) as float8)
from pg_stat_activity;
For our s
hey are in. It would take more
changes to the SQL code but I think it would be doable and add more
flexibility.
Jon
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 27, 2008 3:14 AM
> To: Roberts, Jon
> Cc: pgadmin-hackers; Lucas
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 26, 2008 4:14 PM
> To: Roberts, Jon; pgadmin-hackers
> Cc: Lucas, Craig
> Subject: Re: FW: [pgadmin-hackers] pgAgent job limit
>
> Jon,
>
> I'm pretty busy at
In pgAgent.cpp, I would like to add LIMIT as shown below:
LogMessage(_("Checking for jobs to run"), LOG_DEBUG);
DBresult *res=serviceConn->Execute(
wxT("SELECT J.jobid ")
wxT(" FROM pgagent.pga_job J ")
wxT(" WHERE jobenabled ")
wxT(" AND jobagentid IS NULL ")
wxT(" AND jobnextrun <= now
When I view the permissions of a schema or table, I noticed that the icon
for an existing grant to a group role shows a single user icon. If I grant
usage to a group role, the icon that is created shows multiple little
people. Commit these changes, close the window, and open it again. Now the
ic
I'm not sure if I should ask this here or the general group but I'll start
here.
I need to limit the number of concurrent running jobs using pgAgent to a
value from a table.
Thoughts:
1. Setting on pgAgent itself to limit the number of concurrent jobs but I
don't see an option for this.
2. Ha
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 10, 2007 10:11 AM
> To: Roberts, Jon
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] Number of connections
>
> Roberts, Jon wrote:
> > I mean this:
> &
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 10, 2007 9:42 AM
> To: Roberts, Jon
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] Number of connections
>
> Roberts, Jon wrote:
> > I would think far less co
> -Original Message-
> From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] On Behalf Of Heikki
> Linnakangas
> Sent: Monday, December 10, 2007 9:12 AM
> To: Roberts, Jon
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] Number of connections
>
> Roberts,
I've noticed that when using pgAdmin, each user will have multiple
connections to the database. We actually observe three connections for each
user which seem to be:
1. pgAdmin UI
2. Maintenance database
3. Query Window
Then for each Query Window, there is another connection created. So if a
fun" in
Linux. Shouldn't there be an easier way to get this installed? A single
tar.gz file that I extract and then I get pgAgent would be ideal.
Jon
> -Original Message-
> From: Roberts, Jon [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 07, 2007 9:40 AM
>
Are there directions on how to install just pgAgent without installing
pgAdmin? Is there a simple download and installation for pgAdmin for my
version of Linux?
Jon
---(end of broadcast)---
TIP 5: don't forget to increase your free space map s
> Roberts, Jon wrote:
> > There are three problems with having a custom connection string for each
> > step. 1) If I need to update the connection like change the password, I
> > have to do it for each step. 2) Developers will see the password in
> clear
> &g
>
> > However, to make pgAgent and pgAdmin work better with my solution, it
> would
> > be nice to have an enhancement. The enhancement could also benefit
> others
> > wanting to separate the database server where jobs are maintained from
> the
> > target server(s) where sql should be executed.
>
additional screen to define the servers too.
Is there much demand for allowing a SQL job step to be executed on a remote
server and database?
Jon
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 29, 2007 8:53 AM
> To: Roberts, Jon
>
In job.cpp, it has this code to get the next job step:
DBresult *steps=threadConn->Execute(
wxT("SELECT jstid, jstkind, jstdbname, jstcode, jstonerror ")
wxT(" FROM pgagent.pga_jobstep ")
wxT(" WHERE jstenabled ")
wxT(" AND jstjobid=") + jobid +
wxT("
I am using pgAdmin with Greenplum and generally, it works very well. It
doesn't show the distribution of tables but that isn't a big deal.
I now need a scheduling solution and pgAgent is the natural choice. I first
reviewed this and saw that the query that is launched by pgAdmin contains a
corre
20 matches
Mail list logo
