Giter Club home page Giter Club logo

Comments (3)

tvb avatar tvb commented on September 17, 2024

Ok removed the files from pg_xlog/, base/ and global/. Governor is now trying to start again.

LOG:  database system was shut down in recovery at 2015-08-27 12:21:31 CEST
WARNING:  recovery command file "recovery.conf" specified neither primary_conninfo nor restore_command
HINT:  The database server will regularly poll the pg_xlog subdirectory to check for files placed there.
LOG:  entering standby mode
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
2015-08-27 12:24:18,544 ERROR: Error communicating with Postgresql.  Will try again.
2015-08-27 12:24:18,545 INFO: None
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
FATAL:  the database system is starting up
Traceback (most recent call last):
  File "./governor.py", line 64, in <module>
    if postgresql.is_leader():
  File "/var/lib/postgresql/governor/helpers/postgresql.py", line 84, in is_leader
    return not self.query("SELECT pg_is_in_recovery();").fetchone()[0]
  File "/var/lib/postgresql/governor/helpers/postgresql.py", line 49, in query
    raise e
psycopg2.OperationalError: FATAL:  the database system is starting up

LOG:  received fast shutdown request
waiting for server to shut down....LOG:  shutting down
LOG:  database system is shut down
 done
server stopped

from governor.

tvb avatar tvb commented on September 17, 2024

Ok bacially I did a clean restart by cleaning up as you recommended in #13 (comment)

But now I get:

2015-08-27 13:17:39,940 INFO: Lock owner: sql2; I am sql3
2015-08-27 13:17:39,941 INFO: does not have lock
2015-08-27 13:17:39,946 INFO: no action.  i am a secondary and i am following a leader
FATAL:  database system identifier differs between the primary and standby
DETAIL:  The primary's identifier is 6187648254339472088, the standby's identifier is 6150520899791371405.
FATAL:  database system identifier differs between the primary and standby

from governor.

Winslett avatar Winslett commented on September 17, 2024

This happens when you do a pg_basebackup from a different Postgres cluster than you are trying to stream replication from. This can also happen if you run initdb for the member instead of running pg_basebackup from the cluster's leader.

I'm assuming you ran initdb for this Postgres directory. If you did, remove the data directory for that Postgres, and let governor run initialize the empty directory from the cluster's leader. Basically, you should start governor with Postgres uninitialized.

from governor.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.