Dear Group, Please help me if you can. I am in a the most gravest situation. here I read the bug report : https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=143208 reason: I got error when i tried \dt relation "pg_catalog.pg_user" does not exist. After reading some responses Comment#21 and Comment#22 (I have no clue why I am getting that error and no idea about SELinux). I tried the following: $sudo /etc/rc.d/init.d/postgresql stop $ psql -d mrnatest psql: could not connect to server: S Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? $ sudo rm -rf /var/lib/pgsql/data $ sudo /sbin/restorecon -R /var/lib/pgsql $ sudo /etc/rc.d/init.d/postgresql start Initializing database: [ OK ] Starting postgresql service: [ OK ] $ psql -d mir-test psql: FATAL: database "mrnatest" does not exist $ psql -d arraydb psql: FATAL: database "arraydb" does not exist I am very much worried and I feel blood is not running any more in me. Please folks, tell me if something is really wrong. The reason I donot have a backup also is that, my pg_dump is not working. when pg_dump'ed my database I created 0 bits file. Very eagerly looking forward for some help...please.. thanks --- Srinivas Iyyer <srini_iyyer_bio@xxxxxxxxx> wrote: > *** Apologies for re-posting this e-mail **** > > Dear group, > I have a strange problem. apologies if this is the > wrong place, however as a first option i am posting > here. I have to subscribe to other special mailing > lists. > > > I have two databases in my system. > > In firstdb i am having the following problem: > firstdb=# \d targets > ERROR: could not access status of transaction 362 > DETAIL: could not open file > "/var/lib/pgsql/data/pg_clog/0000": No such file or > directory > > when I vacuumed it: > $ vacuumdb firstdb > vacuumdb: vacuuming of database "firstdb" failed: > ERROR: could not access status of transaction 11 > DETAIL: could not open file > "/var/lib/pgsql/data/pg_clog/0000": No such file or > directory > > > > Second problem: > > Issue with secondb - arraydb > > > > $ vacuumdb arraydb > VACUUM > > Suspecting there is something going on with > postgres, > I wanted to take a backup of the arraydb. > > here is what I am doing: > > $ sudo pg_dump arraydb > > arraydb_bcup_Aug_05_2006.dump > > $ ls -lh > total 8.0K > -rw-r--r-- 1 speri postgres 0 Aug 5 20:17 > arradb_bcup_Aug_05_2006.out > > > There is nothing in this. I created dumps long back > and they are heavy. > > what could be the problem in the cases of first and > second problems. > > looking forward to hear from experts eagerly. > > Thanks > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to > majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list > cleanly > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
