backups,
it's best practice to restore the online backup on a test system and
perform PITR. After successful restoration, take the dump of the specific
table and restore it on the production.
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Email:prashant.ranjal
that work_mem value is not set to extreme higher value as the max
connections has set to 500.
*Thanks Regards,*
*** **Prashanth Ranjalkar*
*Database Consultant Architect*
*Email:prashant.ranjal...@gmail.com*
*Skype:prashanth.ranjalkar*
*Cell: +91 932 568 2271*
*www.postgresdba.net*
Regards,*/
//**
/*Prashanth Ranjalkar*/
/*Database Consultant Architect*/
/*Email:prashant.ranjal...@gmail.com*
mailto:email%3aprashant.ranjal...@gmail.com/
/*Skype:prashanth.ranjalkar*/
/*Cell: +91 932 568 2271*/
*/www.postgresdba.net http://www.postgresdba.net//*
to/from the same system catalog version
when using tablespaces
Why 9.0.4 and 9.1.3 are same catalog version?
Is there a workarround for this problem, I would like to avoid
using a dmp.
You can also consider slony for performing the upgrade if needed.
*
Thanks Regards,*
*** *
*Prashanth
Yes, You can use the mentioned method by using scripts or also there are
few migration tools available to perform the migration of schema..
**
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Email:prashant.ranjal...@gmail.com*
*Skype:prashanth.ranjalkar
upgrade
method before live implementation.
**
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Email:prashant.ranjal...@gmail.com*
*www.postgresdba.net*
On Thu, Apr 18, 2013 at 4:40 PM, Rajiv Kasera rajiv.kas...@pinelabs.comwrote:
I am planning to upgrade my
.
From the error it states that pgstat catalog corruption and reindexing
system catalog may resolve the problem however it's strongly recommend to
verify it on the test server first.
**
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Skype:prashanth.ranjalkar
,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Skype:prashanth.ranjalkar*
*www.postgresdba.net*
On Thu, Apr 11, 2013 at 1:51 PM, X.H.WANG 82661...@qq.com wrote:
I'm sorry,I forgot to attach the log info:
WARNING: pgstat wait timeout
SELECTWARNING: pgstat wait timeout
Yes, the log shipping/streaming replication is possible between these
versions as the major versions are same i.e 9.1.X
**
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Skype:prashanth.ranjalkar*
*www.postgresdba.net*
On Wed, Apr 10, 2013 at 1:58 PM, Herman
.
**
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Skype:prashanth.ranjalkar*
*www.postgresdba.net*
On Wed, Apr 10, 2013 at 2:13 PM, Dale Betts dale.be...@hssnet.com wrote:
I'd agree, certainly in my experiences.
You need to ensure OS parameters such as the max
, the log shipping/streaming replication is possible between these
versions as the major versions are same i.e 9.1.X
Thanks Regards,
Prashanth Ranjalkar
Database Consultant Architect
Skype:prashanth.ranjalkar
www.postgresdba.net
Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*www.postgresdba.net*
On Wed, Feb 20, 2013 at 9:34 PM, Viktor vik...@okservers.eu wrote:
Ook, thanks =)
On 2/20/2013 5:56 PM, Gilberto Castillo wrote:
Hello,
Could explain somebody what will happen, if the slave
that are
moved into tablespace.
**
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*www.postgresdba.net*
On Thu, Feb 21, 2013 at 2:45 AM, Brian Fehrle bri...@consistentstate.comwrote:
Hi all,
I've set up a tablespace on a different partition from the main data
. *
**
**
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Email:prashant.ranjal...@gmail.com*
*Skype:prashanth.ranjalkar*
*Cell: +91 932 568 2271*
On Wed, Jan 23, 2013 at 8:16 PM, Bert bier...@gmail.com wrote:
Yes, at the moment that is still the case.
We are migrating
kick off and analyze operations which get executed manually from ETL job.
*Thanks Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant Architect*
*Email:prashant.ranjal...@gmail.com*
*Skype:prashanth.ranjalkar*
*Cell: +91 932 568 2271*
On Thu, Jan 24, 2013 at 11:56 AM, Bert bier
15 matches
Mail list logo