[POSTGRES] understanding Volumes

Questions / Help
1

app - fly-post-14

the app lists two volumes under the same name

ID                  	STATE  	NAME   	SIZE 	REGION	ZONE	ATTACHED VM	CREATED AT   
vol_2n0l9vlyp9p4635d	created	pg_data	100GB	maa   	180d	2374a495   	3 months ago	
vol_mjn924ojkoqr03lq	created	pg_data	100GB	maa   	aed0	           	3 months ago

although the size of the snapshots are different

first volume

vs_XMz14aKnaxvxlTxx	9345679531	19 hours ago

vs Second volume

vs_RebAk2oLVBRJpC1P	866006108	13 hours ago

Can someone explain why this is happening? I want to migrate the database using snapshot, I’m not sure which one to take

2

When you provision a “Highly Available” Postgres, we create two volumes and run two instances. It looks like you might have scale this back to one instance, however, since one of the volumes is unattached.

You should use the snapshot from the volume that’s currently attached. It’s normal for snapshots on PG apps to be different sizes – the leader postgres uses more disk space than the replicas.

If you are only going to run with one volume, it is best to remove the unattached volume.

1 Like