[ADMIN] root user permissions

1999-10-14 Thread Marc Wrubleski
I have accidentally disallowed my user postgres access to my database by trying to change the password for that user. I performed an UPDATE USER postgres WITH PASSWORD mypassword; and now I cannot access the psql tool. How do I re-allow myself at this stage? any command line actions return data

RE: [ADMIN] User/group policy for pg backed web sites

1999-10-14 Thread Nicolas Huillard
You store login/password in a read-only file protected from other users : this file (one per web site ?) contains the login/pass used by the web server to access the database ? Is this way to work really secure (this file must be stored outside of the HTML root space, even outside of the FTP ro