Hmm... very suspicious...
However, if you have root on that machine, try this:
su - root
su - postgres
cd /var/lib/pgsql/data
vi pg_hba.conf
add:
local databasename trust
Restart postgres, Switch back to your user, then try:
psql databasename postgres
Bingo, you're in as the DB admin. GRANT <blah> from here on in.
Regards,
Phil
+----------------------------------+
| Phil Mayers, Network Support |
| Centre for Computing Services |
| Imperial College |
+----------------------------------+
-----Original Message-----
From: Jamie Bumsted [mailto:jbumsted@evertek.net]
Sent: 07 February 2001 12:53
To: pgsql-general@postgresql.org
Subject: [GENERAL] Can you help a newbie?
Hi All,
I am new to pgsql, I have inherited a database with no documentation, i.e.
nobody knows the passwords for any of the database accounts. Anybody have
any ideas on how to change the passwords without first knowing the
passwords?
If this is a stupid question I apologize in advance.
Thanks!
Jamie Bumsted
Systems Engineer
Evertek, Inc.