Thread: About groups in postgres
Hi! I've got a couple of questions about groups in postgres: 1) Is there any way of asking postgres the groups a user account belongs to? 2) Let's suppose I have a user account that belongs to several groups, how can I tell postgres that I want access the database but just with the priviledges of one of the groups? Thanks in advance and regards to all. Denis -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net
> 1) Is there any way of asking postgres the groups a user account > belongs to? You can figure this out, but I don't know of a nice clean way of doing it. Check out the pg_group table. There's got to be a 'value in array' type function that could make that an easy select. > 2) Let's suppose I have a user account that belongs to several > groups, how can I tell postgres that I want access the database but > just with the priviledges of one of the groups? You don't want the intersection of permissions? I'd create a new user account: I don't know that there's a way to rescind privs that have been granted to you. -sc -- Sean Chittenden
In the past, several of you have mentioned that adding backup and recovery features to Postgres (specifically, point in time recovery), was important to you and/or your company. For one reason or another, it keeps getting shoved off the list of features for the next release. I'd like to organize a group of postgres users to hurry along this process by throwing some money at the problem. My company is willing to pony up some of the cost. I'd like very much to share the cost of making this happen with others. I've gotten a quote from Red Hat for the work, and it was insane/excessive, so that is out of the question. To the group, then, would any of you out there be willing to participate in such a venture, either on the financial support or coding side? I believe Postgres is an excellent database, but without this feature, some companies will look elsewhere for a database management systems. The more people that use Postgres, the better for all of us, and this is a critical piece.. Please email me if you are interested in such a venture or have any comments. -- Naomi Walker Chief Information Officer Eldorado Computing, Inc. 602-604-3100 ext 242
Naomi Walker wrote: > In the past, several of you have mentioned that adding backup and recovery > features to Postgres (specifically, point in time recovery), was important > to you and/or your company. For one reason or another, it keeps getting > shoved off the list of features for the next release. > > I'd like to organize a group of postgres users to hurry along this process > by throwing some money at the problem. My company is willing to pony up > some of the cost. I'd like very much to share the cost of making this > happen with others. I've gotten a quote from Red Hat for the work, and it > was insane/excessive, so that is out of the question. > > To the group, then, would any of you out there be willing to participate in > such a venture, either on the financial support or coding side? > > I believe Postgres is an excellent database, but without this feature, some > companies will look elsewhere for a database management systems. The more > people that use Postgres, the better for all of us, and this is a critical > piece.. One use of replication can be point-in-time recovery. The log of replication messages can be played back against a nightly backup to restore the system to the current state. It would be nice to hit both of these at the same time. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
FYI, we have a point-in-time recovery patch submitted by J.R. Nield <jrnield@usol.com>. It arrived too late for 7,3 but it will be in 7.4. If you need it for 7.3, you may be able to get a patch directly from him. 7.3 beta starts September 1. --------------------------------------------------------------------------- Naomi Walker wrote: > In the past, several of you have mentioned that adding backup and recovery > features to Postgres (specifically, point in time recovery), was important > to you and/or your company. For one reason or another, it keeps getting > shoved off the list of features for the next release. > > I'd like to organize a group of postgres users to hurry along this process > by throwing some money at the problem. My company is willing to pony up > some of the cost. I'd like very much to share the cost of making this > happen with others. I've gotten a quote from Red Hat for the work, and it > was insane/excessive, so that is out of the question. > > To the group, then, would any of you out there be willing to participate in > such a venture, either on the financial support or coding side? > > I believe Postgres is an excellent database, but without this feature, some > companies will look elsewhere for a database management systems. The more > people that use Postgres, the better for all of us, and this is a critical > piece.. > > Please email me if you are interested in such a venture or have any comments. > > > > -- > Naomi Walker > Chief Information Officer > Eldorado Computing, Inc. > 602-604-3100 ext 242 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073