From: | seha <blackroose89(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: When I try to connect to a database, I get the following error : psql teleflowdb8 |
Date: | 2012-02-24 09:30:49 |
Message-ID: | 1330075849955-5512163.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-02-24 09:59:24 | Re: COPY TO File: Using dynamic file name in stored procedure |
Previous Message | Richard Huxton | 2012-02-24 08:33:55 | Re: Problemas com client_encoding ? |