The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

pgsql missing dirs/conf?

Discussion in 'General Discussion' started by L4S, Aug 7, 2003.

Thread Status:
Not open for further replies.
  1. L4S

    L4S Well-Known Member

    Joined:
    Feb 23, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    I am unable to start the pgsql service. When i checked in /var/lib/pgsql/data the only contents is pg_hba.cnf.

    I have done a bit of research and i beleive that it should contain other folders /base /global /pg_clog etc...+many conf.

    How would i go about uninstalling and then reinstalling this product.


    Cheers,

    L4s..

    cPanel.net Support Ticket Number:
     
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Did you install it by rpm? If so, do:
    rpm -qa | grep postgre

    Then delete the ones that show up.

    For example:
    rpm -e postgresql-7.3.2-lib postgresql-7.3.2-devel

    But if I'm not mistaken, you have to initialize the database before those other files appear.
     
  3. L4S

    L4S Well-Known Member

    Joined:
    Feb 23, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    I have finally got the DB to initialize, i removed the /data contents and run the script ./installpostgres. This allowed the /dir to be correctly populated.

    I now have another prob though...
    ======================================
    Setting up Postgres Config...Done
    Reloading Postgres...postmaster successfully signaled
    Done
    Changing Password....psql: FATAL 1: IDENT authentication failed for user "postgres"

    Done
    Reloading Postgres...postmaster successfully signaled
    Done

    The Postgres Password has been changed
    ======================================
    I have made changes to the .conf as in the other posts, but seems to make no differance?

    Any ideas on this problem would be great.


    Thanks again,

    L4s.

    cPanel.net Support Ticket Number:
     
  4. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    I had this problem, too.
    Edit pg_hba.conf to say trust instead of password.
    Then, do the following commands from shell:
    (from http://linux.cvf.net/cp_postgresql.html)
    su - postgres
    psql template1 postgres

    You should see the following:

    Then do the following:
    UPDATE pg_shadow SET passwd = 'mypw';

    (Replace 'mypw' with your password.)

    Next, issue the following command to see if it worked:
    SELECT * from pg_shadow;

    If it's in there, you should not get the error anymore.
    Exit from the postgres user back to root and do:
    service postgresql restart

    Now, whether the database adds or not is a different story.:)

    cPanel.net Support Ticket Number:
     
  5. L4S

    L4S Well-Known Member

    Joined:
    Feb 23, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    Thanks Casey,

    Setting up Postgres Config...Done
    Reloading Postgres...postmaster successfully signaled
    Done
    Changing Password....Password:
    psql: FATAL 1: Password authentication failed for user "postgres"

    Done
    Reloading Postgres...postmaster successfully signaled
    Done

    The Postgres Password has been changed

    =====================================
    I seem to be missing template1, where should this be located.


    cPanel.net Support Ticket Number:
     
    #5 L4S, Aug 8, 2003
    Last edited: Aug 8, 2003
  6. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Well, I have template1 but things are still not working correctly. I think it's going to take a little more time.

    cPanel.net Support Ticket Number:
     
  7. L4S

    L4S Well-Known Member

    Joined:
    Feb 23, 2003
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    Thanks for your help casey...

    I have got phpPgAdmin to operate, i can now see my problem, when i view the DB in users Cpanel, they have no rights to create a DB, i receive a permission denied.

    I will look around in the .conf must be a setting that i have missed, other than that the only error is : authentication fail for user 'postgres'.

    Cheers Casey.

    cPanel.net Support Ticket Number:
     
  8. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Good luck. Let us know if you get it working.

    cPanel.net Support Ticket Number:
     
  9. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
Loading...
Thread Status:
Not open for further replies.

Share This Page