Re: On-line backup

On Tue, Nov 29, 2005 at 01:21:12 +0100,
  Diego Cattelan <netmaniac@libero.it> 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_command='cp -i /mnt/walarchive810/%f </dev/null'
> - restarting postgres shows that wal files are correctly archived
> - install postgres 8.1 on win 2000 server and test if work: ok
> - stop postgres set postgres service start mode to manual
> - connect to postgres on linux
> - issue command select ps_start_backup('contab')
> - used tar to archive the data folder as database.tar.gz
> - select pg_stop_backup()
> - copy database.tar.gz on windows

I don't think you can count on linux and windows versions on postgres being
binary compatible.