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, 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 agai

Re: [GENERAL] List Permissions

Bingo! Thanks very much On 25 October 2011 13:47, Raghavendra wrote: > On Tue, Oct 25, 2011 at 6:04 PM, Maton, Brett wrote: > >> Thanks for the replies. >> Actually this was question posed by one of my colleagues, what he really >> wants to know is if there is t

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 wrote: > My answers

[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] 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 > El 27/08/2011, a las

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 > On Fri, 2011-08-26 at 13:33 +0100, Brett Mato

Re: [GENERAL] Fresh Restore - relation contains more than "max_fsm_pages"

t; 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

[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