[ADMIN] When I executed type cast functions. The postgres normal concatenation operator query was breaking.

2012-08-17 Thread Saravanakumar Ramasamy
Hi All. Now I am using postgres 9.1.3 version . Before I am used 8.2.22 after I upgraded 9.1.3. Upgraded was successfully completed. In Postgres 8.2.22 #--# POSTGRES8222=# select TO_NUMBER('12345678',99.99); to_number --- 12345678 (1 row) POSTGRES

[ADMIN] Starting PostgreSQL on OS X 10.8

2012-08-17 Thread Eric Lemings
Greetings, I have a Mac Mini Server which I recently upgraded to Mountain Lion and then again with the optional Server.app i.e. OS X Server. Whenever I try starting PostgreSQL, I get the following: $ sudo serveradmin start postgres postgres:error = "CANNOT_START_SERVICE_TIMEOUT_ERR" I haven't

Re: [ADMIN] Starting PostgreSQL on OS X 10.8

2012-08-17 Thread Joel Hedden
Hi Eric, After seeing that error, you should check the status with a "sudo serveradmin fullstatus postgres" to see if it is responsive. That error may show up if the database startup takes longer than expected. You could also try connecting with psql, etc. Did you upgrade from an OS X Server