From: Gone, Sajan <SGone@lb.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Unable to start postgres instance.
Date: Thu, 27 Apr 2017 19:38:26 +0000
Message-ID: <D527C0F1.7F9C%sgone@lb.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
I am in the process of setting postgres replication and I have followed the documentation from the website below.
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresq...
I have completed all the steps and when I was about to start the slave server, seems like it got hung up on the start up and is taking forever to be available. Here is the process list I am seeing.
-bash-4.3$ ps -ef | grep -i postgres
postgres 29842 29841 0 14:01:45 pts/3 0:00 -bash
postgres 42808 42806 0 15:17:19 ? 0:00 /opt/local/bin/postgres -D /var/pgsql/data
postgres 45713 31142 0 15:35:45 pts/2 0:00 ps -ef
root 31141 29120 0 14:11:05 pts/2 0:00 sudo -u postgres -i
postgres 42806 6491 0 15:17:19 pts/2 0:00 /opt/local/bin/postgres -D /var/pgsql/data
postgres 31142 31141 0 14:11:05 pts/2 0:00 -bash
postgres 45712 42806 0 15:35:44 ? 0:00 /opt/local/bin/postgres -D /var/pgsql/data
root 29841 29835 0 14:01:43 pts/3 0:00 sudo -u postgres -i
postgres 45714 31142 0 15:35:45 pts/2 0:00 grep -i postgres
postgres 42807 42806 0 15:17:19 ? 0:00 /opt/local/bin/postgres -D /var/pgsql/data
Below is the error I am seeing when I am trying to log on to the DB using psql client.
-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.
Thank You,
Sajan Gone
Database Administrator
L Brands
Mobile #: 517-990-5282
Office #: 614-577-7622
________________________________
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
Subject: Re: Unable to start postgres instance.
In-Reply-To: <D527C0F1.7F9C%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