Greg Smith, 12.07.2010 18:11:
Yes, but if you try you'll discover that actually getting any shared
disk or file system replication solution setup so that you really do
achieve less failover loss than the file shipping approach will be
expensive, complicated, fragile in its own way, and just gener
We need to upgrade the postgres running on our production system under
Red Hat Enterprise Linux Server release 5.1 from version 8.1.21 to
version 8.3.6.
we could have a stop/maintenance window of 3/4 our the sum of size of
databases is around 1G .
Which is the best practice to execute such u
Hello.
I need failover postgresql installation. Two servers work's together. If
one server fail - another server doing queries.
In MySQL i'm use two server (mysql-ndb and two mysql api server (getting
queries) with mysql-proxy. If one server fail mysql-proxy route all
queries to another.
How can
http://www.postgresql.org/docs/8.4/static/high-availability.html would
be a good place to start research. And the archives of this thread
would be another - there are recent messages about this sort of thing.
And google "postgres high availability" or equivalent.
I use slony but there are plenty
On Tue, 2010-07-13 at 13:33 +0400, Vasiliy G Tolstov wrote:
> I need failover postgresql installation. Two servers work's together.
> If one server fail - another server doing queries.
> How can i do this in postgresql?
If you don't {have/want to use} shared storage, you can use WAL
replication
Am Dienstag 13 Juli 2010 11:30:20 schrieb Silvio Brandani:
> We need to upgrade the postgres running on our production system under
> Red Hat Enterprise Linux Server release 5.1 from version 8.1.21 to
> version 8.3.6.
Have a look here:
http://wiki.postgresql.org/wiki/RPM_Installation#How_do_I_per
If I create a parent table that lives in a specific tablespace, when I create
child tables that inherit the parent and then subsequently index and create a
PK on the child, will all of the index objects default to the tablespace that
the parent is built in?
Regards,
Joe Plugge
2010/7/13 Silvio Brandani :
> We need to upgrade the postgres running on our production system under Red
> Hat Enterprise Linux Server release 5.1 from version 8.1.21 to version
> 8.3.6.
>
> we could have a stop/maintenance window of 3/4 our the sum of size of
> databases is around 1G .
> Which i
Hello,
I am trying to determine what might cause an issue like this. This was a
large (several hundred GB) data warehouse server with PG 8.2.4. I can't
really determine what caused this issue. We ended up restoring the data
from a backup.
Here are some of the errors in the log:
postmaster.1
On Tue, Jul 13, 2010 at 10:29:42AM -0700, Deron wrote:
> Hello,
>
> I am trying to determine what might cause an issue like this. This was a
> large (several hundred GB) data warehouse server with PG 8.2.4. I can't
> really determine what caused this issue. We ended up restoring the data
> fr
Deron writes:
> I am trying to determine what might cause an issue like this. This was a
> large (several hundred GB) data warehouse server with PG 8.2.4. I can't
> really determine what caused this issue. We ended up restoring the data
> from a backup.
> Here are some of the errors in the l
With a 1GB database you should have no problem to perform upgrade in
three quarters of hour.
You should script database migration process in order to make it faster.
Upgrading binaries is really simple. A yum upgrade should be enough.
However, prior upgrading binaries, you should perform a databa
12 matches
Mail list logo
