Recently installed postgreSQL using /scripts/installpostgres, also recompiled apache and activated postgreSQL from the php menu, after that created datatabase, username and add the user to the db from pgsqladmin at cPanel.
I need to import an sql file to the new database and it seems to be impossible:
CODE
[root@srv48.myserver.com:~]psql -U user_username1 -d data_base -f sqlfile.sql
psql: FATAL: Ident authentication failed for user "user_username1"
[root@srv48.myserver.com:~]/
psql: FATAL: Ident authentication failed for user "user_username1"
[root@srv48.myserver.com:~]/
What am I doing wrong?
Im using RHEL 5.2 + lastest Release cPanel version.
Thank you.