Issue with installing aact on postgresql

[Shuhe-Li]

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!

[tibbs001]

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 sheri.tibbs@duke.edu . 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> .

[Shuhe-Li]

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 sheri.tibbs@duke.edu . 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.