Thanks Jim, good to hear from you again.
Well for starters, if anyone out there does have a Solaris 9 or 10 startup script that they could post it would be appreciated. I will check on the Sun site as well, if I find anything I'll post it to the list.
One of the problems may be that the Solaris install defaults to /usr/local/pgsql and to keep consistency with my numerous Linux installs I moved everything to /var/lib/pgsql. Maybe that caused some quirks? I did find that once installed starting postgres with pg_ctl -D /var/lib/pgsql/data (even in the background using the &) postgres would not write to the logfile as outlined in my postgresql.conf file, frustrating. I then dropped the databases, did the initdb again and used
postmaster -D /var/lib/pgsql/data & and that worked. I am at a loss as to why but as long as it works I will not question it. I do however prefer the /etc/init.d/postgresql script so will keep searching.
Yes, I know I need to upgrade to at least 8.0.8 (even better to 8.1) but my hands are tied as the app that runs on the box is "not certified" against anything higher than 8.0.1, I keep trying to push the vendor but as of yet to no avail.
Thanks again to Thomas and Jim for your replies.
Tim
-----Original Message-----
From: Jim Nasby [mailto:jnasby@pervasive.com]
Sent: Tuesday, August 08, 2006 1:05 PM
To: mcelroy, tim
Cc: 'Thomas Mack'; 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Start-up script for Solaris
On Aug 8, 2006, at 7:19 AM, mcelroy, tim wrote:
> Thank you Thomas. I've tried it but get a few syntax errors. I
> have postgresql 8.0.1 installed and have moved it to /var/lib/pgsql
> to mimic Linux so I need to edit the file some more. I'll let you
> know how it works.
You need to upgrade. You're exposing yourself to at least one data
corruption bug and a security hole. You can go to 8.0.8 without a
dump and restore (though if you have the time it'll be worth it going
to 8.1.4).
As for startup, see if you can find someone running Solaris 10 and
grab the startup out of there (I'm assuming 9 and 10 use the same
system startup scripts...). If Sun has a web interface to their
repository, you could probably just grab that one script, too.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461