[GENERAL] Improve replication usability

2011-12-10 Thread Andrew Armstrong
Hello, First off, thanks for a great product. I've been looking at setting up replication on Windows between two servers using pgsql 9.1 I'm going to give up for now though because I'm finding it difficult to get it working correctly; after copying the \data directory as per the guide at http://

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

2007-08-15 Thread Andrew Armstrong
I don't know how PSQL does it, but MySQL has an SQL_CALC_FOUND_ROWS extension which allows the query to also return how many rows exist without the LIMIT clause. Perhaps there is similar for PSQL (check LIMIT docs?) - Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC