Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-12 Thread John Foelster
Ø Hi John, Ø Thank you so much for your co-ordination on fixing this issue. Ø I believe, i have found the cause of this. This is due to "VALID UNTIL '1969-12-31 00:00:00';" option. For confirming this, do you mind to do the following steps once again and let me know the status. Yup. That

Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-12 Thread Dinesh Kumar
Hi John, Thank you so much for your co-ordination on fixing this issue. I believe, i have found the cause of this. This is due to "VALID UNTIL '1969-12-31 00:00:00';" option. For confirming this, do you mind to do the following steps once again and let me know the status. Create new login --

[pgadmin-support] PGAgent runs all jobs on startup

2013-08-12 Thread David Greco
I have about 20 jobs scheduled via PGAgent to run at various times. Some daily, some every X minutes, some at certain times, etc. I just started pgagent on the server and noticed it ran all my jobs upon startup, despite it not being a scheduled time. Is this an option somewhere I'm missing?

Re: [pgadmin-support] Outdated and misleading docs on vacuum

2013-08-12 Thread Dave Page
On Sat, Aug 10, 2013 at 7:49 AM, Craig Ringer wrote: > Hi > > This page: > > http://www.pgadmin.org/docs/dev/maintenance.html > > contains info so outdated that it'd be better replaced with a link to the > relevant PostgreSQL documentation. In particular, re vacuum: > > " While this tool is very h

Re: [pgadmin-support] Password setting having somewhat bizarre results.

2013-08-12 Thread John Foelster
OK. I have done a quick test in my local windows 7. 1. I have logged into PG 9.2 as a super user("postgres"). 2. Created new login role by performing right click on "Login Role" - > "Create New Login". 3. Entered the new login name and password. 4. Disconnected from pgAdmin and re-logged in the