Re: Postgresql-8.4: File System Level Backup (& recovery failure)

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [201112, 17:04]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> > * Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [201112, 12:30]:
>
> In that case, in principle restoring the backup should work. Are you
> sure you copied the entire $PGDATA directory tree? If you omitted
> portions like pg_xlog or pg_clog that could be problematic.

I think so; this is exactly the command I gave:

\cp -a -u -f -r /var/lib/postgres*/8.4 /mnt/wd2/hda*/var/lib/postgresql/

(the reverse slash for 'cp' was to overcome my alias settings for the
command)
For sure the receiving directory did have an older backup ...

> What failure messages do you get *exactly*?

No failure message at all: the '=> \d' command just says 'No relations
found"

Perusing the files in the 'imported' directory I saw something that
could be stramge:
(The command was:
"less /bkupdir/var/lib/postgresql/8.4/main/postmaster.opts":
/usr/lib/postgresql/8.4/bin/postgres "-D" "/var/lib/postgresql/8.4/main" \
"-c" "config_file=/etc/postgresql/8.4/main/postgresql.conf" \
"-c" "external_pid_file=/var/run/postgresql/8.4-main.pid"
????????????????

Would that mean that the older files (overwritten by the '-u' cp option)
were copied while postgres was running?

Thanks again. Regards, ennio.

PS: How is it that when I created the new cluster in the brand new
directory '/dbase/ whith the command:
# pg_createcluster -D /dbase -start 8.4 new
the subdir 'new' was not added to /dbase?

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]