[ADMIN] Is there any support like "for update wait N" in PostgreSQL?

2011-12-06 Thread fanlijing
Hello, Laurenz I'm sorry for replying you so late.. Thank you for your advice below. Finally we decide to port it as a shell using the copy command. Actually, now I'm confused with another problem, that is: Oracle: for update wait 10 PostgreSQL: no support for the parameter "wait"

[ADMIN] Postgres recommended by a SQL Server DBA

2011-12-06 Thread Tim Bruce - Postgres
An interesting write-up coming from a SQL Server DBA. http://facility9.com/2011/12/ten-reasons-postgresql-is-better-than-sql-server/ Tim -- Timothy J. Bruce -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailp

Re: [ADMIN] Recover from failover

2011-12-06 Thread Martin S
On Mon, Dec 5, 2011 at 11:58 PM, white.heron white wrote: > Dear All, > > As soon as the slave database server had been promoted to master. The > old-server master database should be promote to become slave server. > I believe database replication has been done by your vendor. In this case > the n