Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-27797

Write up how-to guide for PostGres on lsst-devl

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Write up Merediths current notes on how to get access to PostGres on lsst-devl, and how to use it for ap_pipe. The result should be a post on Community in the private DM section.

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          mrawls Meredith Rawls added a comment -

          It's here! https://community.lsst.org/t/using-postgresql-at-ncsa-for-an-apdb/4603 

          Show
          mrawls Meredith Rawls added a comment - It's here! https://community.lsst.org/t/using-postgresql-at-ncsa-for-an-apdb/4603  
          Hide
          Permalink
          sullivan Ian Sullivan added a comment -

          I'm not the reviewer, but would it be possible for you to add a section on how to reset the database? For example, if your run dies and you start it over, or if you want to redo it after fixing a bug.

          Show
          sullivan Ian Sullivan added a comment - I'm not the reviewer, but would it be possible for you to add a section on how to reset the database? For example, if your run dies and you start it over, or if you want to redo it after fixing a bug.
          Hide
          Permalink
          mrawls Meredith Rawls added a comment -

          I haven't done this myself yet! Naively, I'd move the "bad" one to a new schema, make a new empty schema, and then figure out how to nuke (drop?) the bad one. I can say as much.

          Show
          mrawls Meredith Rawls added a comment - I haven't done this myself yet! Naively, I'd move the "bad" one to a new schema, make a new empty schema, and then figure out how to nuke (drop?) the bad one. I can say as much.
          Hide
          Permalink
          ebellm Eric Bellm added a comment -

          Looks good to me! My only suggest is to add (in both the psql and python sections) a very simple example of issuing an sql query (say, SELECT "diaObjectId" from "DiaObject" LIMIT 10;). I wasn't initially sure if it was working because I didn't realize that the case sensitivity required the quotes.

          Show
          ebellm Eric Bellm added a comment - Looks good to me! My only suggest is to add (in both the psql and python sections) a very simple example of issuing an sql query (say, SELECT "diaObjectId" from "DiaObject" LIMIT 10; ). I wasn't initially sure if it was working because I didn't realize that the case sensitivity required the quotes.
          Hide
          Permalink
          mrawls Meredith Rawls added a comment -

          Good catch, indeed, I got hung up on that too, I'll edit accordingly. Thanks!

          Show
          mrawls Meredith Rawls added a comment - Good catch, indeed, I got hung up on that too, I'll edit accordingly. Thanks!

            People

            Assignee:
            mrawls Meredith Rawls
            Reporter:
            sullivan Ian Sullivan
            Reviewers:
            Eric Bellm
            Watchers:
            Eric Bellm, Ian Sullivan, Meredith Rawls
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Jenkins

                No builds found.