Thread: lock database share

On Monday, November 05, 2012 05:15:41 AM salah jubeh wrote:
> Hello,
>
> I have the following scenario, I would like to upgrade a database server
> from 8.3 to 9.1. The upgrade includes also a hardware upgrade.
>
>
> I would like to have the following
>
> 1. Make sure that the upgraded server and the old server have the same
> snapshot of data. 2. Make sure that the old server data is accessible for
> read only after taking the data snapshot until making the new server alive
> and tested
>
>
> The lock database command is not yet implemented, so what are the ways to
> hack this command.  Also,  I need to make sure that the server is down for
> very short time, so is there a better way than using pg_dump and pg_restore
> for different database server versions ?
>
> Regards

Using Slony to assist in your migration will meet all your requirements:

http://slony.info/

You should read the documentation thoroughly.  And try everything out on test
machines before doing it to your production servers.