By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,057 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

When I try to connect to a database, I get the following error : psql teleflowdb8

P: 3
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
Feb 24 '12 #1
Share this Question
Share on Google+
2 Replies


P: 3
Please someone respond to this issue. tq
Feb 25 '12 #2

10K+
P: 13,264
Do you have a database initialized through the initdb command?
Feb 27 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.