Sometimes its a bit difficult to find old, official documentations - but luckily I have just came across with ArcGIS Diagrammer doco's from ESRI in PDF.
You can download it here:
Sunday 12 November 2023
Friday 29 September 2023
Postgres table with geographic data - migration commands
First let's export a table to the file system:
pg_dump --host localhost --port 5432 --username mypgusername --format plain --verbose --file /var/lib/pgsql/stations.sql --table mypgschamename.mypgtablename mydatabasename
Now we have a sql file on filesystem - ready to be migrated.
We can do that even for a remote PG server:
psql -h 111.111.111.111 -p 5432 -d mydbname -U myusername -W -f stations.sql
After putting in the password for the remote server the restore takes place over the wire.
On WAN network it might be slow and can disconnect occasionally - I'd say several hundred of MB table still can easily be restored like this.
Monday 17 July 2023
Mapcortex.com new website
In the last few years/months we have been trying to formulate our new business strategy - and we seemingly get to the point where we can safely say we have some good ideas to implement.
Our new website layout is now trying to correspond to this endeavour. So if you like to see what we are up to these days please visit mapcortex.com.
Subscribe to:
Posts (Atom)