7,620
edits
Changes
Jump to navigation
Jump to search
no edit summary
All of your day-to-day data should be stored on the E: drive of the RDP. Generally, you should create a folder for each project that you work on and store your data in:
E:\McNair\Projects\YOURPROJECT
====Working with our PostgreSQL Server===
Only tab-delimited text files that contain data that is being moved on or off the database server should be copied to the database servers bulk drive. Again create folders there to organize your data. Your folder's name should be the same as your database's name (case sensitive to avoid confusion). Note that some legacy folders and databases do not follow this schema.
To make your life easy, map the database's bulk drive on your RDP account. [[Help:Access_RDP_Sever#Connecting_the_Database_Server|Follow the instructions]] to do this. We refer to the database server's bulk drive as either 181/bulk (where 181 is the last segment of its address) or as Z:, as this is the drive letter most commonly mapped to.
There are detailed instructions on [[Working with PostgreSQL]], that include how to connect to the server, make dbases, and write SQL.
For first timers, you should also read [[How to do a Simple Database Project]].
====Using our Git Server====
