Based upon on-campus programms and project experiences, our e-learning programme utilises a blend of interactive content, videos, script, case studies and online discussions to explore the science and business responses to climate change.
Now you should be able to give pgAdmin a valid password for the DB superuser and it will be happy too. You can leave the psql shell by typing Ctrl D or with the command \q. Inside the psql shell you can give the DB user postgres a password: ALTER USER postgres PASSWORD 'newPassword'
If any of those commands fail with an error psql: FATAL: password authentication failed for user "postgres" then check the file /etc/postgresql/8.4/main/pg_hba.conf: There must be a line like this as the first non-comment line: local all postgres identįor newer versions of PostgreSQL ident actually might be peer. If that fails with a database "postgres" does not exists error, then you are most likely not on a Ubuntu or Debian server :-) In this case simply add template1 to the command: sudo -u postgres psql template1
That means, that you can login to that account only by using the postgres OS user account.Īssuming, that you have root access on the box you can do: sudo -u postgres psql If I remember correctly the user postgres has no DB password set on Ubuntu by default.