Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now.

What I have done thus far is setup two identical DB servers on Ubuntu 11.10 with PostgreSQL 9.1 and repmgr1.1.0 by following the steps on 2ndQuadrant.

The only problem is that it is only for replication, which is working fine, thank you 2ndQuadrant. Now I want to test a fail-over by shutting down the master DB and promoting the Hot Standby to master, but this fails with sh: pg_ctl: not found and then that the postgreSQL service can't be started.

My postgreSQL setup is default install via apt-get and is setup for a master-hot_standby. please could someone assist me in setting up a simple replication of postgresql between 2 servers with a HA failover step-by-step.

share|improve this question

1 Answer 1

Just noticed this un-answered question.. but generally you want to run the pg_ctl as the postgres user

It's in

/usr/lib/postgresql/9.2/bin/pg_ctl

That's if you run 9.2 so your version may vary.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.