purge all data in railway postgres | Railway | Page 1

slate shale Jul 17, 2024, 6:05 AM

#

is there an eazy way to do this? I want to be able to clear up the database easily and also disable backups

serene cometBOT Jul 17, 2024, 6:05 AM

#

Project ID: N/A

grizzled oak Jul 17, 2024, 6:08 AM

#

wipe the volume from within the volume setting, additionally railway does not take any backups for you in any way

slate shale Jul 17, 2024, 6:11 AM

#

can volume be wiped programmatically or through cli?

grizzled oak Jul 17, 2024, 6:12 AM

#

you can wipe it from the API yeah

slate shale Jul 17, 2024, 6:14 AM

#

with cli no?

grizzled oak Jul 17, 2024, 6:14 AM

#

the CLI doesn't offer that functionality afaik

slate shale Jul 17, 2024, 6:14 AM

#

oof. I'm US based

#

only auth'd no playground?

grizzled oak Jul 17, 2024, 6:15 AM

#

that's okay because that's not how the API works

slate shale Jul 17, 2024, 6:15 AM

#

well most graphql apis take you to a playground if it's a GET request

#

instead of blocking you

grizzled oak Jul 17, 2024, 6:15 AM

#

can you tell me your usecase please?

slate shale Jul 17, 2024, 6:15 AM

#

graphiql

#

example https://graphql.github.com/ redirects you to a playground if it's GET

grizzled oak Jul 17, 2024, 6:18 AM

#

can you tell me your usecase?

grizzled oak Jul 17, 2024, 6:18 AM

#

grizzled oak that's okay because that's not how the API works

https://railway.app/graphiql

slate shale Jul 17, 2024, 6:18 AM

#

i want to explore the schema so I can construct the necessary query in order to wipe volume

#

nice thanks

grizzled oak Jul 17, 2024, 6:18 AM

#

i meant your usecase for wiping the volume

slate shale Jul 17, 2024, 6:18 AM

#

oh sorry

#

I'm creating railway deployment guide then a template for this https://github.com/joshstevens19/rindexer

while developing that I find myself deploying frequently and needing a fresh database. Basically to make sure indexing and db sync is working

#

I would not need that in production

grizzled oak Jul 17, 2024, 6:20 AM

#

if its just for development, why not just click wipe volume in the volume settings?

slate shale Jul 17, 2024, 6:21 AM

#

i deploy a lot within my shell

#

rarely use the dashboard

grizzled oak Jul 17, 2024, 6:22 AM

#

gotcha

#

mutation volumeInstanceWipe($volumeInstanceId: String!) {
  volumeInstanceWipe(volumeInstanceId: $volumeInstanceId)
}

{
  "volumeInstanceId": "id_here"
}

slate shale Jul 17, 2024, 6:28 AM

#

thanks

#

can't find volume id

grizzled oak Jul 17, 2024, 6:29 AM

#

open the volume and the id is in the url

slate shale Jul 17, 2024, 6:37 AM

#

grizzled oak ```graphql mutation volumeInstanceWipe($volumeInstanceId: String!) { volumeIns...

it worked and also

grizzled oak Jul 17, 2024, 6:37 AM

#

yes, there is no wipe option

slate shale Jul 17, 2024, 6:37 AM

#

so this just removes the volume entirely?

grizzled oak Jul 17, 2024, 6:38 AM

#

yep

slate shale Jul 17, 2024, 6:39 AM

#

silly question, now that I wiped the volume it removed the deployment. Understandable. What do to create a new deployment?

grizzled oak Jul 17, 2024, 6:39 AM

#

it should not remove the deployment, I just tried it and it redeployed

#

but simply redeploy it

slate shale Jul 17, 2024, 6:41 AM

#

grizzled oak ```graphql mutation volumeInstanceWipe($volumeInstanceId: String!) { volumeIns...

argh I ran volumeDelete(volumeId: $volumeId) instead of volumeInstanceWipe

#

but I don't see a volumeInstanceWipe in the schema

#

grizzled oak Jul 17, 2024, 6:42 AM

#

it doesnt need to be, use the internal endpoint

slate shale Jul 17, 2024, 6:46 AM

#

that deleted the volume entirely instead of just clearing data

grizzled oak Jul 17, 2024, 6:46 AM

#

yes, as you mentioned you called the wrong mutation

slate shale Jul 17, 2024, 6:47 AM

#

i couldn't do this without you

#purge all data in railway postgres