HelioHost Posted June 12, 2017 Posted June 12, 2017 Hello, I'm trying to dump my local postgres table to heliohost, but I'm having some trouble due to sql errors in the exported file. Thats because I have some text data with some characters that are causing sql errors. So I had the idea to export in csv, instad of plain sql. Same trouble... I'm trying now import as binary file to see if it works. So I did like this: copy to 'myfile' with binary Ok, I got the dump, but I can't do this command in helioshost: copy from 'myfile' with binary I need to be a superuser, as the message says. It tells me to use stdin and stdout instead of the file. I tried to export like this, but it appears my table is too much data, and my pc stops working, so I guess I'll have to use files, instead of stdin and stdout. Bot how can I do this? could you give me the permission to my user to use the command "copy from 'myfile' with binary"? database: animean_<removed> username: animean_<removed> Please, erase the database and username from this conversation, for the public not to see it. Thanks
Krydos Posted June 13, 2017 Posted June 13, 2017 Have you tried importing your database in pgmyadmin?
HelioHost Posted June 14, 2017 Author Posted June 14, 2017 It worked using pgadmin, Thank you 2017-06-12 23:56 GMT-03:00 Heliohost Support : > Have you tried importing your database in pgmyadmin?>> You may view the status of your ticket by visiting:>> http://www.helionet.org/index/index.php?showtopic(366>> Thank you,> Heliohost support> http://www.heliohost.org/> http://www.helionet.org/>>
Recommended Posts