Thread: pgadmin 4 v1.5 - Import CSV
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!
Attachment
and of course change <STORAGE_DIR> to /home/pgadmin/.pgadmin/storage/pgadmin/export PGHOST=localhostexport PGPORT=5432export PGDATABASE=your_databaseexport PGUSER=postgresexport PGPASSWORD=password
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!
www.greenwoodmap.com
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:and of course change <STORAGE_DIR> to /home/pgadmin/.pgadmin/export PGHOST=localhostexport PGPORT=5432export PGDATABASE=your_databaseexport PGUSER=postgresexport PGPASSWORD=passwordstorage/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...RichOn Tue, Jun 27, 2017 at 9:51 AM, Kenny <modeltwelve@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/pga dmin4-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
OMGoodness ... sorry to waste everyone's time and thanks for the replies ... it was all me ... I entered: /usr/bin/psql as the path but it only wanted the directory ... /usr/bin and of course it added the psql itself ... dang. I probably wouldn't have seen that maybe never ... so thanks again for making me look via the command line! It works ... w00t! PS: Hope everyone has a great day!