Re: Restoring from filesystem backup - Mailing list pgsql-general

From Dianne Yumul
Subject Re: Restoring from filesystem backup
Date
Msg-id 2f1d751425a4c0bdcfd3825973e5239b@wellsgaming.com
Whole thread Raw
In response to Restoring from filesystem backup  (Dianne Yumul <dianne@wellsgaming.com>)
List 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
>


pgsql-general by date:

Previous
From: Robby Russell
Date:
Subject: Re: A good postgresql book
Next
From: Bruno Wolff III
Date:
Subject: Re: A good postgresql book