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_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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org