Ø 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
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
--
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?
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
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