860552 - Refresh stage database

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Selena Deckelmann :selenamarie :selena]

Refreshing the stage database from scratch

Comment 1

[Matt Pressman [:mpressman]]

refreshing stage now

Comment 2

[Matt Pressman [:mpressman]]

Items addressed in getting stage refresh back up and running:
1. attempt to create pg_log (fixed by removing unused pg_log from source host)
2. failed to copy file pg_hba.conf from confdir to targetdir (fixed by changing ownership and passing -f to the cp in the script)
3. WAL header to small (not sure how to fix, simply adjusted by retrying script

running refresh now with the above items addressed

Comment 3

[Matt Pressman [:mpressman]]

I had to manually run the update_staging_passwords at the end of the script, but otherwise it completed and is up and running. Will want to fix that last part.

Comment 4

[Matt Pressman [:mpressman]]

for posterity the error was:
psql: FATAL: the database system is starting up

Comment 5

[Selena Deckelmann :selenamarie :selena]

(In reply to Matt Pressman [:mpressman] from comment #3)
> I had to manually run the update_staging_passwords at the end of the script,
> but otherwise it completed and is up and running. Will want to fix that last
> part.

Great. Thanks!

Is this wrapped up then? Perhaps we can open another ticket for fixing the script -- unless that's already done.

Comment 6

[Sheeri Cabral [:sheeri]]

script fix is bug 861330 for update_staging_passwords.