Knowledgebase

Portal Home > Knowledgebase > Articles Database > cannot add postgres database

cannot add postgres database

Posted by Calibaba, 07-09-2007, 06:25 AM

PostgreSQL (Cannot add new user or database). It will return "User/DB added successfully" but no new user or database is added. root@server [~]# rpm -qa | grep postgre postgresql-devel-8.1.4-3PGDG postgresql-contrib-8.1.4-3PGDG postgresql-8.1.4-3PGDG postgresql-server-8.1.4-3PGDG postgresql-libs-8.1.4-3PGDG postgresql-python-8.1.4-3PGDG I've already compiled apache after postgres was upgraded months ago. I'm using cpanel 10x

---

Posted by david510, 07-09-2007, 07:26 AM

Modify /var/lib/pgsql/data/pg_hba.conf from 'md5' to 'trust' It should contain the following: local all all trust host all all 127.0.0.1 255.255.255.255 trust Edit /var/lib/pgsql/data/postgresql.conf and change tcpip_socket from false to true. Restart postgres: # service postgresql restart This should fix that.

---

Add to Favourites    Print this Article

starting up business, have questions (Views: 745)

asking for a reseller hosting - any advice? (Views: 758)

H4Y / iWebFusion (Views: 759)

Anybody can help me with file permissions for a small HTML only site please (Views: 741)

Recommendation (Views: 717)