On Fri, 2010-07-09 at 10:25 -0700, Kasia Tuszynska wrote:
> Since the topic is very relevant to me right now I would like to ask if
> anyone is running a HA solution in the cloud?
While running databases in a cloud does come with it's own set of
issues/challenges, I don't see what would be materi
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barely r
On Fri, 2010-07-09 at 15:31 +0200, Henry, Frank wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barel
On Wed, Jul 7, 2010 at 9:49 AM, Rob Richardson
wrote:
>
> I wanted to try using the ODBC driver for PostgreSQL 8.4. But when I
> installed it, I was surprised and dismayed to see that the old driver no
> longer appeared in the list of available drivers when I tried to create a
> new DSN. At firs
Since the topic is very relevant to me right now I would like to ask if anyone
is running a HA solution in the cloud?
Thanks,
Kasia
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Brad Nicholson
Sent: Friday, July 09, 2010
On Fri, 2010-07-09 at 18:31 +0200, Thomas Kellerer wrote:
> Hi,
>
> Rob Wultsch wrote on 09.07.2010 18:14:
> >> I am aware that I can use the 9.0 standby server for read only queries, but
> >> that is (currently) not something we need
> >>
> >
> > Taking SQL backups without impacting the master mi
Thomas Kellerer wrote:
> So my assumption is correct that streaming replication does mean
> that in case of a failover less transactions are lost?
Yes, that is correct.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www
Hi,
Rob Wultsch wrote on 09.07.2010 18:14:
I am aware that I can use the 9.0 standby server for read only queries, but
that is (currently) not something we need
Taking SQL backups without impacting the master might be something to consider.
Interesting point. Thanks for mentioning that.
On Fri, Jul 9, 2010 at 4:51 AM, Thomas Kellerer wrote:
> Hi,
>
> we are contemplating the possibilities for a Postgres HA installation.
>
> As the rollout is targeted towards the end of the year, 9.0 and it's new
> features might be an option for us.
>
> Now from a HA point of view, what is the ma
Scott Marlowe writes:
> On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank wrote:
>> What is it?
> Why don't you tell us?
The exact name of the file might be useful information, too.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
On Fri, Jul 9, 2010 at 7:31 AM, Henry, Frank wrote:
> Hello everyone,
>
> We had a problem with one of our servers and had noticed that the
> postgres/8.3/main folder had become quite large (>650mb).
> PostgreSQL confirmed this via a query but when I queried the size of the
> tables I was barely r
Hi,
Recently we upgraded our production server from 7.5GB RAM to 15GB RAM.
1. To solve performance issue.
2. Also the number of concurrent users increased from 150 to 300.
Our production server is not dedicated server. We have also
1. Tomcat
2. Apache
3. Cron based sch
Hello everyone,
We had a problem with one of our servers and had noticed that the
postgres/8.3/main folder had become quite large (>650mb).
PostgreSQL confirmed this via a query but when I queried the size of the
tables I was barely reaching 3mb.
After looking around, I found one file with about
"Gnanakumar" wrote:
> max_connection
> From - 500
> To - 500
>
> PGPOOL configuration
> -
> num_init_children
> From - 150
> To - 420
> child_max_connections
> From - 20
> To - 30
> We have more than 300 Users accessing our server con
You can use
select client_addr, current_query from pg_stat_activity;
to show all db-connection and the running queries.
Regards,
murphy
Von: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org]
Im Auftrag von VĂtor
Gesendet: Freitag, 2. Juli 2010 14:10
An: pgsql-admin@po
Hi,
we are contemplating the possibilities for a Postgres HA installation.
As the rollout is targeted towards the end of the year, 9.0 and it's new
features might be an option for us.
Now from a HA point of view, what is the major difference between 9.0's Hot
Standby and 8.x's Warm Standby?
Hi,
Recently we upgraded our production server RAM from 7.5GB to 15GB for the
following reasons:
1. to solve performance issues
2. the number of concurrent users increased from 150 to 300
Our production server is not a dedicated database server and is being shared
with our other a
17 matches
Mail list logo