Re: [ADMIN] about postgresql process

2013-03-25 Thread Sergey Konoplev
Hello, Please follow the guide to report your problem: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems On Mon, Mar 25, 2013 at 6:32 PM, wangqi wrote: > Hi everybody > > What's this in command 'ps ux'. If these processes appears The Server load > average: 100.99, 100.74, 86.85. > How

[ADMIN] about postgresql process

2013-03-25 Thread wangqi
Hi everybody What's this in command 'ps ux'. If these processes appears The Server load average: 100.99, 100.74, 86.85. How can I reslove it. - postgres 35044 34.2 0.0 0 0 ? Rs 00:19 50:42 [postmaster] post

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Stephen Frost
* Tim Watts ([email protected]) wrote: > I wish I could help - but I more of a sysamdin and less of a developer. So was I, until I ran into this annoying issue where a table could only have one owner.. Then I added support for roles. :) > A "negotiate" option would be very cool. I will expec

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Tim Watts
On 25/03/13 15:17, Stephen Frost wrote: Tim, * Tim Watts ([email protected]) wrote: I presume the protocol does not allow the server to send a succession of "Type: Authentication request" packets with different Authentication types until it deems that one is acceptable? Even if it did, ex

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Stephen Frost
Tim, * Tim Watts ([email protected]) wrote: > I presume the protocol does not allow the server to send a succession of > "Type: Authentication request" packets with different Authentication > types until it deems that one is acceptable? Even if it did, existing clients would very likely be co

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Tim Watts
On 25/03/13 14:31, Tom Lane wrote: Stephen Frost writes: * Tim Watts ([email protected]) wrote: I would have to respectfully take another point of view: that that particular judgement is probably better placed with the sysadmin rather than a blanket decision by the devs. It's not a blan

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Tim Watts
On 25/03/13 13:25, Stephen Frost wrote: Tim, * Tim Watts ([email protected]) wrote: I would have to respectfully take another point of view: that that particular judgement is probably better placed with the sysadmin rather than a blanket decision by the devs. It's not a blanket decision b

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Tom Lane
Stephen Frost writes: > * Tim Watts ([email protected]) wrote: >> I would have to respectfully take another point of view: that that >> particular judgement is probably better placed with the sysadmin >> rather than a blanket decision by the devs. > It's not a blanket decision by any means- t

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Stephen Frost
Tim, * Tim Watts ([email protected]) wrote: > I would have to respectfully take another point of view: that that > particular judgement is probably better placed with the sysadmin > rather than a blanket decision by the devs. It's not a blanket decision by any means- the current situation is

Re: [ADMIN] Postgresql 8.4 GSSAPI auth with fallback to password prompting?

2013-03-25 Thread Tim Watts
On 24/03/13 18:47, Stephen Frost wrote: Tim, * Tim Watts ([email protected]) wrote: Is it possible to specify GSSAPI auth (with MIT kerberos as the backend) but get Postgresql to fallback to prompting for a password if a kerberos ticket cannot be supplied by the client - eg because the clie