Re: [ADMIN] password problems

2011-10-07 Thread Craig Ringer
On 10/07/2011 10:14 PM, Alexander James Spence [axs] wrote: We have updated our server to 9.1 the previous version used am external file for authentication (unix crypt) PostgreSQL's basic auth scheme hasn't changed in a long time, so it's pretty unlikely that the previous version inherently u

[ADMIN] password problems

2011-10-07 Thread Alexander James Spence [axs]
Hi All, We have updated our server to 9.1 the previous version used am external file for authentication (unix crypt), questions: Can I continue to use this file if so how is it referenced in pg_hba.conf? If I want to continue to use unix crypt passwords how do I get them into the database. I

Re: [ADMIN] Some Postgresql Concepts

2011-10-07 Thread Craig Ringer
On 10/07/2011 02:12 PM, Karuna Karpe wrote: 1. Flashback fundamental Flashback? I think you might be confusing this: http://oracle.com/ with this: http://postgresql.org/ 2. Compression, encryption and decryption Check out TOAST and pgcrypto in the *MANUAL*. http://lmgtfy.com/?q=p

[ADMIN] Standby server witching into master role after import failure

2011-10-07 Thread Frank Lanitz
Hi folks, I've got an issue I'm currently investigating and I'm not 100 sure about the root cause. The setup is pretty easy: A standby server via PITR is importing WAL-files from master server. During this import it appears there has been an error which cause the standby to finish the importing an