Migrate Postgres to GCP
Hey there, we need to migrate our database layer to Google Cloud Platform.
I have found no documentation on how to do this.
How would I pg_dump and pg_restore the Timescale db into google cloud platform?
7 Replies
Please provide your project ID or reply with
N/A. Thread will automatically be closed if no reply is received within 10 minutes. You can copy your project's id by pressing Ctrl/Cmd + K -> Copy Project ID.You might find these helpful:
- Not able to migrate heroku postgresql db to railway postgresql db
- Copy local database to project
⚠️ experimental feature
You should be able to use
railway run pg_dump -d railway to run your local pg_dump with Railway's environment variables.No project ID was provided. Closing thread.
Project ID: N/A
Ok, am I able to safely remove the timescale extention using the drop command, or should I do something else ? @aleks
I'm afraid the above command is where my knowledge ends on this subject, as I've never had experience with Timescale and I'm not on the Railway team and don't know what's safe to do with the database. If you're on the team plan, you should be able to link your account to Discord for a direct support channel with the team.