From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Diego Cattelan <netmaniac(at)libero(dot)it> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: On-line backup |
Date: | 2005-11-29 21:50:13 |
Message-ID: | 20051129215013.GA32253@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Nov 29, 2005 at 01:21:12 +0100,
Diego Cattelan <netmaniac(at)libero(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre Beyssac | 2005-11-29 21:56:03 | BUG #2078: lock freeing problem in transaction (?) |
Previous Message | Tom Lane | 2005-11-29 21:07:16 | Re: pg_dump: schema with OID 559701082 does not exist |