From: Gone, Sajan <SGone@lb.com>
To: Hunley, Douglas <douglas.hunley@openscg.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Unable to start postgres instance.
Date: Thu, 27 Apr 2017 21:43:18 +0000
Message-ID: <D527D893.7FD7%sgone@lb.com> (raw)
In-Reply-To: <CAAD=pwEBjg2MUacnfMYhbOBHjcqBiX+OP7iW+-faiqSQeC6s-w@mail.gmail.com>
References: <D527C0F1.7F9C%sgone@lb.com>
<CAAD=pwEBjg2MUacnfMYhbOBHjcqBiX+OP7iW+-faiqSQeC6s-w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi Douglas,
Appreciate your help.
'hot_standby = on' set up was already made but I restarted the server just in case, however I am still getting the same error.
But when I am attempting to reboot the database this is what I have noticed on the error logs
LOG: started streaming WAL from primary at 0/1B000000 on timeline 1
FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 00000001000000000000001B has already been removed
LOG: received fast shutdown request
LOG: shutting down
LOG: database system is shut down
So, I am assuming the WAL files have already been deleted on the Master. Is there any setting on Master I can toggle in order to increase the expiry(retention policy) for the WAL files.
Thank You,
Sajan Gone
Database Administrator
L Brands
Mobile #: 517-990-5282
Office #: 614-577-7622
From: "Hunley, Douglas" <douglas.hunley@openscg.com<mailto:douglas.hunley@openscg.com>>
Date: Thursday, April 27, 2017 at 3:45 PM
To: Sajan Gone <sgone@lb.com<mailto:sgone@lb.com>>
Cc: "pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>" <pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>>
Subject: Re: [ADMIN] Unable to start postgres instance.
On Thu, Apr 27, 2017 at 3:38 PM, Gone, Sajan <SGone@lb.com<mailto:SGone@lb.com>> wrote:
-bash-4.3$ psql -U postgres
psql: FATAL: the database system is starting up
However its been on that from quite a long time. It would really appreciate if anyone could explain me on what is really going on.
It is doing exactly what it should. A standby is, by default, in permanent recovery mode. If you wish to be able to connect to it in this mode, you need to add 'hot_standby = on' to its postgresql.conf and restart the standby.
--
{
"name" : "douglas j hunley",
"title" : "database engineer",
"email" : "douglas.hunley@openscg.com<mailto:doug.hunley@gmail.com>",
"mobile" : "+1 614 316 5079"
}
________________________________
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: SGone@lb.com, douglas.hunley@openscg.com
Subject: Re: Unable to start postgres instance.
In-Reply-To: <D527D893.7FD7%sgone@lb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox