Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

pgSQL Database

Discussion in 'General Discussion' started by maxihost2, Aug 12, 2005.

  1. maxihost2

    maxihost2 Well-Known Member

    Feb 28, 2005
    Likes Received:
    Trophy Points:

    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

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice