Hi Eloise, I think that’s an error you get when running a Postgres 9.3 server. My 9.1 server has procpid in pg_stat_activity. My 9.3 server has pid instead of procpid. It’s a change that was introduced in postgres 9.2.
I believe it’s not that big a deal and that the rest of the installation can just go on. You can probably change “procpid” in C:/Temp/archesproject/db/Deployment Scripts/DatabaseCleanup.sql to “pid” to fix the error. Cheers, Koen Koen Van Daele Applicatiebeheerder M +32 (0)499 94 93 68 | T +32 (0)2 553 16 82 Van: [email protected] [mailto:[email protected]] Namens Eloise Stancioff Verzonden: dinsdag 28 oktober 2014 18:09 Aan: [email protected] Onderwerp: [Arches] Re: Problem with loading Arches with own data Also- I may have found the issue, but I am a bit confused on how to go about fixing it... After I have both servers running and build arches, I get the following error after entering my password for postgres C:\Temp\archesproject>C:\Temp\archesproject\build\install_arches_db.bat C:\Temp\archesproject>cd C:\Temp\archesproject\build\.. C:\Temp\archesproject>call "virtualenv/ENV/Scripts/activate.bat" operation: install current file is: C:\Temp\archesproject\db\Deployment Scripts\DatabaseCleanup.py current file is: C:\Temp\archesproject\db\Deployment Scripts\Restore.py current file is: C:\Temp\archesproject\db\Deployment Scripts\__init__.py Password for user postgres: psql:C:/Temp/archesproject/db/Deployment Scripts/DatabaseCleanup.sql:1: ERROR: column "procpid" does not exist LINE 1: SELECT pg_terminate_backend(procpid) from pg_stat_activity w... ^ pg_terminate_backend ---------------------- (0 rows) DROP DATABASE CREATE DATABASE Password for user postgres: Any ideas? Thank you Eloise On Tuesday, October 28, 2014 11:22:28 AM UTC+1, Eloise Stancioff wrote: Hi I hope this message finds you well. I think that I have followed the procedure correctly to load Arches with my own data. I used the sample data set up that I was sent by Adam and then modified only the administrative subdivision document and values. csv files. I ran the server and built Arches with no error. But- when I go into Arches- it is as if there is absolutely no data, no drop down menus. It is completely blank- just gives me the map and the menu bar. Is there something that I have missed? Also- in a previous email, I was told to change the map_config settings so that the map layer would open to my specific region rather than the UK. Could you tell me where that file is? The files that I edited are as follows: C:\Temp\archesproject\packages\cds\source_data\resource_info,csv C:\Temp\archesproject\packages\cds\source_data\concepts\authority_files\Administrative Subdivision Authority document.csv C:\Temp\archesproject\packages\cds\source_data\concepts\authority_files\Administrative Subdivision Authority values.csv Thanks in advance for any advice or help Eloise -- -- To post, send email to [email protected]<mailto:[email protected]>. To unsubscribe, send email to [email protected]<mailto:[email protected]>. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
