Re: [GENERAL] Client SQL Tool

2011-11-14 Thread Brandon Phelps
On 11/14/2011 05:42 PM, John R Pierce wrote: On 11/14/11 2:32 PM, Josh Kupershmidt wrote: How does this client compare to pgAdmin (as a graphical client) or psql (as a client in general)? its a MS Windows only program using the .NET framework, and it just executes manually entered SQL

[GENERAL] Function Question - Inserting into a table with foreign constraints

2011-11-05 Thread Brandon Phelps
Hello all, Could someone give me an example as to how I would accomplish something like this with a function?: 3 tables: tableA: id (serial), name (varchar), description (varchar), subcat_id (integer) tableB: id (serial), subcat_name (varchar), cat_id (integer) tableC: id (serial),

Re: [GENERAL] Function Question - Inserting into a table with foreign constraints

2011-11-05 Thread Brandon Phelps
On 11/5/2011 10:35 AM, Raymond O'Donnell wrote: On 05/11/2011 04:34, Brandon Phelps wrote: Hello all, Could someone give me an example as to how I would accomplish something like this with a function?: 3 tables: tableA: id (serial), name (varchar), description (varchar), subcat_id (integer

Re: [GENERAL] Replication Across Two Servers?

2011-11-04 Thread Brandon Phelps
Carlos, Streaming replication was introduced in PostgreSQL 9.0 and should do what you want. http://wiki.postgresql.org/wiki/Streaming_Replication On 11/04/2011 11:47 AM, Carlos Mennens wrote: We had a 8.4.8 production server of PostgreSQL on a Dell blade server which ran for 3 years fine.

Re: [GENERAL] Replication Across Two Servers?

2011-11-04 Thread Brandon Phelps
Carlos, I would recommend you simply stick with Debian 6 and add the debian backports repository. Add the following to your /etc/apt/sources.list: deb http://backports.debian.org/debian-backports squeeze-backports main After adding that just do an 'apt-get update' and you will be able to

Re: [GENERAL] Error On Slony Replication

2011-11-02 Thread Brandon Phelps
Why do you have host= without a hostname? Where is your closing ? Brandon Phelps Global Linking Solutions O: (704) 973-6855 C: (704) 222-2103 E: bphe...@gls.com On 11/02/2011 02:34 PM, Prashant Bharucha wrote: Hello All For replication ,Created cluster and after I run Slon command getting

Re: [GENERAL] Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6

2011-10-23 Thread Brandon Phelps
By default the postgres user's group is 'daemon' on my Mac. This is probably true for you as well. Change occurrences of 'postgres:postgres' in your chown commands to 'postgres:daemon'. On 10/23/2011 8:16 PM, René Fournier wrote: […] --- Installing postgresql90-server

[GENERAL] Monitoring Replication

2011-10-12 Thread Brandon Phelps
Hello all, I use Nagios to monitor various things on a few servers and have recently set up a hot-standby server and would obviously like to include the state of streaming replication in my monitoring. I know about the pg_stat_replication view on the master and the

[GENERAL] Hot standby won't start

2011-10-10 Thread Brandon Phelps
Hello all, I have written a script which stops postgres on my standby server, executes pg_start_backup on the master, rsync's the data directory and tablespaces over to the standby, executes pg_stop_backup on the master, and attempts to then start postgresql on the standby. My problem is the

Re: [GENERAL] Connection Pooling

2011-10-07 Thread Brandon Phelps
: On Thu, Oct 6, 2011 at 3:57 PM, Brandon Phelps bphe...@gls.com mailto:bphe...@gls.com wrote: Can anyone recommend a good solution for connection pooling? Here is our setup: 2 PostgreSQL 9.1 servers (1 master, 1 hot standby). 1 Apache 2.2.17 We have a pretty extensive web

Re: [GENERAL] Connection Pooling

2011-10-07 Thread Brandon Phelps
postgresql database? Sorry, not quite understanding. On 10/07/2011 02:05 PM, Guillaume Lelarge wrote: On Fri, 2011-10-07 at 13:51 -0400, Brandon Phelps wrote: So we decided to go with pgpool-II. The documentation is a little lacking for pgpool-II so I have one question: How are connections

[GENERAL] Connection Pooling

2011-10-06 Thread Brandon Phelps
Can anyone recommend a good solution for connection pooling? Here is our setup: 2 PostgreSQL 9.1 servers (1 master, 1 hot standby). 1 Apache 2.2.17 We have a pretty extensive web application running on the apache server that talks to both of the database servers. Updates and small tasks