Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Postgresql service 8.2 on Solaris 10 Update 4

807557May 13 2008
Hi

I have solaris 10 update 4 installed. PostgreSQL with SMF is shipped with Solaris 10 update 4.

I could see two services installed on the OS.

svcs postgresql
disabled 14:58:36 svc:/application/database/postgresql:version_81
maintenance 15:40:42 svc:/application/database/postgresql:version_82

I followed the steps to start postgres service given on Sun website...

PostgreSQL 8.2:

1. As root, su to postgres:

# su - postgres

2. Create PostgreSQL DB cluster:

$ /usr/postgres/8.2/bin/initdb -D /var/postgres/8.2/data

3. As root, use the SMF's svcadm command to start PostgreSQL:

# /usr/sbin/svcadm enable postgresql:version_82

now I could see one serive enabled.

svcs postgresql
disabled 14:58:36 svc:/application/database/postgresql:version_81
online 15:40:42 svc:/application/database/postgresql:version_82

But, when I disabled the service & restarted it using...

svcadm disable svc:/application/database/postgresql:version_82
svcadm enable svc:/application/database/postgresql:version_82

I see the serivce in the maintenance mode.

disabled 14:58:36 svc:/application/database/postgresql:version_81
maintenance 15:40:42 svc:/application/database/postgresql:version_82

Server.log shows following error:-
FATAL: syntax error in file "/var/postgres/8.2/data/postgresql.conf" line 104, near token "MB"

Can anyone help me know the reason?

Thanx in advance
Niraj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2008
Added on May 13 2008
0 comments
323 views