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
Percy
Percy16mo ago
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.
Percy
Percy16mo ago
root
root16mo ago
You should be able to use railway run pg_dump -d railway to run your local pg_dump with Railway's environment variables.
Percy
Percy16mo ago
No project ID was provided. Closing thread.
root
root16mo ago
Project ID: N/A
Grant Jordan
Grant Jordan16mo ago
Ok, am I able to safely remove the timescale extention using the drop command, or should I do something else ? @aleks
root
root16mo ago
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.