When I try to connect to a database, I get the following error : psql teleflowdb8 psql: FATAL: database is not accepting commands to avoid wraparound data loss in database "teleflowdb8" HINT: Stop the postmaster and use a standalone backend to vacuum database "teleflowdb8". Then I try to go to standalone mode: $./postgresql-8.2 stop $su postgres $cd /usr/lib/postgresql/8.2/bin $./postgres --single -D /var/lib/postgresql/8.2/main/ teleflowdb8 I got the following error : --single cannot access the server configuration file "/var/lib/postgresql/8.2/main/postgresql.conf": No such file or directory When to check the postgresql.conf file is located at /etc/postgresql/8.2/main $ls environment log pgdata pg_hba.conf pg_ident.conf postgresql.conf start.conf So I did : $./postgres --single -D /etc/postgresql/8.2/main teleflowdb8 But error as follows. 2012-02-24 19:04:28 SGT FATAL: "/etc/postgresql/8.2/main" is not a valid data directory 2012-02-24 19:04:28 SGT DETAIL: File "/etc/postgresql/8.2/main/PG_VERSION" is missing. I do not have the /var/lib/pgsql/data directory. Can anyone help on this issue. TQ -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-vacuum-from-standalone-backend-tp3305010p5512163.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
