Do you have an internet connection?... if resolving that doesn't work:
This is the DNS info on the name you can put then name with the ip shown in the /etc/hosts files if you can ping the address.
hk.archive.ubuntu.com. 600 IN CNAME ftp.cuhk.edu.hk. ftp.cuhk.edu.hk. 900 IN A 220.127.116.11
Best would be to solve the connections & name resolution problems though,
postgres is not in the sudoers file. This incident will be reported.
As root user try: sudo -u postgres -s
To ensure there is a valid shell there might be an invalid shell configured in /etc/passwd to prevent logins on the postgres account at well.
Agreed, -s is needed to avoid other issues.
Creating postgresql as a regular user makes no sense..., it is meant to have a no-access account as part of the security.
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.