Comments (2)
from aact.
Hi, Thanks for the message. Yes, it looks like the database might have somehow got loaded in triplicate. Can I ask, what is the date of the static copy you loaded? I'll start by checking that file to see if it's ok. Just scanning down the list of static copies, the file sizes all look sane, so I'm thinking that might not be the source of the problem. So if you don't mind... let me know the date of the file you used & I'll check it. Then, while I'm checking on that, you might want to just drop that database and try it again. I happened to test the process on Windows with postgres 11 yesterday. (We want to improve the documentation for installing on Windows, so I took a bunch of notes and screenshots.). We created a superuser named aact and then used the following command to run the load: C:"Program Files"\PostgreSQL\11\bin\pg_restore -e -v -O -x -d aact -U aact --no-owner postgres_data.dmp You can respond to me either thru github or directly at [email protected] . Thanks, Sheri
…
On Wed, Sep 11, 2019 at 5:40 AM cc504142665 @.**> wrote: I have follewed the instructions to install the static copy of aact on postgres v11.4 windows. While restoring the dump file, there were repeating warning like "pg_restore: [archiver (db)] Error from TOC entry ", or "pg_restore: [archiver (db)] could not execute query". When the process finished, it seemed that I could query aact on psql. However, when I try this: aact=# SELECT COUNT() FROM studies; count 945720 (1 record) This number is much higher than the result on the instruction page. So I was wondering whether I have a corret copy of the database, or I need to reinstall it? What might be the issue resulting these warnings? THX! — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#767?email_source=notifications&email_token=AAJN6K7X2O4T3GXIRPVI4Y3QJC4HJA5CNFSM4IVRTMCKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HKVIMUA>, or mute the thread https://github.com/notifications/unsubscribe-auth/AAJN6K5OEWV4CRYCXX4247DQJC4HJANCNFSM4IVRTMCA .
Thank you for your helpful reply!
I used the copy of "20190901 clinical trials", and I will try again with this command.
from aact.
Related Issues (20)
- Snapshots not generating HOT 1
- Missing trials again HOT 2
- Is there a way to a specific to freeze a static copy of the database at specific date?
- digitalocean key an secret HOT 1
- Recurrent mass ID change HOT 2
- snapshots not working starting on 12/22/2019 HOT 28
- Restore of the static copy of the AACT database fails HOT 4
- data missing from nightly dump HOT 7
- [Question] Legal issues - what is the Licence of Data? Is it public domain? HOT 2
- Incorrect dispersion values, dispersion upper limits and dispersion lower limits in table outcome_measurements HOT 2
- snapshots not being generated HOT 5
- conditions.downcase_name not being populated HOT 1
- How to install AACT on windows (PowerShell) HOT 2
- snapshot URLs all returning 404 errors HOT 2
- Table mesh_terms is empty after AACT-Migration HOT 4
- Snapshots not generating HOT 1
- Missing trials HOT 2
- Fetching information of clinical trials for a specifc disease / gene HOT 1
- studies.limitations_and_caveats missing HOT 5
- Trials Missing Conditions HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from aact.