Re: [ADMIN] Build a postgreSQL package on Solaris 10

2008-06-17 Thread Robert Lor
lay/DBonSolaris/BuildingPostgreSQL -- Robert Lor Sun Microsystems Austin, USA http://sun.com/postgresql -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Postgres Cluster on Solaris

2008-05-13 Thread Robert Lor
Travis, Travis Smith wrote: Hello All, I am interested in running Postgres on Solaris using SunCluster. I am hoping that someone this list has experience with this configuration. To be honest I am having a difficult time understanding the concept of Postgres clusters. I originally began lo

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-30 Thread Robert Lor
Thomas Bräutigam wrote: That's the issue, the database is not running which gets delivered with Solaris 10 but I am not sure if the my customer accidently activates it or not, so I want to be on the safe side of live, that I minimize this risk. In that case, just pick a non default port for

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-30 Thread Robert Lor
Thomas Bräutigam wrote: Hi Jignesh What things do I all need to take care when I want to run both postgres databases on the same box. Like the Solaris 10 postgres db and my postgres db. By default the Postgres versions that are shipped with Solaris are disabled (run "svcs postgresql" to ver

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-29 Thread Robert Lor
There are a couple of options you can take to accomplish this. 1) Remove the role by running ¨roledel postgres¨ . This will remove postgres from /etc/passwd and /etc/user_attr, and you can use useradd to add postgres as a user. 2) Modify ¨postgres¨ from being a role to user. Below are the ste

Re: [ADMIN] Postgres and SUN

2008-04-03 Thread Robert Lor
Thomas, Thomas Bräutigam wrote: Hi Zmi, Okay thanks for that advice. Sorry its my first day on a mailing list. But do Postgres have a special recommendation which SUN equipment runs perfect with a Postgres Database? A time for a query over 30 seconds I would say is to long. So the machine s