On Fri, Feb 24, 2012 at 2:30 AM, seha <blackroos...@yahoo.com> wrote: > > 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
That's the wrong direction. Try just copying /etc/postgres/8.2/main/postgresql.conf to /var/lib/postgresql/8.2/main/. Worked for me. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
