Hi all!
I run PostgreSQL 7.3.4 for a time without any problem. Today morning one
group of the database users have lost its permission on two tables, so
they couldn`t work. I have statement loging on, so i have searched the
log file for REVOKE statements (if the other DBA did something wrong),
I have this notorious problem: at some point pgsql simply hangs up and
requires a restart.
---
---
homer:/usr/share/doc/postgresql-contrib# /etc/init.d/postgresql restart
Restarting PostgreSQL database: postmaster
Stopped
I have this notorious problem: at some point pgsql simply hangs up and
requires a restart.
---
---
homer:/usr/share/doc/postgresql-contrib# /etc/init.d/postgresql restart
Restarting PostgreSQL database: postmaster
Stopped