Re: [GENERAL] problems sending email to list
Hi Michael, The mailing list address is pgsql-general@postgresql.org I believe. Brett On 7 February 2012 14:28, mgo...@isstrucksoftware.net wrote: First, I'm sorry I hijacked this message but I'm having problems sending any emails to this list and I'm also not getting anything returned. I tried to sign up again but it says my email address is already subscribed. Can anyone from majordomo suggest any thing that could be wrong? I am sending to pgsql-gene...@postgres.org. Michael Gould Intermodal Software Solutions, LLC 904-226-0978 top.letterhead
[GENERAL] List Permissions
Hi, How can I list a users permissions table by table? i.e. User Joe has read/write on table1 has read on table2 no access on table 3 Or something Thanks for any help!
Re: [GENERAL] List Permissions
Thanks for the replies. Actually this was question posed by one of my colleagues, what he really wants to know is if there is the equivalent of MySQL's select * from all_tab_privs_recd where grantee = 'your user' Thanks again, Brett On 25 October 2011 13:21, Venkat Balaji venkat.bal...@verse.in wrote: My answers are in line in RED - How can I list a users permissions table by table? i.e. User Joe has read/write on table1 has read on table2 no access on table 3 For a particular user you can use below function. You can write a SQL query or script which takes table names from pg_tables one by one. has_table_privilege(user, table, privilege) Example : I am checking if user postgres has select privilege on table1. postgres=# select has_table_privilege('postgres','public.table1','select'); has_table_privilege - t (1 row) For current user (user you logged in as) you can use the following function has_table_privilege(table, privilege) I am checking if the current_user has select privilege on table1 Example: postgres=# select current_user; current_user -- postgres (1 row) postgres=# select has_table_privilege('public.table1','select'); has_table_privilege - t Below link has all the other functions regarding checking permissions http://www.postgresql.org/docs/9.0/static/functions-info.html Hope this helps ! Thanks VB
Re: [GENERAL] List Permissions
Bingo! Thanks very much On 25 October 2011 13:47, Raghavendra raghavendra@enterprisedb.comwrote: On Tue, Oct 25, 2011 at 6:04 PM, Maton, Brett mat...@ltresources.co.ukwrote: Thanks for the replies. Actually this was question posed by one of my colleagues, what he really wants to know is if there is the equivalent of MySQL's select * from all_tab_privs_recd where grantee = 'your user' Thanks again, Brett You have that too... select * from information_schema.role_table_grants where grantee='your user'; --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On 25 October 2011 13:21, Venkat Balaji venkat.bal...@verse.in wrote: My answers are in line in RED - How can I list a users permissions table by table? i.e. User Joe has read/write on table1 has read on table2 no access on table 3 For a particular user you can use below function. You can write a SQL query or script which takes table names from pg_tables one by one. has_table_privilege(user, table, privilege) Example : I am checking if user postgres has select privilege on table1. postgres=# select has_table_privilege('postgres','public.table1','select'); has_table_privilege - t (1 row) For current user (user you logged in as) you can use the following function has_table_privilege(table, privilege) I am checking if the current_user has select privilege on table1 Example: postgres=# select current_user; current_user -- postgres (1 row) postgres=# select has_table_privilege('public.table1','select'); has_table_privilege - t Below link has all the other functions regarding checking permissions http://www.postgresql.org/docs/9.0/static/functions-info.html Hope this helps ! Thanks VB
Re: [GENERAL] Performing upgrade to latest minor release using PGDG RPMs
I ran into the same problem (no 9.0.4 rpm) on CentOS 6. I downloaded the SRPM from the x86_64 directory at http://yum.postgresql.org/srpms/9.0/ and built a fresh set of rpm with rpmbuild. You might need to do the same. Regards, Brett 2011/8/27 José María Terry Jiménez j...@tssystems.net El 27/08/2011, a las 02:40, John Moran johnfrederickmo...@gmail.com escribió: I'm wondering how it's possible to upgrade my fedora system's pg to the latest minor release. I'm using the PGDG RPMs. A yum update leaves me on version 9.0.2. I'd expect it to put me on 9.0.4. What am I doing wrong? I installed from pgdg-fedora-9.0-2.noarch . Cheers, John -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Hello For Fedora 14 i686, in pgrpms, the last version is 9.0.2-1. For x86_64 is 9.0.4. Check here: http://yum.pgrpms.org/packages.php Which release and architecture are you using? Best -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgresql 9.0.4 SRPMS
Thanks Devrim, There was no SRPM for 9.0.4 under the i386 folder, but there was one in the x86_64. rpmbuild reported no errors once I got all of the dependencies installed. All seems to be working sweetly now. Brett 2011/8/26 Devrim GÜNDÜZ dev...@gunduz.org On Fri, 2011-08-26 at 13:33 +0100, Brett Maton wrote: Could anyone tell me where to find postgresql 9.0.4 SRPM's? I need to build some RPM's for CentOS 6 - 32 bit. http://yum.postgresql.org/srpms/9.0 Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Re: [GENERAL] Fresh Restore - relation contains more than max_fsm_pages
Thanks Craig, Is there a query I can run to check if the Fill Factor was changed ? The restore was executed as a single pg_restore, rather than schema then data I'm trying to get PG upgraded to 8.4, but you know it is.. Brett On 29 July 2011 04:56, Craig Ringer cr...@postnewspapers.com.au wrote: On 28/07/11 18:13, Maton, Brett wrote: postgresql v8.3.14 Can anyone help me identify why a vacuum on clean pg_restore database would give this warning? I've been told that the database was restored and not been touched since, i.e. no inserts / updates or deletes. So I'm curious as to why it appears to have been created with excessive holes. Maybe a non-default FILLFACTOR was set on some tables/indexes? Or - especially if restore was done as schema followed by data rather than all in one - the index creation and subsequent updates freed too many pages? Personally, I'd recommend moving to 8.4 or above, where you no longer need worry about the free space map at all. -- Craig Ringer
[GENERAL] Fresh Restore - relation contains more than max_fsm_pages
postgresql v8.3.14 Can anyone help me identify why a vacuum on clean pg_restore database would give this warning? I've been told that the database was restored and not been touched since, i.e. no inserts / updates or deletes. So I'm curious as to why it appears to have been created with excessive holes. The table is pretty big 499GB and contains mostly encrypted text fields. Also, for some reason the max_fsm_pages parameter has been set to 1,500,000 Thanks in advance for any help. Brett