Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

restore-postgres.sh fails while executing dropdb

The Private Cloud operations guide recommend using the restore-postgres.sh script to restore the postgres from a backup file post events like reinstallation.

It is likely that the script may fail with the following error during execution :

dropdb: database removal failed: ERROR: database "apigee" is being accessed by other users

This may not be a fatal error and may result in the data being added onto the existing db as opposed to dropping it and creating afresh - And that is the problem.

How can this be resolved ?

0 1 345
1 REPLY 1