Re: [ADMIN] Warm standby recovery failure

2009-02-03 Thread Scott Marlowe
On Fri, Jan 30, 2009 at 7:52 AM, Tom Lane wrote: > Jaume Sabater writes: >> On Fri, Jan 30, 2009 at 2:22 AM, Tom Lane wrote: >>> We probably should add a caution about this to the manual's discussion >>> of how to write archiving scripts. > >> I presume you mean the copy/transfer process did not

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Scott Marlowe
Actually, the ACLU protects CIVIL LIBERTIES, like say, freedom of speech. I think they'd be on Bruce's side here. On Tue, Feb 3, 2009 at 7:07 PM, Benjamin Krajmalnik wrote: > He must be a card carrying member of the ACLU, and now he thinks he is > the G_d of these lists :) > >> -Original Mes

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Benjamin Krajmalnik
So what if he voices his beliefs. This PC BS is over the top. If you are so offended by his by-line, to the extent that you want to remove yourself fomr the mailing lists, then by all means do so. I am not a Christian (I am Jewish, so I guess that puts me one rung below Bruce), and am definitely no

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Benjamin Krajmalnik
He must be a card carrying member of the ACLU, and now he thinks he is the G_d of these lists :) > -Original Message- > From: pgsql-admin-ow...@postgresql.org > [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Joshua D. Drake > Sent: Monday, February 02, 2009 4:22 PM > To: Scott Ru

Re: [ADMIN] How to prevent users from creating tables

2009-02-03 Thread Milen A. Radev
raf написа: > hi, > > in my database, normal users can't select, insert, update or > delete anything directly. they can only call functions which > are all security defining functions which give access to the > data. that's the way i like it. > > however, i discovered that normal users can create

Re: [ADMIN] Permissions to a schema

2009-02-03 Thread Daniel J. Summers
Campbell, Lance wrote: How do I do the following: 1) Create a user group. 2) Assign access to select, delete, insert, and update to any table found in the following X number of schemas. 3) Assign the newly created user group permissions to a new user. When you're going through the tables,

[ADMIN] How to prevent users from creating tables

2009-02-03 Thread raf
hi, in my database, normal users can't select, insert, update or delete anything directly. they can only call functions which are all security defining functions which give access to the data. that's the way i like it. however, i discovered that normal users can create new tables in the database.

Re: [ADMIN] Warm standby recovery failure

2009-02-03 Thread Lee Azzarello
thank you all for your help. It was indeed my copy script that destroyed the database. I now understand that postgresql shouldn't be concerned with validating a WAL segment, that's the responsibility of the script that hands the segment to postgres. -lee On Fri, Jan 30, 2009 at 9:52 AM, Tom Lane

Re: [ADMIN] Permissions to a schema

2009-02-03 Thread Carol Walter
I believe that this is dependent on what version of postgres you are using. What you want to do is create a role. You do this by issuing the CREATE ROLE command... CREATE ROLE select_role; GRANT SELECT on MyTable to select_role; GRANT select_role TO MyUser; Carol On Feb 3, 2009, at 11:33

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Dru Devore
sounds good to me. --- > > On Tue, 2009-02-03 at 11:40 -0500, Stephen Cook wrote: > > > Personally I'd be happy if religious people simply stopped thinking they > > were superior to atheists. I'm sure there is a counter claim to that > > one, but I'd rather not get into it on a technical mail

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Joshua D. Drake
On Tue, 2009-02-03 at 11:40 -0500, Stephen Cook wrote: > Personally I'd be happy if religious people simply stopped thinking they > were superior to atheists. I'm sure there is a counter claim to that > one, but I'd rather not get into it on a technical mailing list. And with that note, I belie

[ADMIN] Permissions to a schema

2009-02-03 Thread Campbell, Lance
How do I do the following: 1) Create a user group. 2) Assign access to select, delete, insert, and update to any table found in the following X number of schemas. 3) Assign the newly created user group permissions to a new user. Thanks, Lance Campbell Project Manager/S

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Stephen Cook
A B wrote: I have not looked into exactly what you claim to believe, but generally: the problem is that the thing you are promoting includes very offensive stuff, women abuse, killing gays, slavery and a lot of other awful stuffIt's like admiring Stalin for stopping Hitler but refusing to see the

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Craig Servin
Wow, you are very easily dismayed!! What sort of life does someone have when they go through it trying to insulate themselves from any idea that makes them uncomfortable? Sounds very sterile. On Monday 02 February 2009 03:57:21 pm Scott Runnion wrote: > As a subscriber to many postgresql mailin

Re: [ADMIN] Re: Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread tony
Le mardi 03 février 2009 à 08:41 -0500, Shrirang Chitnis a écrit : > Funny, but I never noticed the signature until someone brought it to notice. SH please don't bring up Larry Wall, then we are in big trouble =:-D Tony -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)

[ADMIN] Re: Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Shrirang Chitnis
Funny, but I never noticed the signature until someone brought it to notice. What I have noticed though that Bruce does share a lot of knowledge in the list and though I have not participated or asked questions, the mails have helped me a lot. I bet it is the same for many users like me who reg

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-03 Thread Scott Marlowe
On Tue, Feb 3, 2009 at 12:43 AM, A B wrote: >> Here is mine and yes I have gotten a lot of flack over it. What is the >> problem with trying to promote your faith and why do so many people have >> problems with it? > > I have not looked into exactly what you claim to believe, but > generally: the