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