On Fri, Feb 24, 2012 at 2:30 AM, seha <blackroose89@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.