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

Re: Need help with PITR for PostgreSQL 9.4.5

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 wrote: >&g

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 recomme

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 y

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, i

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: &g

Single user model vaccum

Hi All How can I monitor and make sure that the vacuum is still running if I get lost with the session to Linux putty? I would need to check if the vacuum is still running from Linux OS. Please advise. Regards Sri

Re: Single user model vaccum

00:00:00 su postgres -c /usr/pgsql-9.4/bin/postgres --single -O -D /pgsql/9.4/data postgres postgres 25413 25412 53 14:59 ?02:50:00 /usr/pgsql-9.4/bin/postgres --single -O -D /pgsql/9.4/data postgres Thanks, Sri On Fri, Nov 6, 2020 at 8:17 PM Sri Linux wrote: > Hi All > > Ho

Re: Single user model vaccum

Thank you David vacuum is done but the application is very slow, is this normal behavior? Will it run any background process after vacuum causing this slowness? Thanks Sri On Fri, Nov 6, 2020 at 9:15 PM David G. Johnston wrote: > > On Friday, November 6, 2020, Sri Linux wrote: >

Re: Single user model vaccum

after vacuum without any other option like full etc. Regards Sri On Fri, Nov 6, 2020 at 9:55 PM David G. Johnston wrote: > On Friday, November 6, 2020, Sri Linux wrote: > >> Thank you David >> >> vacuum is done but the application is very slow, is this normal beha

Re: Single user model vaccum

Ok, thank you. On Fri, Nov 6, 2020 at 10:13 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Friday, November 6, 2020, Sri Linux wrote: > >> Thank you very much David, >> No, vacuum activity wiht single-mode user is completed. I restarted all >> s

After vacuum application runs very slow ? is this common behavior ?

Hi All, Our production database size is about 2TB and we had run into issues and Postgres log did recommend running the vacuum in single-user mode. We have successfully completed running a single user mode vacuum without any options. .. services were online after vacuum. Application load time and

Re: After vacuum application runs very slow ? is this common behavior ?

Adding version info Postgres 9.4.5 Linux - rhel 7.3 Thanks Sri On Fri, Nov 6, 2020 at 10:20 PM Sri Linux wrote: > Hi All, > > Our production database size is about 2TB and we had run into issues and > Postgres log did recommend running the vacuum in single-user mode. We have &g

Re: After vacuum application runs very slow ? is this common behavior ?

Thank you for your response. On Fri, Nov 6, 2020 at 11:14 PM Adrian Klaver wrote: > On 11/6/20 8:20 PM, Sri Linux wrote: > > Hi All, > > > > Our production database size is about 2TB and we had run into issues and > > Postgres log did recommend running the vac