Re: Need help with PITR for PostgreSQL 9.4.5

On Fri, Nov 6, 2020 at 2:34 PM Sri Linux wrote: > Could you please provide me the link to start new questions? > >> >>> Assuming you are using Gmail... https://business.tutsplus.com/tutorials/how-to-compose-and-send-your-first-email-with-gmail--cms-27678 David J.

Re: Need help with PITR for PostgreSQL 9.4.5

David Could you please provide me the link to start new questions? Thanks and Regards Sri On Fri, Nov 6, 2020 at 3:27 PM Sri Linux wrote: > Thank you very much David > > > > On Fri, Nov 6, 2020 at 2:11 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Friday, November 6, 2020

Re: Need help with PITR for PostgreSQL 9.4.5

Thank you very much David On Fri, Nov 6, 2020 at 2:11 PM David G. Johnston wrote: > On Friday, November 6, 2020, Sri Linux wrote: > >> Hi All >> >> I have to start Postgres 9.4.5 vacuum for our production environment. Got >> interrupted with the Linux session, is there a way I can monitor if

Re: Need help with PITR for PostgreSQL 9.4.5

On Friday, November 6, 2020, Sri Linux wrote: > Hi All > > I have to start Postgres 9.4.5 vacuum for our production environment. Got > interrupted with the Linux session, is there a way I can monitor if the > vacuum is progressing while I reconnect to the Linux box? > >> >>> Please start new emai

Re: Need help with PITR for PostgreSQL 9.4.5

Hi All I have to start Postgres 9.4.5 vacuum for our production environment. Got interrupted with the Linux session, is there a way I can monitor if the vacuum is progressing while I reconnect to the Linux box? Thanks Sri On Thu, Jun 25, 2020 at 1:16 PM Sri Linux wrote: > Thanks for your suppo

Re: Need help with PITR for PostgreSQL 9.4.5

Thanks for your support. I will try to restore and provide results shortly without restoring pg_xlog file Regards, Sri On Thu, Jun 25, 2020 at 1:09 PM Stephen Frost wrote: > Greetings, > > * Sri Linux (srilinu...@gmail.com) wrote: > > Please find the method used. Please recommend me if I have

Re: Need help with PITR for PostgreSQL 9.4.5

Greetings, * Sri Linux (srilinu...@gmail.com) wrote: > Please find the method used. Please recommend me if I have done > something wrong... Yes, you are using 'cp' which is *not* recommended for an archive command. > Performing a hot backup using pg_basebackup: > Create a new folder as the postg

Re: Need help with PITR for PostgreSQL 9.4.5

Thank you all for the response, Please find the method used. Please recommend me if I have done something wrong... Thanks and Regards, sree On Wed, Jun 24, 2020 at 11:36 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > The version you are running is neither up-to-date for its major

Re: Need help with PITR for PostgreSQL 9.4.5

The version you are running is neither up-to-date for its major version (9.4) nor is the major version being supported. https://www.postgresql.org/support/versioning/ Thoug a functioning backup is good to have before upgrading, especially major versions. On Wednesday, June 24, 2020, Sri Linux w

Need help with PITR for PostgreSQL 9.4.5

Hi All, I am trying to do PINT backup and recovery for the standalone database which is not in a cluster. recovery.done is created, after restart database is having errors to start " < 2020-06-22 16:34:08.280 CDT >LOG: starting archive recovery < 2020-06-22 16:34:08.456 CDT >LOG: restored log