I got superuser access to the new postgreSQL server so I was able to use the COPY command passing a file and it worked great.
For the COPY with STDIN is that missing something to commit the transaction? I believe I copy those lines from the documentation.