Re: [GENERAL] lock database share

2012-11-05 Thread Alan Hodgson
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 a

[GENERAL] lock database share

2012-11-05 Thread salah jubeh
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

Re: [GENERAL] LOCK DATABASE

2011-12-17 Thread Josh Kupershmidt
On Thu, Dec 15, 2011 at 2:01 PM, Scott Marlowe wrote: > On Thu, Dec 15, 2011 at 10:17 AM, Eliot Gable > wrote: >> Is this bogus, or is it an upcoming feature? >> >> http://wiki.postgresql.org/wiki/Lock_database LOCK DATABASE was brought up earlier this year: http://archives.postgresql.org/pgsq

Re: [GENERAL] LOCK DATABASE

2011-12-15 Thread Scott Marlowe
On Thu, Dec 15, 2011 at 10:17 AM, Eliot Gable wrote: > Is this bogus, or is it an upcoming feature? > > http://wiki.postgresql.org/wiki/Lock_database The page says: "This functionality is not implemented in PostgreSQL, and is not planned to be yet" So I'd gues it's an ansi SQL Spec command that

[GENERAL] LOCK DATABASE

2011-12-15 Thread Eliot Gable
Is this bogus, or is it an upcoming feature? http://wiki.postgresql.org/wiki/Lock_database -- Eliot Gable "We do not inherit the Earth from our ancestors: we borrow it from our children." ~David Brower "I decided the words were too conservative for me. We're not borrowing from our children, w