* Tom Lane <tgl@sss.pgh.pa.us> [201112, 17:04]:
> Ennio-Sr <nasr.laili@tin.it> writes:
> > * Tom Lane <tgl@sss.pgh.pa.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) ]