[ADMIN] Migration and snapshot of database

2013-05-30 Thread aarti sawant
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. -

[ADMIN] Least intrusive way to move primary data

2013-05-30 Thread Armand du Plessis
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

[ADMIN] Standby doesn't chose a new timeline when promoted to master

2013-05-30 Thread prakhar jauhari
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

Re: [ADMIN] Least intrusive way to move primary data

2013-05-30 Thread Armand du Plessis
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

[ADMIN] How do I know my table is bloated?

2013-05-30 Thread Rodrigo Barboza
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?

Re: [ADMIN] How do I know my table is bloated?

2013-05-30 Thread Igor Neyman
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

Re: [ADMIN] How do I know my table is bloated?

2013-05-30 Thread Rodrigo Barboza
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.

Re: [ADMIN] Output of pg_controldata

2013-05-30 Thread Virupaksha Kanjilal
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

Re: [ADMIN] How do I know my table is bloated?

2013-05-30 Thread Sergey Konoplev
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

Re: [ADMIN] How do I know my table is bloated?

2013-05-30 Thread Rodrigo Barboza
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.