[ADMIN] Postgres TimeZone

2011-04-29 Thread Anibal David Acosta
Hello, I have a postgres installed on a Windows server machine. In my country we have daylight saving so my windows OS is configured to automatically change timezone but the postgres only reload the new timezone after restart. Is possible to kept the Postgres in sync with the windows time (time a

[ADMIN] pgcrypto pgp_pub_decrypt with passphrase broken

2011-04-29 Thread Ron Peterson
AFAIKT, pgp_pub_decrypt is broken if you protect your private key with a passphrase. e.g. works: pgp_pub_decrypt( pgp_pub_encrypt( 'secret', dearmor(pubkey) ), dearmor(privkey) ) fails: pgp_pub_decrypt( pgp_pub_encrypt( 'secret', dearmor(pubkey) ), dearmor(privk