[GENERAL] Understanding postgresql logs

I have a PostgreSQL 9.0/9.2 which from time to time hits some memory issues. I know the best approach is to monitor the DB performance and activity but in the log files I see error messages similar to: TopMemoryContext: 221952 total in 17 blocks; 7440 free (41 chunks); 214512 used TopTransactio

[GENERAL] GRANT privileges strange behavior

Hi, I have the following situation: postgres=# create database foo with encoding = 'UTF8'; postgres=# \c foo foo=# CREATE SCHEMA sc; foo=# ALTER DATABASE foo SET search_path=sc, pg_catalog; foo=# CREATE ROLE usr LOGIN PASSWORD 'usr' NOINHERIT CREATEDB VALID UNTIL 'infinity'; foo=# grant all privi