[ADMIN] lost permissions?

2003-10-25 Thread Laszlo Hornyak
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),

[ADMIN] Performance failure / automatic restart / cron ?

2003-10-25 Thread Piotr TrawiƄski
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

[ADMIN] Performance failure / automatic restart / cron ?

2003-10-25 Thread piotr
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