From: | Dianne Yumul <dianne(at)wellsgaming(dot)com> |
---|---|
To: | akopciuch(at)bddf(dot)ca |
Cc: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Restoring from filesystem backup |
Date: | 2005-11-11 17:39:53 |
Message-ID: | 2f1d751425a4c0bdcfd3825973e5239b@wellsgaming.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the response.
> does the global directory exist on the drive you are syncing from? If
> so ...
> then it's a problem with your rsync.
>
> check the options you are using with the rsync command.
> check the rsync configurations in /etc/rsyncd.conf on the drive.
> what user are you running the rsync daemon, and rsync command as?
The global directory was not on the backup I was syncing from. The
option we use with rysnc is just -a. We also don't run the rsync daemon
(is this ok?) just the command.
I checked the other backups and they all have the global directory
except for this specific one. Looking further, I think something went
wrong on that backup because some directories not related to postgres,
not just global/, are empty. So now I'm thinking it might be hardware
(the portable external drive is about 3 years old), but I will have to
wait and see if the problem persists.
Sorry for making noise and thank you very much for your help.
Dianne
On Nov 10, 2005, at 6:17 PM, Andrew J. Kopciuch wrote:
>> My questions are (1) what am I doing wrong that the filesystem backups
>> would sometimes have an empty /home/postgres/data/global directory,
>> thereby not permitting me to restore from it, and (2) what is the
>> preferred way to restore from a file system backup.
>>
>
> does the global directory exist on the drive you are syncing from? If
> so ...
> then it's a problem with your rsync.
>
> check the options you are using with the rsync command.
> check the rsync configurations in /etc/rsyncd.conf on the drive.
> what user are you running the rsync daemon, and rsync command as?
>
> That should point you in the direction to solve your problem.
>
>
>
> Andy
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2005-11-11 17:43:14 | Re: Best way to use indexes for partial match at |
Previous Message | Tom Lane | 2005-11-11 17:22:00 | Re: I'm getting "ERROR: unsupported type: 17296" |