Do I need to re-install, was: Re: Problems invoking psql, was: Re: [ADMIN] Troubles at

2002-12-06 Thread Hugh Esco
Cameron, James & Tom: Is this advise below a bit drastic? I just completed a re-install of postgresql, from source, and have encountered the same problem with the hanging shell response to my attempts to invoke a psql command prompt, even using the -a or --echo-all switches. -- Hugh Esco I re

Re: [ADMIN] list schema

2002-12-06 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> I was going to add one for schemas, but \ds and \dS are already taken, >> and there was no good proposal for what to use instead. Any thoughts? > \dschema I would have done that, but it doesn't fit nicely beside the behavior of t

Re: [ADMIN] Postgres 7.3 and phpPgAdmin

2002-12-06 Thread Robert Treat
Unfortunately I don't think I can lend any good news to the situation. The phpPgAdmin code base, being based on phpMyAdmin, was too hairy to try and add schema support in for 7.3, so we decided to do a complete rewrite of the system, which we dubbed as "webdb". The framework of the webdb code base

Re: [ADMIN] PAM

2002-12-06 Thread Tim Frank
Here is a bit of a follow up to the PAM setup. If you want to authenticate against an LDAP source then creatinga /etc/pam.d/postgresql file containing the following: authrequired/lib/security/pam_ldap.so account required/lib/security/pam_ldap.so This works fine and I love t

Re: [ADMIN] proper db standard

2002-12-06 Thread Nick Fankhauser
Jodi- Given you two choices, I would go for #2, but consider this third option: Publication: pub_id other_stuff Keyword: keyword_id keyword_text Keyword_assignment: pub_id keyword_id Keyword only contains 6 records, but you can add new keywords as needed in the future. (Option #1 didn't give y

Re: [ADMIN] proper db standard

2002-12-06 Thread Dan Langille
On 6 Dec 2002 at 10:45, Jodi Kanter wrote: > I am creating a simple database that will hold information about > various pu= blications. There are keywords that are associated with > these publications = and there can be anywhere from 1 to about 6 of > these different keywords. > > As I see it I h

[ADMIN] proper db standard

2002-12-06 Thread Jodi Kanter
I am creating a simple database that will hold information about various publications. There are keywords that are associated with these publications and there can be anywhere from 1 to about 6 of these different keywords.   As I see it I have two choices:   1) create keyword fields 1-6 in th