[GENERAL] Installing postgis-pg90-setup-1.5.2-3 on windows after installing postgresql-9.0.1-1-windows_x64 errors off

2010-11-01 Thread John Mitchell
Hi, Installing postgis-pg90-setup-1.5.2-3 on windows after installing postgresql-9.0.1-1-windows_x64 errors off (see below error). I believe that postgres is a 64 bit application and postgis is a 32 bit application so I don't know if that is the reason why it errors off. *psql:C:/Program Files/P

Re: [GENERAL] What locking mechanism is used for database backup and restore and Master-Slave Replication?

2010-01-22 Thread John Mitchell
that big, but obviously once the new version is out - it will be even > less of a problem, since postgresql already produces transactional log > for recovering, and pretty much the same log is going to be used for > replication. > > > 2010/1/21 John Mitchell : > > So am I to presu

Re: [GENERAL] What locking mechanism is used for database backup and restore and Master-Slave Replication?

2010-01-21 Thread John Mitchell
So am I to presume that the current stable version of postgres (before 8.5) does require extra locking? John 2010/1/21 Grzegorz Jaƛkiewicz > On Thu, Jan 21, 2010 at 1:12 PM, John Mitchell > wrote: > > Hi, > > > > In reading the documentation it states that the

[GENERAL] What locking mechanism is used for database backup and restore and Master-Slave Replication?

2010-01-21 Thread John Mitchell
Hi, In reading the documentation it states that the SQL dump backup does not block other operations on the database while it is working. I presume that while a restore is occurring that no reads or updates are allowed against the restored database. What locking mechanism is used for Master-Slave

[GENERAL] When running pgsql2shp it truncates fields that are over 10 characters. How can I prevent this from occurring?

2009-11-15 Thread John Mitchell
When running pgsql2shp it truncates fields that are over 10 characters. How can I prevent this from occurring? John -- John J. Mitchell

Re: [GENERAL] How do I connect postgres table structures and view structures to an existing svn repository?

2007-08-01 Thread John Mitchell
be similar to what I currently do with source code that I have for a web app within eclipse. On 8/1/07, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > > John Mitchell schrieb: > > Hi, > > > > How do I connect postgres table structures and view structures to

[GENERAL] How do I connect postgres table structures and view structures to an existing svn repository?

2007-08-01 Thread John Mitchell
Hi, How do I connect postgres table structures and view structures to an existing svn repository? Thanks, -- John J. Mitchell