I have two sets of data
Table A: Stations - contains postal code (which I can convert to lat/long), name and code. Table B: Connections - contains a possible list of connections including source, target (both expressed as three letter codes), distance and maximum speed (I can calculate a cost from these two parameters).
I want to create a routable network - from looking, I have found PGRouting may be able to do what I need but almost all the tutorials I've found are based on road networks.
What is the best way to convert the data I have into a routable network? I'm not set on PostGIS/PGRouting but I haven't found a better solution yet - eventually there'll be around 3000 stations and 5000+ connections.