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
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),
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
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.
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
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
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
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
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
:
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
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
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
12 matches
Mail list logo