Re: [GENERAL] Extraordinarily slow!!

2005-09-27 Thread Chris Travers
Tom Lane wrote: "Justin R. Smith" <[EMAIL PROTECTED]> writes: I've solved the problem. I was accessing Postgres over an ssh connection and had enabled X forwarding in the sshd server (not the default configuration). For reasons that pass understanding, psql attempts to establish

Re: [GENERAL] Extraordinarily slow!!

2005-09-27 Thread Martijn van Oosterhout
On Tue, Sep 27, 2005 at 09:38:46AM -0400, Tom Lane wrote: > "Justin R. Smith" <[EMAIL PROTECTED]> writes: > > Interestingly, it does NOT help to have X forwarding turned off only in > > the client: sshd itself must not do any forwarding. > > [ scratches head... ] That makes no sense at all. psq

Re: [GENERAL] Extraordinarily slow!!

2005-09-27 Thread Tom Lane
"Justin R. Smith" <[EMAIL PROTECTED]> writes: > I've solved the problem. > I was accessing Postgres over an ssh connection and had enabled X > forwarding in the sshd server (not the default configuration). For > reasons that pass understanding, psql attempts to establish an X > connection with

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Tony Caduto
You really should look at something like Fedora Core or Ubuntu if you want FREE. If you don't mind paying the SuSE is a good choice. If you want RHE look and feel but don't want to pay, look at CentOS. Sincerely, Joshua D. Drake Just as a FYI, you don't have to pay for Suse anymore, unl

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Tony Caduto
Joshua D. Drake wrote: Bizarre. Question: Does the problem happen when you just type psql? What if you pass the host option? e.g; psql -h 127.0.0.1 What type of auth are you running? Don't use Gentoo? Seriously, that distribution is completely unsupportable because no one else has the f

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Peter Fein
Tom Lane wrote: > Don't use Gentoo? Seriously, that distribution is completely > unsupportable because no one else has the faintest idea what you are > really running. You've probably got some system component that is > either broken in itself or incompatible with some other component, > but ther

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Tony Caduto
Tom Lane wrote: "Justin R. Smith" <[EMAIL PROTECTED]> writes: I'm running postgresql 8.03 under Gentoo Linux and find that all actions take at least a MINUTE (even dropdb and createdb). During this time, the posgres account is locked up to the extent that one cannot even su to it. (The su

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Joshua D. Drake
Bizarre. Question: Does the problem happen when you just type psql? What if you pass the host option? e.g; psql -h 127.0.0.1 What type of auth are you running? Don't use Gentoo? Seriously, that distribution is completely unsupportable because no one else has the faintest idea what you are

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Tom Lane
"Justin R. Smith" <[EMAIL PROTECTED]> writes: > I'm running postgresql 8.03 under Gentoo Linux and find that all actions > take at least a MINUTE (even dropdb and createdb). During this time, the > posgres account is locked up to the extent that one cannot even su to > it. (The su suceeds when t