The problem should be that there are two versions of PostgreSQL in
solaris. Unfortunately, postgresql 8.1 is located in /usr/bin. When you
run initdb then you create database for version 8.1. Correct version of
initdb is in /usr/postgres/8.2/bin/initdb.
Zdenek
Ivan wrote:
> I tried to start postgresql via svcadmin, but i received following errors:
> 1) First time i tried to star with svcadmin enable postgresql:version_82 i
> have an error that remind me to init the database with initdb.
> 2) I fixed this problem, but now, every time i try to launch postgre i have
> this error with svc -x postgresql:version_82:
>
> root at unknown ->svcs -xv postgresql:version_82
> svc:/application/database/postgresql:version_82 (PostgreSQL RDBMS)
> Stato: maintenance da 21 novembre 2007 14:41:23 CET
> Causa: riavvio troppo rapido. (restart too quickly)
> Vedere: man -M /usr/share/man -s 1 postgres_82
> Vedere: http://postgresql.org
> Vedere: /var/svc/log/application-database-postgresql:version_82.log
> Impatto: il servizio non ? in esecuzione. (Service doesn't work)
>
> The svc.startd.log say this:
> nov 21 14:37:04/470: application/database/postgresql:version_82 failed:
> transitioned to maintenance (see 'svcs -xv' for details)
> nov 21 14:41:23/490: application/database/postgresql:version_82 failed
> repeatedly: transitioned to maintenance (see 'svcs -xv' for details)
>
>
> I tried with: svcadmin clear postgresql:version_82, but i receive the same
> error.
> Now, postgresql works if I start it with:
> pg_ctl ...
> postgresql ...
> etc.
>
> someone can help me?
> P.S. Sorry for my bad English.
>
> Thanks, Ivan
> _______________________________________________
> databases-discuss mailing list
> databases-discuss at opensolaris.org
> http://mail.opensolaris.org/mailman/listinfo/databases-discuss
