[ADMIN] clustering with shared storage

2012-03-20 Thread Gary Webster
Hello. Sorry if this is redundant, but I can't find any 'cookbook' for getting this setup. The best I've found is here: http://wiki.postgresql.org/images/5/58/06.5_-_Devrim_Gunduz_-_PostgreSQLClusteringWithRedHatClusterSuite--LT.pdf but, it doesn't go into setup details. I have a few

Re: [ADMIN] clustering with shared storage

2012-03-20 Thread Devrim GÜNDÜZ
Hi, On Tue, 2012-03-20 at 15:26 -0400, Gary Webster wrote: The best I've found is here: http://wiki.postgresql.org/images/5/58/06.5_-_Devrim_Gunduz_-_PostgreSQLClusteringWithRedHatClusterSuite--LT.pdf but, it doesn't go into setup details. http://www.gunduz.org/download.php?dlid=190 has a

Re: [ADMIN] clustering with shared storage

2012-03-20 Thread amador alvarez
Hi there, I wonder why are you considering this solution, as if something wrong comes within the data (logical corruption, user error) it will be spread on both locations, Would not be better a delayed standby database. I am curious because I am setting this up right now and do not get all

Re: [ADMIN] clustering with shared storage

2012-03-20 Thread Devrim GÜNDÜZ
On Tue, 2012-03-20 at 13:33 -0700, amador alvarez wrote: I wonder why are you considering this solution * Automatic failover detection * No replication overhead, in case you don't need it. RHCS+PostgreSQL can also be used when you shard your data to multiple databases, and use each server as

Re: [ADMIN] clustering with shared storage

2012-03-20 Thread Rosser Schwarz
On Tue, Mar 20, 2012 at 1:33 PM, amador alvarez aalva...@d2.com wrote: I wonder why are you considering this solution, as if something wrong comes within the data (logical corruption, user error) it will be spread on both locations, Would not be better a delayed standby database. That's a

[ADMIN] New role can connect to all dbs with no grants

2012-03-20 Thread Gordon Shannon
Hi. I'm confused about how to restrict databases from roles. When I create a new database, I thought I would have to grant connect to a role in order for that role to connect to it and see its objects. But... [admin@toolbox:acct] 14:50:23 create database foo owner postgres; CREATE DATABASE

Re: [ADMIN] New role can connect to all dbs with no grants

2012-03-20 Thread Mark Lane
Gordon On Tue, Mar 20, 2012 at 5:02 PM, Gordon Shannon gordo...@gmail.com wrote: Hi. I'm confused about how to restrict databases from roles. When I create a new database, I thought I would have to grant connect to a role in order for that role to connect to it and see its objects.

[ADMIN] deciding between amd and intel processor

2012-03-20 Thread Imre Oolberg
Hi! My comerade has to decide for his so to say generic and a bit unpredicted PostgreSQL needs for web applications between Intel and AMD based server. For now it has been coming down to these processor choices 1. Dell PowerEdge R810 which has 2 x Intel® Xeon® E7­-4830 2.13GHz, 24M cache

Re: [ADMIN] deciding between amd and intel processor

2012-03-20 Thread Scott Marlowe
On Tue, Mar 20, 2012 at 5:42 PM, Imre Oolberg i...@auul.pri.ee wrote: Hi! My comerade has to decide for his so to say generic and a bit unpredicted PostgreSQL needs for web applications between Intel and AMD based server. For now it has been coming down to these processor choices 1. Dell

Re: [ADMIN] deciding between amd and intel processor

2012-03-20 Thread Scott Marlowe
As a followup to my previous post, if you get a solid white box, you could build a machine for $17k that will beat the two previously listed machines pretty badly, and in a small form factor as well. Take one of these: http://www.aberdeeninc.com/abcatg/mb1661.htm and throw 4 16C AMDs and 128G