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 database access failed. Thanks. Marc Wrubleski ************
