I just installed a new Centos 6.3 server, upgraded the REMI repositories, and from there, installed postgresql:
yum install postgresql92 postgresql92-devel postgresql92-server postgresql92-libs postgresql92-contrib –y
after that I installed php:
yum --enablerepo=remi,remi-test install php php-common
And the PHP modules:
yum --enablerepo=remi,remi-test install php-pecl-apc php-cli php-pear php-pdo php-mysql php-pgsql php-pecl-mongo php-sqlite php-pecl-memcache php-pecl-memcached php-gd php-mbstring php-mcrypt php-xml
Started the postrgesql database:
service postgresql-9.2 start
Created a password to the postrgresq user, login via VNC, open the pgadmin, but when I tried to create a new database:
An error has ocurred:
Error connecting to the server: definition of service “postgresql-9.2” not found
And I don’t know exactly why is that happening, I’ve checked and everything seems to be installed correctly…
So, if someone have any idea and can point me to any direction it will be very helpful..
Ahh, something else, I was in the VNC sesión with the user :1 and suddenly pgadmin hang, so I kill the process from webmin, but after that, it dont let me login with that user, it said: Cant establish a connection since the destiny denies the connection…
The other user Works perfectly, but user 1 its pretty much useless…
Any idea about that issue can also help me a lot.