Differences between revisions 77 and 78
Revision 77 as of 2018-07-06 16:21:54
Size: 3835
Editor: JakeGordon
Comment:
Revision 78 as of 2018-07-06 16:24:56
Size: 3830
Editor: JakeGordon
Comment:
Deletions are marked like this. Additions are marked like this.
Line 19: Line 19:
 * [[attachment:Duke Data Management Protocols 2015_11.pdf|Duke Data Management Protocol]] (last updated 2018-07-06)-- Protocol for maintenance of interaction data, focal sampling data, GPS/SWERB data, male ranks, dartings, and predation and human disturbance data  * [[attachment:Duke Data Management Protocol.pdf|Duke Data Management Protocol.pdf]] (last updated 2018-07-06)-- Protocol for maintenance of interaction data, focal sampling data, GPS/SWERB data, male ranks, dartings, and predation and human disturbance data

This page is used to store codes, protocols, and procedures for use by the Data Managers.

Babase Technical Information

These links are primarly of interest to the Babase support staff.

Programs

Protocols

Wiki Administration

Copying the Babase Schema

The babase-copy-babase-schema Unix program copies the entire babase schema, including data, table definitions, validation, and everything else, from one database to another. All existing data, table definitions, validation, etc is deleted from the babase schema in the target database. You must be logged in to papio and at the Unix prompt to run the program.

The following example copies the babase schema from the babase database to the babase_test database. The first database (babase) is the database to copy from, the second (babase_test) the database to copy into.

PGPASSWORD='*********' babase-copy-babase-schema YOURADMINNAME babase babase_test
  • The ********* here would be the password of YOURADMINNAME

The next example copies the babase scheme from the babase_test database to the babase_database. The program will not copy into the babase database unless the -f (force) flag is given.

PGPASSWORD='*********' babase-copy-babase-schema -f YOURADMINNAME babase_test babase
  • When Backing up the DB, the 'help' directory can offer some direction

[YOU@papio ~]$ pg_dump --help

Killing a Process in PPA

After you have logged into the database as the administrator, select the babase database.

There is a tab along the top of the browser window with a button for Processes. Click this button.

You may have to click cancel on the process you are killing a couple of times. It will tell you that the function has failed, its just kidding!

DataManagement (last edited 2024-02-13 16:05:25 by JakeGordon)

Wiki content based upon work supported by the National Science Foundation under Grant Nos. 0323553 and 0323596. Any opinions, findings, conclusions or recommendations expressed in this material are those of the wiki contributor(s) and do not necessarily reflect the views of the National Science Foundation.