Re: [ADMIN] exceeded MAX_ALLOCATED_DESCS while trying to open file

2013-05-31 Thread Tom Lane
Alvaro Herrera writes: > k...@rice.edu wrote: >> Each SELECT opens your FOREIGN TABLE so you are opening it 10 times. This is >> hardcoded by a #define in ./src/backend/storage/file/fd.c during the build so >> you would need to recompile the software yourself to change it. Can you re- >> write you

Re: [ADMIN] 8.4 to 9.1 Upgrade Kerberos Auth Stops Working "Wrong principal in request"

2013-05-31 Thread Josh Tanski
On 5/31/2013 8:46 AM, Stephen Frost wrote: That key type (des-cbc-md5) has looonn been deprecated and has been actively disabled and disallowed from use in modern Kerberos libraries. Please go get an AES256 key and install that instead. Thanks - that was one of my fears - I j

Re: [ADMIN] 8.4 to 9.1 Upgrade Kerberos Auth Stops Working "Wrong principal in request"

2013-05-31 Thread Stephen Frost
Josh, That key type (des-cbc-md5) has looonn been deprecated and has been actively disabled and disallowed from use in modern Kerberos libraries. Please go get an AES256 key and install that instead. Thanks, Stephen * Josh Tanski (morto...@rochester.rr.com)

[ADMIN] 8.4 to 9.1 Upgrade Kerberos Auth Stops Working "Wrong principal in request"

2013-05-31 Thread Josh Tanski
I have Kerberos Authentication working for PostgreSQL 8.4 on Debian Squeeze, against a Windows 2000 Server Domain. I tried upgrading some test servers to Debian Wheezy which upgrades PostgreSQL to 9.1, but Kerberos authentication breaks with the "Wrong principal in request" error. These serve

Re: [ADMIN] Migration and snapshot of database

2013-05-31 Thread Amit Langote
On Thu, May 30, 2013 at 5:49 PM, aarti sawant wrote: > I want to migrate physical server on to virtual machine > My physical server consist of > 1. Some Application. > 2. PostgreSQL Database > > Here the system migrated from Physical machine will be replicated into two > > VM's. > - One will be ac