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.
- Secon
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.
- Secon
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 data
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
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 knowledge to put in a place a permanent standby server.
Yes, it is a bit of work
Hello,
when i CREATE a new DATABASE, its privileges column is empty (it's not
the same case as it being '{}', which means no privileges). Empty
column means: use built-in defaults. These defaults are:
=c + owner=CTc
How can I change these defaults so that after creation PUBLIC gets no
rights? Th
On Thu, May 30, 2013 at 12:19 PM, Andrew W. Gibbs wrote:
> 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 knowledge to p
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: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Rodrigo Barboza
Sent: Thursday, May 30, 2013 9:06 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] How do I know my table is bloated?
Hi, everyone.
I saw some people talking about the reindex command
On Thu, May 30, 2013 at 11:16 AM, Igor Neyman wrote:
>
>
> From: pgsql-admin-ow...@postgresql.org [mailto:
> pgsql-admin-ow...@postgresql.org] On Behalf Of Rodrigo Barboza
> Sent: Thursday, May 30, 2013 9:06 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] How do I know my table is bloated?
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 10:42 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
On Thu, May 30, 2013 at 11:16 AM, Igor Neyman wrote:
From: pgsql-admin-ow...@postgresql.org
Well, so I need to do reindex frequentely in database? Is that right?
Or should I use cluster, as David said?
How frequently should I do this operation?
On Thu, May 30, 2013 at 11:49 AM, Igor Neyman wrote:
>
>
> From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
> Sent: Thursday, May 30, 201
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 11:10 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
Well, so I need to do reindex frequentely in database? Is that right?
Or should I use cluster, as D
I have some tables that I do a lot of updates, deletes and inserts.
So I am worried that my cluster can grow up to a huge size...
The best option would be to create a scheduled process to check if it is
bloated and if so, reindex?
On Thu, May 30, 2013 at 12:17 PM, Igor Neyman wrote:
>
>
> From:
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 12:04 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
I have some tables that I do a lot of updates, deletes and inserts.
So I am worried that my cluster
Answered by Peter Eisentraut here:
http://dba.stackexchange.com/a/43435/24360
Thanks,
Michał.
On Thu, May 30, 2013 at 12:24 PM, Michał Rus wrote:
> Hello,
>
> when i CREATE a new DATABASE, its privileges column is empty (it's not
> the same case as it being '{}', which means no privileges). Emp
On Thu, May 30, 2013 at 1:35 PM, Igor Neyman wrote:
>
>
> From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
> Sent: Thursday, May 30, 2013 12:04 PM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] How do I know my table is bloated?
>
> I have some tables that I do a
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 2:24 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
I am using the defualt values for autovaccum.
How do you suggest to tune the autovacuum?
If the pr
On Thu, May 30, 2013 at 3:36 PM, Igor Neyman wrote:
>
>
> From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
> Sent: Thursday, May 30, 2013 2:24 PM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] How do I know my table is bloated?
>
>
> I am using the defualt values
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
updat
On Thu, May 30, 2013 at 3:55 PM, Igor Neyman 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.
> But I am wor
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 NextMul
On Thu, May 30, 2013 at 6:05 AM, Rodrigo Barboza
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
https://code.google.com
On Fri, May 31, 2013 at 2:06 AM, Sergey Konoplev wrote:
> On Thu, May 30, 2013 at 6:05 AM, Rodrigo Barboza
> 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
On Thu, May 30, 2013 at 2:17 AM, prakhar jauhari wrote:
> 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
25 matches
Mail list logo
