I don't think the fact that it says <STORAGE_DIR> means that it failed to evaluate STORAGE_DIR because I just did a successful csv import and the output's "Running command" looks like this:
"/usr/lib/postgresql/9.4/bin/psql" --command " "\\copy treas.tscombination (tscombinationid, combination, description, milllevy) FROM '<STORAGE_DIR>/w2/gis/Wyoming/22_Teton/scripts/dump/treas/tscombination.csv' DELIMITER ',' CSV HEADER QUOTE '\"' ESCAPE '''';"" Which doesn't look significantly different than yours. I'd suggest pasting your "Running command" into a shell with appropriate environment variables set and see if you get more useful error info from psql. "appropriate environment variables" might look something like: export PGHOST=localhost export PGPORT=5432 export PGDATABASE=your_database export PGUSER=postgres export PGPASSWORD=password and of course change <STORAGE_DIR> to /home/pgadmin/.pgadmin/storage/pgadmin/ I'm guessing permissions problems. Are you 'potgres' when you run it? And do you have access to /home/pgadmin/.pgadmin/storage/pgadmin/? For me I'm putting my stuff in my home dir, so: /home/rich/.pgadmin/storage/rich/ Let us know... Rich On Tue, Jun 27, 2017 at 9:51 AM, Kenny <modeltwe...@vinacs.com> wrote: > First off ... I'm a newbie so please feel free to suspect anything I say > as incorrect. > > Here's what I think I know. > > I'm running Ubuntu Server 16.04 > > To install I created a user pgadmin > > cd > virtualenv pgadmin4 > cd pgadmin4 > source bin/activate > wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v1.5/pip/ > pgadmin4-1.5-py2.py3-none-any.whl > pip install ./pgadmin4-1.5-py2.py3-none-any.whl > > It asked me for a username/password during setup. > > I changed nothing else and can run the webserver as follows: > > python ~/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py > > I can access the application as expected at 127.0.0.1:5050. > > So without changing anything else or creating a config_local.py or running > setup.py ... everything seems working? > > I can make tables, perform queries ... and it's beautiful btw! > > I uploaded a CSV ... and the file was placed in: > > */home/pgadmin/*.pgadmin/storage/pgadmin > > I tried to import that same file thru pgadmin and got an error that I just > don't know what to do with. > > snippet: > "/usr/bin/psql/psl" -command ... blablabla ... FROM > '<STORAGE_DIR>/abbr.csv' > > It looks to me like the <STORAGE_DIR> replacement variable is just not > being replaced? > > -please see attached (if I can attach an image that is ... we'll find > out!) - > > Thanks! > > -- Richard W. Greenwood, PLS www.greenwoodmap.com
