Re: [BUGS] On-line backup

2005-11-29 Thread Bruno Wolff III
On Tue, Nov 29, 2005 at 01:21:12 +0100, Diego Cattelan <[EMAIL PROTECTED]> wrote: > > >What exact commands are you using for both the backup and the restore? > > > - at boot time the linux box mount a smb share '/mnt/walarchive810' > - I have modified postgresql.conf parameter > archive_co

Re: [BUGS] On-line backup

2005-11-29 Thread Jim C. Nasby
Ahh, ok. There's a couple issues here. Both the data files and WAL logs are in a binary format that is not necessarily compatable across different OSes. I don't know if linux to windows should work by design or not, but it wouldn't surprise me if it won't work. Another issue is hardware. One examp

Re: [BUGS] On-line backup

2005-11-28 Thread Diego Cattelan
What exact commands are you using for both the backup and the restore? - at boot time the linux box mount a smb share '/mnt/walarchive810' - I have modified postgresql.conf parameter archive_command='cp -i /mnt/walarchive810/%f - now I have run a script wich updates a database in the lin

Re: [BUGS] On-line backup

2005-11-28 Thread Jim C. Nasby
What exact commands are you using for both the backup and the restore? On Mon, Nov 28, 2005 at 02:38:27PM +0100, [EMAIL PROTECTED] wrote: > Is it possible to do an online backup from linux to windows ? > > Postgres : 8.1.0 > linux : Centos 4.2 , 32 bit > windows : 2000 Server , 32 bit > > When I