I want to migrate physical server on to virtual machine
My physical server consist of
1. Some Application.
2. PostgreSQL Database
Here the system migrated from Physical machine will be replicated into two
VM's.
- One will be act as live machine, on which live operations will be
performed.
-
We're looking into options for the least intrusive way of moving our
pg_data onto faster storage. The basic setup is as follows :
6 disk RAID-0 array of EBS volumes used for primary data storage
2 disk RAID-0 array of EBS volumes used for transaction logs
RAID arrays are xfs
It's the primary
Hi all,
I am trying to set up Postgres 9.2 in HA mode. But i have noticed something
strange happening with the xlogs being generated after a switch over.
Problem:
When a standby is promoted to master mode its not choosing a new timeline
to work with. Can anyone please help me with the situations
On Thu, May 30, 2013 at 12:19 PM, Andrew W. Gibbs awgi...@awgibbs.comwrote:
Going with your first option, a master-slave replication, has the
added benefit that you build the expertise for doing Continuous Point
In Time Recovery, and after you do this storage system migration you
can use that
Hi, everyone.
I saw some people talking about the reindex command and I read in the docs
the one reason to use reindex is when a table is bloated.
But how do I know when a table is bloated?
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 2:50 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
Well, maybe I am.
But I am worried because I know that there are some tables that do lots of
On Thu, May 30, 2013 at 3:55 PM, Igor Neyman iney...@perceptron.com wrote:
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 2:50 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
Well, maybe I am.
Hi
I want to know the meaning of these fields specifically :
*Latest checkpoint location: 0/5F20*
*Prior checkpoint location:0/5E20*
*Latest checkpoint's REDO location:0/5F20*
*
*
*Latest checkpoint's NextXID: 0/1894*
*
*
*Latest checkpoint's
On Thu, May 30, 2013 at 6:05 AM, Rodrigo Barboza
rodrigombu...@gmail.com wrote:
I saw some people talking about the reindex command and I read in the docs
the one reason to use reindex is when a table is bloated.
But how do I know when a table is bloated?
Take a look at the pgcompactor tool
On Fri, May 31, 2013 at 2:06 AM, Sergey Konoplev gray...@gmail.com wrote:
On Thu, May 30, 2013 at 6:05 AM, Rodrigo Barboza
rodrigombu...@gmail.com wrote:
I saw some people talking about the reindex command and I read in the
docs
the one reason to use reindex is when a table is bloated.
10 matches
Mail list logo