davi vidal wrote:
> On Thu, Jan 22, 2015 at 3:48 PM, Alvaro Herrera <alvherre@2ndquadrant.com>
> wrote:
>
> > davi vidal wrote:
> > > On Thu, Jan 22, 2015 at 1:18 PM, Alvaro Herrera <
> > alvherre@2ndquadrant.com>
> > > wrote:
> >
> > > The 9.1 cluster is empty.
> > >
> > >
> > > # ls -a /var/lib/pgsql/9.4/data/pg_subtrans/
> > > . .. 06F8
> >
> > How big is this file?
> >
> 40 KB
>
> I can't open it using vim.
Yeah, it's a binary file, don't worry about that.
Anyway that's pretty odd. I assume that your blocksize is 8 kB. Then
this file is 5 pages long, but the system is asking for data that should
be in page 11. For some reason 6 page extensions in pg_subtrans were
ignored? That sounds really odd.
I'm also surprised that the subdir in 9.1 is empty. The file certainly
should still be there.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services