[ADMIN] not able to use SSL with XA datasource

2008-08-18 Thread kumar, Anand (kumar)
Hi, I am using XA datasource and trying to connect to Postgresql database over SSL. Application server being used is Jboss eap 4.3. I am getting error like: Caused by: org.jboss.resource.JBossResourceException: Could not find accessor on XADataSource: ; - nested throwable: (java.lang.NoSuchMeth

Re: [ADMIN] Best practice running a shared DB hosting server

2008-08-18 Thread Scott Marlowe
On Mon, Aug 18, 2008 at 12:24 PM, Thomas Jacob <[EMAIL PROTECTED]> wrote: > On Mon, Aug 18, 2008 at 10:49:49AM -0600, Scott Marlowe wrote: >> On Mon, Aug 18, 2008 at 10:38 AM, Thomas Jacob <[EMAIL PROTECTED]> wrote: >> > I've changed my approach by revoking rights to schema public >> > from PUBLIC

Re: [ADMIN] Best practice running a shared DB hosting server

2008-08-18 Thread Thomas Jacob
On Mon, Aug 18, 2008 at 10:49:49AM -0600, Scott Marlowe wrote: > On Mon, Aug 18, 2008 at 10:38 AM, Thomas Jacob <[EMAIL PROTECTED]> wrote: > > I've changed my approach by revoking rights to schema public > > from PUBLIC in the template1, and then granting all rights > > to again just to the "main"

Re: [ADMIN] Best practice running a shared DB hosting server

2008-08-18 Thread Thomas Jacob
On Mon, Aug 18, 2008 at 10:55:27AM -0600, Scott Marlowe wrote: > On Mon, Aug 18, 2008 at 10:38 AM, Thomas Jacob <[EMAIL PROTECTED]> wrote: > > On Mon, 2008-08-18 at 11:48 -0400, Robert Treat wrote: > > > >> Yes, I think the whole "security through obscurity" argument is a cop out > >> to > >> get

Re: [ADMIN] Best practice running a shared DB hosting server

2008-08-18 Thread Scott Marlowe
On Mon, Aug 18, 2008 at 10:38 AM, Thomas Jacob <[EMAIL PROTECTED]> wrote: > On Mon, 2008-08-18 at 11:48 -0400, Robert Treat wrote: > >> Yes, I think the whole "security through obscurity" argument is a cop out to >> get around postgresql's design choices (in this perticular instance anyway, >> in m

Re: [ADMIN] Best practice running a shared DB hosting server

2008-08-18 Thread Scott Marlowe
On Mon, Aug 18, 2008 at 10:38 AM, Thomas Jacob <[EMAIL PROTECTED]> wrote: > I've changed my approach by revoking rights to schema public > from PUBLIC in the template1, and then granting all rights > to again just to the "main" user, and usage rights to > the additional users. > > So people aren't

Re: [ADMIN] Best practice running a shared DB hosting server

2008-08-18 Thread Thomas Jacob
On Mon, 2008-08-18 at 11:48 -0400, Robert Treat wrote: > You'll likely want to make the database owned by that role. My intention is to have some sort of "main"-user who'll be able to do whatever they want (because they create all the objects) and a number of additional users that only have the r

Re: [ADMIN] Best practice running a shared DB hosting server

2008-08-18 Thread Robert Treat
On Wednesday 13 August 2008 11:48:10 Thomas Jacob wrote: > Thanks for your reply. > > On Wed, 2008-08-13 at 08:57 -0600, Scott Marlowe wrote: > > Well, databases are designed to be accessed by people you trust to not > > do really stupid things that can affect the other users. > > Well, in a shared

Re: [ADMIN] DB Dump Size

2008-08-18 Thread Glyn Astill
> I am also curious as to why an SQL dump from the production > server would > come out to 2.8G but a dump of an exact replica on a test > box would come > out to 3.0G. What determines the size and makeup of an SQL > dump? Why not repeat the dump without any compression then compare them with a f