Search Postgresql Archives

Request to share information regarding postgresql pg_xlog file.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear Team,

 

Thanks for your support and suggestion.

We are using below postgresql rpm.

postgresql-8.1.18-2.1

 

In our system, below error is found and occurring is very frequent.

 

CONTEXT:  writing block 53 of relation 1663/16385/280951

ERROR:  could not open relation 1663/16385/280951: No such file or directory

 

Due to this, size of pg_xlog is increasing continuous.

Could you please share what is possible cause of this issue.

And how we can resolve this issue.

 

Also , we tried to stop the postgresql but it couldn’t stop and timout after 60 sec.

please confirm below message in postgre logs.

FATAL:  terminating connection due to administrator command

 

Regards,

Yogesh


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux