Trying to import pgSQL database
I need some help to import a pgSQL database through shell.
My customer upload a file named "ez3.sql" (uploaded to his FTP home)
His pgsql database is called "user_publish" (created through cPanel)
His pgsql username is called "user_publish" (created through cPanel)
As we have been told, to import his database to pgsql lib directory the following command should be done:
root@gui [/home/wagner/public_html/db]# pgsql user_publish < ez3.sql
After that it asks me for a password (probably pgsql root password) that I dont have/dont know how to reset.
How can I proceed ?
Thank you very much
