Re: [pgadmin-support] pgAgent setup
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paolo SaudinSent: 24 October 2005 19:02To: pgadmin-support@postgresql.orgSubject: [pgadmin-support] pgAgent setup Hi, I've installed the latest PostgreSQL release, 8.1-beta4 with default settings.I installed the 'pgagent.sql' script and the service with the following command :pgAgent INSTALL pgAgent -u postgres -p postmaster hostaddr=127.0.0.1 dbname=postgres user=postgres windows user (created during the installation process) user= postgres password = postmaster postgresql user user=postgres password=postgres I run the service with no errors. I then created a job to fill a table with the current date and time as follow but it never run and the statistics are empty. When refreshing, the Next run field does not change job1Name job1EnabledYesHost agent localhostJob class Routine maintenanceCreated 24/10/2005 18.44.49Changed 24/10/2005 18.44.49Next run 24/10/2005 19.19.00Last runLast result UnknownRunning at Not currently running I suspect the problem is that your host agent is not actually localhost - pgAgent uses the wxGetFullHostName (http://wxwidgets.org/manuals/2.6.2/wx_networkfunctions.html#wxgetfullhostname) function which returns the fully qualified domain host name of the machine it's running on. In my case that might be pc30.vale-housing.co.uk for example. Unless you are running multiple agents and need to target jobs at specific ones, it's normally safe to leave this field blank which means that any agent can run the job. Regards, Dave
Re: [pgadmin-support] [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing
Hi Dave, On Oct 20, 2005, at 3:47 AM, Dave Page wrote: Beta 3 of pgAdmin 1.4.0, the graphical PostgreSQL administration tool for Windows, Linux, FreeBSD and Solaris is now available for download from http://www.postgresql.org/ftp/pgadmin3/beta/ Is there a reason you don't mention OS X? From previous announcements I thought it was not ready for beta testing since it was not listed. But I made my lazy self check today and found that there is a OS X beta version. And wow, I'm very impressed with with the overall visual appearance. Much improved. Now you just need to get the OK/ Cancel buttons in the right order for Mac users :). A few issues I noticed: Data browser does not honor the maximum number of rows setting. I set mine to 1000 and loads every row in the table. In the documentation viewer I went to some web page links and get lots of "No handler for image type" errors. Example: http://people.planetpostgresql.org/dpage/index.php?/archives/2- Support-rant-Dave-goes-off-on-one!!!.html - Password can be stored in .pgass/pgpass.conf files Is this supposed to work for connecting to the server in the main window. My server is on localhost:5432 and I had the entry below in my .pgpass but it still prompted me for the password. But it is very nice the password prompt window now allows me to save the password. Where are they stored? localhost:5432:*:user:pass Great job on the new version. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing
> -Original Message- > From: John DeSoi [mailto:[EMAIL PROTECTED] > Sent: 25 October 2005 13:43 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing > > Hi Dave, Hi John, > On Oct 20, 2005, at 3:47 AM, Dave Page wrote: > > > Beta 3 of pgAdmin 1.4.0, the graphical PostgreSQL > administration tool > > for Windows, Linux, FreeBSD and Solaris is now available > for download > > from http://www.postgresql.org/ftp/pgadmin3/beta/ > > > Is there a reason you don't mention OS X? From previous > announcements Pure oversight :-( > I thought it was not ready for beta testing since it was not listed. > But I made my lazy self check today and found that there is a OS X > beta version. And wow, I'm very impressed with with the overall > visual appearance. Much improved. Now you just need to get the OK/ > Cancel buttons in the right order for Mac users :). Thanks :-). I'll look at reversing the OK/Cancel buttons sometime. I just got hold of a Mac myself, so I'm working on improving these things. > A few issues I noticed: > > Data browser does not honor the maximum number of rows > setting. I set > mine to 1000 and loads every row in the table. Actually it never did - that option is only used by the SQL Tool. I'll improve the documentation about that. > In the documentation viewer I went to some web page links and get > lots of "No handler for image type" errors. Example: > > http://people.planetpostgresql.org/dpage/index.php?/archives/2- > Support-rant-Dave-goes-off-on-one!!!.html Hmm, I wonder if it doesn't like the png images at the bottom. I'll look at that. > > - Password can be stored in .pgass/pgpass.conf files > > Is this supposed to work for connecting to the server in the main > window. My server is on localhost:5432 and I had the entry below in > my .pgpass but it still prompted me for the password. But it is very > nice the password prompt window now allows me to save the password. > Where are they stored? > > localhost:5432:*:user:pass It stores it in .pgpass, or at least it's supposed to. It's not beyond the realms of possibility that it's not picking up the home directory corectly on OS X - certainly it didn't as far as logfiles were concerned at one point. I'll look at this as well. > Great job on the new version. Thanks :-) Regards, Dave. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-support] [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing
Hi Dave, On Oct 25, 2005, at 9:16 AM, Dave Page wrote: It stores it in .pgpass, or at least it's supposed to. It's not beyond the realms of possibility that it's not picking up the home directory corectly on OS X - certainly it didn't as far as logfiles were concerned at one point. I'll look at this as well. If it uses .pgpass and it works after prompting me the first time, maybe the issue is that it does not look for password unless the "store password" property is set for the server. It works now and my .pgpass is not modified. Thanks, John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-support] [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing
> -Original Message- > From: John DeSoi [mailto:[EMAIL PROTECTED] > Sent: 25 October 2005 15:10 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released for testing > > Hi Dave, > > On Oct 25, 2005, at 9:16 AM, Dave Page wrote: > > > It stores it in .pgpass, or at least it's supposed to. It's > not beyond > > the realms of possibility that it's not picking up the home > directory > > corectly on OS X - certainly it didn't as far as logfiles were > > concerned > > at one point. I'll look at this as well. > > If it uses .pgpass and it works after prompting me the first time, > maybe the issue is that it does not look for password unless the > "store password" property is set for the server. It works now and > my .pgpass is not modified. Yes, upon a shufty of the code I can see that is what it's doing. Once it's saved/found the password, it marks the connection as having a stored password and doesn't bother asking for it from then on. Regards, Dave. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] [ANNOUNCE] pgAdmin III v1.4.0 Beta 3 released
Dave Page wrote: If it uses .pgpass and it works after prompting me the first time, maybe the issue is that it does not look for password unless the "store password" property is set for the server. It works now and my .pgpass is not modified. Yes, upon a shufty of the code I can see that is what it's doing. Once it's saved/found the password, it marks the connection as having a stored password and doesn't bother asking for it from then on. Right. Let's keep this undocumented, to insure a constant stream of questions :-) Regards, Andreas ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-support] 1.4 Beta-3 crashes when opening a trigger's property-dialog
pgAdmin III 1.4 Beta-3 crashes when opening a trigger's property-dialog from either the popup menu or the shortcut button or the Edit menu. Client: Windows XP Pro, SP2. pgAdmin III language: English Server: Debian linux postgreSQL 8.0 pgAdmin III v1.22 opens the same triggers fine. debug-log says: ### QUOTE BEGINS 2005-10-25 17:16:10 INFO : Displaying properties for Table tg_mytable_ar5iu 2005-10-25 17:16:10 STATUS : Retrieving Table details... 2005-10-25 17:16:10 QUERY : Set query (myserver:5432): SELECT pr.oid, pr.*, TYP.typname, TYPNS.nspname AS typnsp, lanname, proargnames, pg_get_userbyid(proowner) as funcowner, description FROM pg_proc pr JOIN pg_type TYP ON TYP.oid=prorettype JOIN pg_namespace TYPNS ON TYPNS.oid=TYP.typnamespace JOIN pg_language LNG ON LNG.oid=prolang LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid WHERE pr.oid=50783866::oid ORDER BY proname 2005-10-25 17:16:10 INFO : Creating pgSetBase object 2005-10-25 17:16:10 QUERY : Set query (myserver:5432): SELECT t.oid, t.typname, n.nspname FROM pg_type t, pg_namespace n WHERE t.typnamespace = n.oid 2005-10-25 17:16:10 INFO : Creating pgSetBase object 2005-10-25 17:16:10 INFO : Creating a pgFunction object 2005-10-25 17:16:10 INFO : Destroying pgSetBase object 2005-10-25 17:16:10 INFO : Destroying pgSetBase object 2005-10-25 17:16:10 STATUS : Retrieving Table details... (0.02 secs) 2005-10-25 17:16:33 INFO : Creating a ctlSQLBox 2005-10-25 17:16:33 QUERY : Set query (myserver:5432): SELECT groname FROM pg_group ORDER BY groname 2005-10-25 17:16:33 INFO : Creating pgSetBase object 2005-10-25 17:16:33 INFO : Destroying pgSetBase object 2005-10-25 17:16:33 QUERY : Set query (myserver:5432): SELECT usename FROM pg_user ORDER BY usename 2005-10-25 17:16:33 INFO : Creating pgSetBase object 2005-10-25 17:16:33 QUERY : Set query (myserver:5432): SELECT spcname FROM pg_tablespace WHERE spcname <> 'global' ORDER BY spcname 2005-10-25 17:16:33 INFO : Creating pgSetBase object ### QUOTE ENDS (This is the end of the log file.) Regards, dueyduey ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-support] The server lacks instrumentation functions, PgAdmin 1.4 beta2
Hi, PGAdmin display "The server lacks instrumentation functions" when opening server status. I got rid of that message by manually executing admin81.sql in database "postgres". Is this the intended behavior? I am on Windows XP Service Pack 2. I've installed PostgreSQL 8.1 beta3 with the Windows installer which installed pgAdmin 1.4 beta2. I didn't run initdb manually, the cluster was initialized by the Windows installer. Thanks, Jean-Pierre Pelletier e-djuster ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
