TutorialDBA - Support | Training | Consultant

Need your helping hand. We are facing below error in my postgres 9.2 production database. Please help us how to resolve and why we are facing this issue and impact of the issue. ERROR:  right sibling's left-link doesn't match: block 5 links to 8 instead of expected 2 in index "pg_toast_2619_index" CONTEXT:  automatic vacuum of table "qovr.pg_toast.pg_toast_2619" Solution : May be becouse of corrupted index. Try reindex on table qovr. If it didn't help. Try to drop and create index on the same table then perform vacuum and analyze. Try REINDEX TABLE pg_statistic;

I couldn't find anything in the postgresql manual as how to view its  content. SELECT does not seem to work.          What's the exact command and error message? netilla=# \dn List of schemas Name | Owner --------------------+---------- information_schema | postgres pg_catalog | postgres pg_toast | postgres public | postgres (4 rows) netilla=# select * from pg_catalog; ERROR: relation "pg_catalog" does not exist           That would be because pg_catalog is a schema; you can't select from it. If you want to see what's in there, use \dS.

Cause:  A database named 'root' does not exist on your system Solution: This error trips up new PostgreSQL users quite often. When you simply run psql from the command line it, by default, attempts to log you into a database with the same name as your current Unix user name. In this case that is 'root', but it could be 'postgres', or 'bob'. If you are setting up your database for the first time, you will need to become the PostgreSQL user ( typically 'postgres' ) which can be accomplished by either: logging in as that user su'ing to root and as root su'ing t o the postgres user

Cause: The postmaster or PostgreSQL's server daemon process is not running. Solution: Typically this error means PostgreSQL is not currently running on the system you are logged into. You will need to start the daemon, which is typically done through your distribution's init system. The easiest way to determine if PostgreSQL is running is to look for it using ps .  [nijam@host:~]$ ps -ef | grep post postgres 4335 2.4 27704 2936 14:47 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 4337 0.0 9972 548 14:47 postgres: logger process postgres 4339 0.0 27704 804 14:47 postgres: writer process postgres 4340 0.0 10972 544 14:47 postgres: stats buffer process postgres 4341 0.0 10148 668 14:47 postgres: stats collector process nijam 4346 0.0 3912 676 14:47 grep post Which as you can see means PostgreSQL is running on my local system. If we had received no results or just the final result line then we would know for certain that it is not run...