Hello Jo,
These steps from some older documentation is what I believe works with RDS (and
should really be part of the new documentation):
1. Bring up a local PostgreSQL server. Using a database superuser account,
perform the migration on this local PostgreSQL server.
2. Once the migration is successful, take a database dump of the migrated DB:
``` shell
pg_dump --no-owner -h <db-host> -p <db-port> -U <db-user>
--dbname=<gocd-server-database-name> <db-dump-file-name>.sql
```
3. Create a PostgreSQL database on RDS and make the superuser (who is part of
rds_superuser group), the owner of that database.
4. Using the `<db-dump-file-name>.sql` created in step 2 above, restore the
PostgreSQL database on your Amazon RDS instance:
psql -f <db-dump-file-name>.sql -h <rds-db-endpoint> -p
<rds-pg-db-port> -U <rds-pg-db-user> --password --dbname=<rds-pg-db-name>
The above command will prompt for the password. Once the database is restored
you can point your GoCD server to that Amazon RDS instance. As always, please
have a backup and test this before doing anything.
Cheers,
Aravind
--
You received this message because you are subscribed to the Google Groups
"go-cd" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/go-cd/m2k0onihfa.fsf%40arvindsv.com.
