Web Hosting Talk







View Full Version : postgresql server cannot start


nozol
04-24-2002, 04:47 AM
Hi,

I have a problem with postgresql which prevents it from starting. Which also affects the cobalt control panel and makes it do not display any users or sites.

here is the error from the log of postgresql.

----------
020423.18:00:06.392 [23721] FATAL 1: cannot read block 0 of pg_shadow
Smart Shutdown request at Tue Apr 23 18:00:06 2002
020423.18:00:06.583 [23746] DEBUG: Data Base System shutting down at Tue Apr 23 18:00:06 2002
020423.18:00:06.584 [23746] DEBUG: Data Base System shut down at Tue Apr 23 18:00:06 2002
020423.18:00:08.825 [23761] DEBUG: Data Base System is starting up at Tue Apr 23 18:00:08 2002
020423.18:00:08.826 [23761] DEBUG: Data Base System was shut down at Tue Apr 23 18:00:06 2002
020423.18:00:08.827 [23761] DEBUG: Data Base System is in production state at Tue Apr 23 18:00:0$
020423.18:00:20.359 [23789] FATAL 1: cannot read block 0 of pg_shadow
-----------

any ideas?

Regards,

Ahmed

nozol
04-25-2002, 09:47 AM
The problem is fixed now. Thank you.

Just moved the pgsql directory from /var/lib to /home after restoring it from backup.