> postgres -D /var/lib/pgsql/data patnadbold < fix.sql What the heck is the point of feeding "VACUUM FULL;" into the standard input of the postgres command? "postgres" simply starts the server, it does not execute arbitrary SQL. Once the database is started you want to use "psql" - either interactively or in a similar manner to the above - to connect to the <patnadbold> database and run "VACUUM". Note that: "su postgres" -> "psql" will likely connect you to the "postgres" database as that is the normal default. You will need to tell psql which database to connect to. > PostgreSQL stand-alone backend 8.1.11 8.1 is unsupported at this point; plus you say 8.4 below which this contradicts. Your configuration is very unclear. > ERROR: could not access status of transaction 33011 > DETAIL: could not open file "pg_clog/0000": No such file or directory > exit This is bothersome as well... > After this i am able to stop /start my db server but i am not able to > connect to my databases (it tells to run vacuum full first on patnadbold > databases) > > > 1)I am using postgres 8.4 version. > 2) I had two databases on this server i) patnadbold ii) patnaonlinedb > > For me patnadbold is of no use if at this moment i lost this database that > also fine to me. > I wanted to connect patnaonlinedb any how and wanted to perform backup of > this , Solution please. The only thing not mentioned is starting postgres is single-user mode; this may be necessary though I am not sure and others can be of more help. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Urgent-Help-Required-tp5773675p5773716.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
