[ADMIN] password authentication with external passwd file

2005-08-27 Thread Jason Stone
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all. I am currently running postgresql-7.2, and I have my pg_hba.conf configured to use password authentication with external passwd files. eg: pg_hba.conf: local db1 all password db1.pwd host db1 all 127.0.0.1 255.

Re: [ADMIN] password authentication with external passwd file

2005-08-27 Thread Michael Fuhr
On Sat, Aug 27, 2005 at 01:31:25AM -0700, Jason Stone wrote: > I would like to know first, if I'm mistaken, or if external passwd files > are now specified in some other way, or must be enabled at compile time or > something like that; ie, am I doing something wrong? The 7.3 Release Notes have t

Re: [ADMIN] Hash index

2005-08-27 Thread Bruno Wolff III
Please keep replies posted to the list so that more people can add to and learn from the discussion. On Sat, Aug 27, 2005 at 08:18:57 -, RAJU kumar <[EMAIL PROTECTED]> wrote: > Sir i am a consultant in Sql * international india, > And the problem with me is i have to handle all the question

Re: [ADMIN] Hash index

2005-08-27 Thread Jim C. Nasby
On Sat, Aug 27, 2005 at 01:21:50AM -0500, Bruno Wolff III wrote: > On Fri, Aug 26, 2005 at 10:59:50 -, > RAJU kumar <[EMAIL PROTECTED]> wrote: > > ? > > ? > > i want to find out the difference between the btree index and hash index > > and how exactly the hash index work. > > Why? You pr

[ADMIN] Unable to run psql

2005-08-27 Thread Thomas E Dukes
Hello, I am trying to setup a database for an app that requires postresql. My system is running CentOS 4.1 using postgres 7.4.8. I have never used postgresql before. I have worked on this most of today and about to delete it from my harddrive. I added a password for 'postgres' using passwd. I

Re: [ADMIN] Unable to run psql

2005-08-27 Thread Jeff Frost
On Sat, 27 Aug 2005, Thomas E Dukes wrote: I added a password for 'postgres' using passwd. I can login or su as 'postgres' but when I run psql and enter the password it fails because the password is invalid. Tom, the confusion lies in the difference between the database user postgres and th