[GENERAL] simple question: building psql

2001-03-17 Thread Jeff Davis
I really like the feature of psql that allows you to press "up" to go to your command history, and press "home" to go to the beginning, etc (like a normal shell). However, I use debian linux. I have correctly compiled pg on a mandrake box before (so that it has the more effective version o

[GENERAL] Re: Postgresql database size problem

2001-03-17 Thread J.H.M. Dassen (Ray)
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >I'm running postgresql-7.0.2-6 on a Debian potato. Any particular reason why you're not running 7.0.3 (which is the latest release and contains fixes for some problems with 7.0.2)? Ray -- "People should never have been given free will." Lots of lan

Re: [GENERAL] create user, user exists

2001-03-17 Thread Peter Eisentraut
Ron Peterson writes: > So now I'm trying to decide whether I want to use 'password' or > pg_shadow for user authentication. Using 'password' seems like a broad > (and easily managed) brush, while using groups would give me a finer > degree of control over permission settings. The ability to use

Re: [GENERAL] create user, user exists

2001-03-17 Thread Ron Peterson
Tom Lane wrote: > > Ron Peterson <[EMAIL PROTECTED]> writes: > > I'm having a bit of authentication trouble. I'm trying to use 'crypt' > > authentication. PostgreSQL 7.1beta5. My pg_hba.conf is as follows: > > IIRC, you can't use crypt with a flat password file, you have to use > plain passwd

Re: [GENERAL] Re: [ADMIN] New PostgreSQL session monitor

2001-03-17 Thread Bruce Momjian
[ Charset ISO-8859-2 unsupported, converting... ] > On Saturday, March, 2001-03-17 at 00:13:37, Bruce Momjian wrote: > > > > If you are running PostgreSQL 7.1 or earlier, the 'query' button will > > not work unless you compile PostgreSQL with debug symbols (-g), or apply > > the supplied patch 'q

[GENERAL] Re: [ADMIN] New PostgreSQL session monitor

2001-03-17 Thread Marek Pętlicki
On Saturday, March, 2001-03-17 at 00:13:37, Bruce Momjian wrote: > > If you are running PostgreSQL 7.1 or earlier, the 'query' button will > not work unless you compile PostgreSQL with debug symbols (-g), or apply > the supplied patch 'query_display.diff' and recompile PostgreSQL. The > later me

RE: [GENERAL] ssl connections with psql

2001-03-17 Thread Christian Marschalek
> For those reading this and assuming that using SSL is always a good thing, > SSL data connections are up to 100 times slower, as all of the data has > to be encrypted and decrypted by the server and the client. Running SSL > connections to the same server you're hosting the web pages on would be

Re: [GENERAL] create user, user exists

2001-03-17 Thread Richard Huxton
From: "Ron Peterson" <[EMAIL PROTECTED]> > I'm having a bit of authentication trouble. I'm trying to use 'crypt' > authentication. PostgreSQL 7.1beta5. My pg_hba.conf is as follows: > > #local all trust > local all crypt passtest > > When I do 'local all trust', everything works fine. When I