Gene Hart writes:
> select * from pg_prepared_xacts;
> returns 0 rows.
Hm. You might also confirm that the directory $PGDATA/pg_twophase/ is
empty, but it really should be if there's nothing in that view.
I think you'll have to do some more sleuthing. Check the
pg_database.datfrozenxid value f
select * from pg_prepared_xacts;
returns 0 rows. Is there anything else I could check to see why the backend
wouldn't accept commands?
thanks,
Gene
On Jun 27, 2010, at 9:37 AM, Scott Marlowe wrote:
> On Sun, Jun 27, 2010 at 9:27 AM, Gene Hart wrote:
>> I'm getting the following errors and I'm
Yeah I did wait long enough for the vacuum to finish. I did consider the
prepared_transactions issue but I don't think we are using those. I'll look
down that path though since I could be wrong about that.
On a related note I thought in 8.4 a successive vacuum would not take as long
as the pri
Bill Moran writes:
> In response to Gene Hart :
>> PostgreSQL stand-alone backend 8.4.4
>> backend> vacuum
>> backend> ^D^D
>> exit
> Am I reading this wrong or did you not bother to allow the vacuum to finish?
> Considering there's no command terminator (;) on the vacuum command, it's
> unlikely
In response to Gene Hart :
> I'm getting the following errors and I'm not quite sure what to do at this
> point. The database is very large and I can't get it to accept commands.
> Please help!
>
> maindb =# create table test1();
> ERROR: database is not accepting commands to avoid wraparound
On Sun, Jun 27, 2010 at 9:27 AM, Gene Hart wrote:
> I'm getting the following errors and I'm not quite sure what to do at this
> point. The database is very large and I can't get it to accept commands.
> Please help!
>
> maindb =# create table test1();
> ERROR: database is not accepting command
I'm getting the following errors and I'm not quite sure what to do at this
point. The database is very large and I can't get it to accept commands. Please
help!
maindb =# create table test1();
ERROR: database is not accepting commands to avoid wraparound data loss in
database "maindb"
HINT: S
