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
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
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
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 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
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:
>
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
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
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
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
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
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
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
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
14 matches
Mail list logo