Re: postgresql and solaris 10: pitch to sysadmins

On Monday 18 June 2007 16:27, John Smith wrote:
> guys
> need to pitch postgresql to some hard-to-budge solaris sysadmins- they
> don't even know about the postgresql-solaris 10 package, just used to
> oracle and don't want to break their backs over postgresql. plus i
> don't know enough slony yet.
>
> can someone point me to some standard backup/restore etc sysadmin
> stuff/scripts/processes? also what's best left to the sysadmins that i
> shouldn't take responsibility for? any trainings/books for
> sysadmins/myself?
> thanks, jzs

We run a number of pg systems on various versions of solaris. We did a case
study on the instance available here:
http://images.omniti.net/omniti.com/media/c_06-1081_SunOmniTl_SB-Fhr.pdf

We don't really offer PostgreSQL/Solaris specific training (though maybe we
should, Theo is a dtrace wizard), we're more of a professional services firm,
helping with setup and ongoing maintenence. I don't think Sun offers that
level of training either though you might want to contact your local Sun rep
to find out.

OH, I do have some pg specific bookmarks from Sun you can pass on to your
admins, really setting up postgresql is pretty simple if your guys already
know thier way around the OS.
http://www.sun.com/software/solaris/howtoguides/postgresqlhowto.jsp
http://docs.sun.com/app/docs/doc/819-5578?q=+postgresql&a=expand

Hmm... one other thing, we've been dumping some of our stuff onto our labs
site, you can see some of it here: https://labs.omniti.com/trac/pgsoltools

HTH
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL