Re: [ADMIN] debug issue on postgresql

2008-05-11 Thread MARIOTTI, Alessandro (Alessandro)
Guillaume, Well I could shortly describe what's happen on these machines ; On May 7 2008 at 23:25 an operator performed : _a configuration change ; _add a new user on a table named MVNO; Customer told us that for "new user" operator add comma "," symbol. This is something new for their

Re: [ADMIN] Orphan TOAST object

2008-05-11 Thread Tom Lane
"James Farrugia" <[EMAIL PROTECTED]> writes: > I'm running 8.2.1. You really need to update to 8.2.latest. There are several known data-corruption problems in 8.2.1, and it seems possible that one of them ate the pg_depend row you needed. > I cleanly forgot about pg_depend! > Even after re-index

Re: [ADMIN] Orphan TOAST object

2008-05-11 Thread Tom Lane
"James Farrugia" <[EMAIL PROTECTED]> writes: > I wonder whether any of you can help me out with this problem. What PG version is this? > To get vacuum the TOAST object we created a temporary table foo (col1 > char(1)) and assigned its reltoastrelid (up till now set to 0) to > pg_toast_35027430's

[ADMIN] Orphan TOAST object

2008-05-11 Thread James Farrugia
Hi all, I wonder whether any of you can help me out with this problem. We were performed a routine "lazy" VACUUM in order to reassign frozen XIDs and prevent data-loss. After the VACUUM completed successfully, the command "SELECT datname, age(datfrozenxid) FROM pg_database" still showed an exces

Re: [ADMIN] Require security ACCESS matrix in prostgresql !!

2008-05-11 Thread Tino Schwarze
On Sun, May 11, 2008 at 09:29:01AM -0500, Potluri Srikanth wrote: > can anyone provide me the security ACCESS matrix in prostgresql ? Have a look at the fine manual: http://www.postgresql.org/docs/8.3/static/privileges.html HTH, Tino. -- "What we resist, persists." (Zen saying) www.craniosa

[ADMIN] Require security ACCESS matrix in prostgresql !!

2008-05-11 Thread Potluri Srikanth
Hi all, can anyone provide me the security ACCESS matrix in prostgresql ? security involving ROLES, access priviledges , etc ... i am novice in the field of security implementation, hence i request you if you can provide me examples or PPT or MATRIX sheet to understand the security in postgres