0

I'm fairly new to AWS in general. I'm currently trying to replicate work by another group and therefore am attempting to mimic their setup. I've established an EC2 instance (Amazon Linux AMI) and a PostgreSQL 9.3.5 RDS instance. I've uploaded a 4 GB csv file to EC2 and would like to copy it to a table in my RDS db. I used the following code within the EC2 shell (following 2nd set of instructions here):

psql -h XX.us-west-2.rds.amazonaws.com -U username -d DBname -p 5432 -c "\copy tablename from 'data.csv' with DELIMITER ',';"

After giving my password I get the error "psql: FATAL: could not write init file". I think this psql client may be version 9.2, is that something that matters? Or is this the wrong syntax for this type of transfer? Or, could it be related to having free trial size instances, which I believe have a 5 GB limit? I think I should be under that limit, but would it tell me if that were the problem? Any help would be much appreciated.

Vivek S.
  • 19,945
  • 7
  • 68
  • 85
user
  • 621
  • 1
  • 9
  • 21
  • I think you need to specify the absolute path to that `csv` file ex : - `\copy tablename from 'd:\myfiles\data.csv' with DELIMITER ',';` – Vivek S. Mar 04 '15 at 04:31
  • It actually seems that it was a size issue. When I increased my RDS instance to 10 GB the error went away. There must be some amount of that 5 GB storage that goes something besides your uploaded files. – user Mar 05 '15 at 19:12
  • later comment: csv's seem to double in size when they are formatted as a sql table – user Mar 23 '15 at 22:56

0 Answers0