On Friday, April 4, 2014 5:39:54 PM UTC-7, Daniel Farina wrote: > > On Fri, Apr 4, 2014 at 5:24 PM, Joe Van Dyk <[email protected]<javascript:>> > wrote: > > On Friday, April 4, 2014 4:10:59 PM UTC-7, Daniel Farina wrote: > >> > >> On Fri, Apr 4, 2014 at 3:41 PM, Joe Van Dyk <[email protected]> wrote: > >> > $ sudo ls -l /mnt/postgresql/9.3 > >> > ... > >> > drwx------ 2 postgres postgres 4096 Apr 4 15:30 pg_subtrans > >> > > >> > I don't know much about the internals of pg_subtrans -- does it exist > on > >> > all > >> > postgresql installations? Or is it created as needed? > >> > > >> > All the subtrans directories on the master look like they were > recently > >> > created, what would happen if that directory was created after the > wal-e > >> > basebackup was taken? The wal-e base backup was taken before 9 am > today. > >> > >> It *should* always exist. initdb makes one. the files within are > >> bitmaps IIRC. Is your leader database (thing being backed-up) > >> pg_subtrans directory new somehow? > >> > >> Is your pg_subtrans newer than, say, the "base" directory, or the > >> other slew of directories seen in "initdb" ? > > > > I'm not sure how to figure out when a directory was created -- I know > how to > > get last access, modified, and changed dates. > > The change time is probably best. > > Maybe a dump of this would help: > > ls -ldc $PGDATA/* >
$ ls -ldc /mnt/postgresql/9.3/* -rw------- 1 postgres postgres 213 Nov 10 12:00 /mnt/postgresql/9.3/backup_label.old drwx------ 8 postgres postgres 4096 Nov 12 14:10 /mnt/postgresql/9.3/base drwx------ 2 postgres postgres 4096 Apr 4 04:51 /mnt/postgresql/9.3/global drwx------ 2 postgres postgres 4096 Apr 4 18:08 /mnt/postgresql/9.3/pg_clog -rw------- 1 postgres postgres 1915 Apr 4 11:05 /mnt/postgresql/9.3/pg_hba.conf -rw------- 1 postgres postgres 1636 Nov 10 11:59 /mnt/postgresql/9.3/pg_ident.conf drwx------ 4 postgres postgres 4096 Nov 10 11:59 /mnt/postgresql/9.3/pg_multixact drwx------ 2 postgres postgres 4096 Mar 24 22:05 /mnt/postgresql/9.3/pg_notify drwx------ 2 postgres postgres 4096 Nov 10 11:59 /mnt/postgresql/9.3/pg_serial drwx------ 2 postgres postgres 4096 Nov 10 11:59 /mnt/postgresql/9.3/pg_snapshots drwx------ 2 postgres postgres 4096 Mar 24 22:05 /mnt/postgresql/9.3/pg_stat drwx------ 2 postgres postgres 4096 Apr 4 18:26 /mnt/postgresql/9.3/pg_stat_tmp drwx------ 2 postgres postgres 4096 Apr 4 18:25 /mnt/postgresql/9.3/pg_subtrans drwx------ 2 postgres postgres 4096 Nov 10 11:59 /mnt/postgresql/9.3/pg_tblspc drwx------ 2 postgres postgres 4096 Nov 10 11:59 /mnt/postgresql/9.3/pg_twophase -rw------- 1 postgres postgres 4 Nov 10 11:59 /mnt/postgresql/9.3/PG_VERSION lrwxrwxrwx 1 postgres postgres 18 Nov 10 11:59 /mnt/postgresql/9.3/pg_xlog -> /mnt1/pg_xlogs/9.3 -rw------- 1 postgres postgres 1051 Jan 1 23:30 /mnt/postgresql/9.3/postgresql.conf -rw------- 1 postgres postgres 73 Mar 24 22:05 /mnt/postgresql/9.3/postmaster.opts -rw------- 1 postgres postgres 73 Mar 24 22:05 /mnt/postgresql/9.3/postmaster.pid -- You received this message because you are subscribed to the Google Groups "wal-e" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
